Avid® Unity™ MediaManager
Administration Guide
Release 1.0
for the Windows NT® Operating System
a
tools for storytellers™
Copyright and Disclaimer
Product specifications are subject to change without notice and do not represent a commitment on
the part of Avid Technology, Inc. The software described in this document is furnished under a
license agreement. The software may not be reverse assembled and may be used or copied only in
accordance with the terms of the license agreement. It is against the law to copy the software on any
medium except as specifically allowed in the license agreement. Avid products or portions thereof
are protected by one or more of the following United States patents: 4,746,994; 4,970,663;
5,045,940; 5,063,448; 5,077,604; 5,245,432; 5,267,351; 5,309,528; 5,325,200; 5,355,450;
5,396,594; 5,440,348; 5,452,378; 5,467,288; 5,513,375; 5,528,310; 5,557,423; 5,568,275;
5,577,190; 5,583,496; 5,584,006; 5,627,765; 5,634,020; 5,640,601; 5,644,364; 5,654,737;
5,701,404; 5,715,018; 5,719,570; 5,724,605; 5,726,717; 5,729,673; 5,731,819; 5,745,637;
5,752,029; 5,754,180; 5,754,851; 5,781,188; 5,799,150; 5,812,216; 5,828,678; 5,842,014;
5,852,435; 5,883,670; 5,889,532; 5,892,507; 5,905,841; 5,912,675; 5,929,836; 5,929,942;
5,930,445; 5,930,797; 5,946,445; D352,278; D372,478; D373,778; D392,267; D392,268; D392,269;
D395,291; D396,853; D398,912. Additional U.S. and foreign patents pending. No part of this
document may be reproduced or transmitted in any form or by any means, electronic or
mechanical, including photocopying and recording, for any purpose without the express written
permission of Avid Technology, Inc.
© 1999 Avid Technology, Inc. All rights reserved. Printed in USA.
The following disclaimer is required by Apple Computer, Inc.
APPLE COMPUTER, INC. MAKES NO WARRANTIES WHATSOEVER, EITHER EXPRESS OR
IMPLIED, REGARDING THIS PRODUCT, INCLUDING WARRANTIES WITH RESPECT TO ITS
MERCHANTABILITY OR ITS FITNESS FOR ANY PARTICULAR PURPOSE. THE EXCLUSION OF
IMPLIED WARRANTIES IS NOT PERMITTED BY SOME STATES. THE ABOVE EXCLUSION MAY NOT
APPLY TO YOU. THIS WARRANTY PROVIDES YOU WITH SPECIFIC LEGAL RIGHTS. THERE MAY
BE OTHER RIGHTS THAT YOU MAY HAVE WHICH VARY FROM STATE TO STATE.
The following disclaimer is required by Sam Leffler and Silicon Graphics, Inc. for the
use of their TIFF library:
Copyright © 1988-1997 Sam Leffler
Copyright © 1991-1997 Silicon Graphics, Inc.
Permission to use, copy, modify, distribute, and sell this software [i.e., the TIFF library] and its
documentation for any purpose is hereby granted without fee, provided that (i) the above copyright
notices and this permission notice appear in all copies of the software and related documentation,
and (ii) the names of Sam Leffler and Silicon Graphics may not be used in any advertising or
publicity relating to the software without the specific, prior written permission of Sam Leffler and
Silicon Graphics.
THE SOFTWARE IS PROVIDED “AS-IS” AND WITHOUT WARRANTY OF ANY KIND, EXPRESS,
IMPLIED OR OTHERWISE, INCLUDING WITHOUT LIMITATION, ANY WARRANTY OF
MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.
IN NO EVENT SHALL SAM LEFFLER OR SILICON GRAPHICS BE LIABLE FOR ANY SPECIAL,
INCIDENTAL, INDIRECT OR CONSEQUENTIAL DAMAGES OF ANY KIND, OR ANY DAMAGES
WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER OR NOT
ADVISED OF THE POSSIBILITY OF DAMAGE, AND ON ANY THEORY OF LIABILITY, ARISING OUT
OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
The following disclaimer is required by the Independent JPEG Group:
Portions of this software are based on work of the Independent JPEG Group.
The following disclaimer is required by Paradigm Matrix:
Portions of this software licensed from Paradigm Matrix.
The following disclaimer is required by Ray Sauers Associates, Inc.:
“Install-It” is licensed from Ray Sauers Associates, Inc. End-User is prohibited from taking any
action to derive a source code equivalent of “Install-It,” including by reverse assembly or reverse
compilation, Ray Sauers Associates, Inc. shall in no event be liable for any damages resulting from
reseller’s failure to perform reseller’s obligation; or any damages arising from use or operation of
reseller’s products or the software; or any other damages, including but not limited to, incidental,
direct, indirect, special or consequential Damages including lost profits, or damages resulting from
loss of use or inability to use reseller’s products or the software for any reason including copyright or
patent infringement, or lost data, even if Ray Sauers Associates has been advised, knew or should
have known of the possibility of such damages.
The following disclaimer is required by Videomedia, Inc.:
“Videomedia, Inc. makes no warranties whatsoever, either express or implied, regarding this
product, including warranties with respect to its merchantability or its fitness for any particular
purpose.”
“This software contains V-LAN ver. 3.0 Command Protocols which communicate with V-LAN ver. 3.0
products developed by Videomedia, Inc. and V-LAN ver. 3.0 compatible products developed by
third parties under license from Videomedia, Inc. Use of this software will allow “frame accurate”
editing control of applicable videotape recorder decks, videodisc recorders/players and the like.”
The following notice is required by Altura Software, Inc. for the use of its Mac2Win
software and Sample Source Code:
©1993–1998 Altura Software, Inc.
The following notice is required by Number Nine Visual Technology Corporation for the
use of its Number Nine software drivers:
©1992–1997 Number Nine Visual Technology Corporation. The original Number Nine software
drivers have been modified by Avid Technology, Inc.
Attn. Government User(s). Restricted Rights Legend
U.S. GOVERNMENT RESTRICTED RIGHTS. This Software and its documentation are “commercial
computer software” or “commercial computer software documentation.” In the event that such
Software or documentation is acquired by or on behalf of a unit or agency of the U.S. Government,
all rights with respect to this Software and documentation are subject to the terms of the License
Agreement, pursuant to FAR §12.212(a) and/or DFARS §227.7202-1(a), as applicable.
Trademarks
AirPlay, AudioVision, Avid, CamCutter, Digidesign, FieldPak, Film Composer, HIIP,
Image Independence, Marquee, Media Composer, Media Recorder, NewsCutter, OMF,
OMF Interchange, Open Media Framework, Pro Tools, and Softimage are registered trademarks and
888 I/O, AniMatte, AudioSuite, AutoSync, AVIDdrive, AVIDdrive Towers, AvidNet, AVIDstripe,
Avid Unity, Avid Xpress, AVX, DAE, D-Fi, D-FX, D-Verb, ExpertRender, FilmScribe, Intraframe, iS9,
iS18, iS23, iS36, Lo-Fi, Magic Mask, Matador, MCXpress, MEDIArray, MediaDock,
MediaDock Shuttle, Media Fusion, Media Illusion, MediaLog, Media Reader, MediaShare, Meridien,
NaturalMatch, OMM, QuietDrive, Recti-Fi, rS9, rS18, Sci-Fi, Sound Designer II, Symphony,
tools for storytellers, Vari-Fi, and Video Slave Driver are trademarks of Avid Technology, Inc., or its
subsidiaries or divisions.
Windows NT is a registered trademark of Microsoft Corporation. All other trademarks contained
herein are the property of their respective owners.
Avid Unity MediaManager Administration Guide • Part 0130-04411-01 Rev. A •
December 1999
Contents
Using This Guide
Who Should Use This Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
About This Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
Symbols and Conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viii
If You Need Help. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viii
Related Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix
If You Have Documentation Comments . . . . . . . . . . . . . . . . . . . . . . . . . x
How to Order Documentation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . x
Chapter 1 Getting Started
Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2
Database Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2
Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2
Accessing and Logging in to MediaManager . . . . . . . . . . . . . . . . . . . 1-3
Starting Internet Explorer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3
Configuring Internet Explorer to Work with
MediaManager (First Time Only). . . . . . . . . . . . . . . . . . . . . . . . 1-3
Opening MediaManager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-6
Logging In as Administrator. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-6
User Interface Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-8
Administration Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-9
Logging Out . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-9
vi
Chapter 2 Managing User Accounts
Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-2
MediaManager Privilege Levels . . . . . . . . . . . . . . . . . . . . . . . . . . 2-2
The User Browser. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-2
Creating User Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-3
Editing User Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-4
Deleting User Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-6
Chapter 3 MediaManager Maintenance Tasks
MediaManager Maintenance Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-2
Database Maintenance Tasks and Schedule . . . . . . . . . . . . . . . . 3-2
Performing Database Maintenance Tasks . . . . . . . . . . . . . . . . . . 3-3
Managing Database Size . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-3
Checking Available Drive Space . . . . . . . . . . . . . . . . . . . . . . . . . . 3-4
Purging Media Objects from MediaManager. . . . . . . . . . . . . . . . . . . 3-4
Consistency Checking . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-5
MediaManager Data Backup and Restore. . . . . . . . . . . . . . . . . . . . . . 3-6
Specifying the Location for MediaManager Backup Files. . . . . 3-6
Backing Up the MediaManager Data . . . . . . . . . . . . . . . . . . . . . . 3-7
Restoring the MediaManager Data. . . . . . . . . . . . . . . . . . . . . . . . 3-9
Restarting the MediaManager. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-10
Using This Guide
Congratulations on your purchase of Avid Unity™ MediaManager
Release 1.0, a powerful tool for managing media in an Avid Unity
MediaNet shared storage environment.
Who Should Use This Guide
This guide is intended for MediaManager administrators responsible
for the setup and day-to-day operation of MediaManager in an Avid
Unity MediaNet environment.
About This Guide
The Contents lists all topics included in the book. They are presented
with the following overall structure:
•The Getting Started chapter helps you get oriented with beginning
concepts and general work flow, and provides valuable pointers
as you proceed.
• The main body of the guide follows the natural flow of your work,
with clear and comprehensive step-by-step procedures.
viii
Symbols and Conventions
The Avid Unity MediaManager documentation uses the following
special symbols and conventions:
1. Numbered lists, when the order of the items is important.
a. Alphabetical lists, when the order of secondary items is
important.
• Bulleted lists, when the order of the items is unimportant.
- Indented dashed lists, when the order of secondary items is
unimportant.
Look here in the margin
for tips.
n
c
In the margin, you will find tips that help you perform tasks more
easily and efficiently.
A note provides important related information, reminders, recommendations,
and strong suggestions.
A caution means that a specific action you take could cause harm to
your computer or cause you to lose data.
If You Need Help
If you are having trouble using Avid Unity MediaManager, you
should:
1. Retry the action, carefully following the instructions given for that
task in this guide.
2. Check the documentation that came with your hardware for
maintenance or hardware-related issues.
3. Check the Customer Service and News + Publications sections of
the Avid Web site at www.avid.com for the latest FAQs, Tips &
Techniques, Film + Television Update, and other Avid online
offerings.
Using This Guide
ix
4. Check the Avid Bulletin Board, “Avid Online,” for information on
product and user conferences. If you do not find the solution to
your problem, you can exchange information with other Avid
customers and Avid Customer Support representatives.
5. Contact your local Avid Reseller; in North America, you may
contact Avid Customer Support at 800-800-AVID (2843).
n
For general information, call your local Avid Reseller; in North America, call
the Avid Customer Relations Desk at 800-894-5654.
Related Information
The following documents provide more information about Avid Unity
MediaManager:
• Avid Unity MediaManager User’s Guide
• Avid Unity MediaManager Release 1.0 Release Notes
• Avid Products Collaboration Guide, which provides step-by-step
instructions for transferring project files, audio files, and graphics
and effects files between various Avid products
The most recent update of the Avid Products Collaboration Guide is
available in the Documentation section of the Avid Customer Service
Knowledge Center. To access the Avid Customer Service Knowledge
Center, click the Avid Customer Service link at www.avid.com and
select Knowledge Center.
Related Information
x
If You Have Documentation Comments
Avid Technology continuously seeks to improve its documentation.
We value your comments about this guide, the Help, the Online
Publications CD-ROM, and other Avid-supplied documentation.
Simply e-mail your documentation comments to Avid Technology at
TechPubs@avid.com
Please include the title of the document, its part number, revision, and
the specific section you are commenting on in all correspondence.
How to Order Documentation
To order additional copies of this documentation from within the
United States, call Avid Telesales at 800-949-AVID (2843). If you are
placing an order from outside the United States, contact your local
Avid representative.
Using This Guide
CHAPTER 1
Getting Started
Avid Unity MediaManager is a media management tool that allows
MediaNet clients to search the large number of media objects (master
clips, sequences, effects, and any other type of object that references
digital media) in the Avid Unity MediaNet shared storage environment.
The MediaManager database resides on a dedicated Windows NT
system, apart from the MediaNet Server so that database load can
never impact critical file system operations.
This chapter discusses the following topics:
• Overview
• Accessing and Logging in to MediaManager
• User Interface Overview
• Administration Tasks
• Logging Out
1-2
Overview
The MediaManager is based on Microsoft SQL Server 7.0. It manages
its database by adding, removing, and modifying objects and records
in the database in response to client requests. It consists of two major
components:
• Database services — The software applications that drive the
• Data — The information about media objects physically stored on
Database Services
The MediaManager is implemented using a number of Windows NT
services on the MediaManager Server system. The main database service is listed in the Services control panel as “MSSQLServer.” Ancillary
services also required for MediaManager operation are “IIS Admin
Service” and World Wide Web Publishing Service
database functions.
drives (optionally mirrored for data security).
Data
Getting Started
The database data is stored on one or more drives, depending on
whether you have a server configuration that supports mirroring
(duplication of the data on multiple drives in a redundant configuration). In a mirrored configuration, if one data drive fails, the mirror
drive is automatically used instead.
For every media object, the database stores an associated record that
contains specific information about the object. Information in each
record is recorded as a predetermined set of attributes. Each attribute
describes a feature of the object: for example, its name, creation date,
or tape ID. When you initiate a search, the MediaManager finds the
records with the attributes you specify, and then lists the associated
objects.
Accessing and Logging in to MediaManager
The MediaManager is accessed via a user interface (UI) implemented
as a dynamic Web page that is accessed by opening it in Internet
Explorer 5.0, an industry standard Web-browser. This allows easy
access without the need to install and run more special software on
your Avid system.
For an overview of how to use the MediaManager for administrative
purposes, see “User Interface Overview” on page 1-8. For more
information about the user interface, see the Avid Unity MediaManager
User’s Guide.
This section describes how to start Internet Explorer, open the
MediaManager Web page, and then log in.
Starting Internet Explorer
1-3
To start Internet Explorer, click the Start button and then click Internet
Explorer. Internet Explorer starts and opens your default home page.
Configuring Internet Explorer to Work with MediaManager (First Time Only)
Before you access MediaManager for the first time, you need to
configure Internet Explorer appropriately first.
To configure Internet Explorer for MediaManager access:
1. Choose Internet Options from the Tools menu. The Internet
Options dialog box appears.
Accessing and Logging in to MediaManager
1-4
2. Click the Security tab. The Security tab opens, providing access to
the Internet Explorer security options.
3. Select the Local Intranet Web content zone by clicking the
appropriate icon.
Getting Started
4. Click the Custom Level button. The Security Settings dialog box
appears.
5. Set the appropriate options in the Security Settings dialog box. See
Table 1-1 for details.
Table 1-1 Internet Explorer Security Settings for
MediaManager
ActiveX Controls and Plug-ins Options Setting
Download signed ActiveX controls Prompt
Download unsigned ActiveX controls Enable
Initialize and script ActiveX controls not marked as safe Disable
Run ActiveX controls and plug-in Enable
Script ActiveX controls marked safe for scripting Enable
6. Click OK to save your changes and close the Security Settings
dialog box. A warning dialog box appears, prompting you to
confirm that you want to change the security settings for the zone.
Click Yes to proceed.
1-5
7. Click OK in the Internet Options dialog box to complete the
Internet Explorer security configuration for MediaManager.
Accessing and Logging in to MediaManager
1-6
Opening MediaManager
To open the MediaManager, you first need to obtain its URL from your
site administrator. A typical example is:
http://ummserver/omm/
To open the page in Internet Explorer, choose Open from the File menu
(or press Ctrl+O), type the URL supplied to you by your administrator
in the Open dialog box that opens, and then click OK. Alternatively, if
the Address toolbar is open, you can simply type the URL there and
press Enter.
n
After you open the MediaManager page for the first time by specifying its
address manually, you might want to set it as your default home page or
bookmark it for easy access. For more information, see the Microsoft Internet
Explorer online help.
Logging In as Administrator
Each time the MediaManager is opened, it presents a login screen,
prompting you to enter a user name and password. To gain access to
the MediaManager’s administrative functions, you must supply a user
name with administrative privileges. Once logged in as administrator,
you can access all of the standard MediaManager functionality as well
as its administrative functions. Figure 1-1 shows the MediaManager
login screen.
n
The MediaManager comes preconfigured with a default administrative
account (Administrator) with no associated password to allow you to log in
for the first time. Once you have logged in, Avid recommends that you
immediately specify a password for this account to prevent unauthorized
users from gaining administrative access to the MediaManager.
Getting Started
1-7
Figure 1-1 Avid Unity MediaManager Login Screen
Enter any user name and password with administrative privileges in
the text boxes, and then click Login. The first time you need to login
(prior to setting up user accounts), specify user name Administrator
with no password.
If both are accepted, the full MediaManager user interface will appear,
automatically running a default search to find any media objects
added to its database in the last 10 minutes.
Accessing and Logging in to MediaManager
1-8
User Interface Overview
You can access the MediaManager user interface to perform
administrative functions from the MediaManager Server or any
system running Internet Explorer 5.0 that has a TCP/IP network
connection to the MediaManager Server by simply opening the
appropriate dynamic Web page in Internet Explorer.
Mode selector
(click to determine
the mode-related
controls to display)
User browser
Administration
task list
Getting Started
The user interface has several modes that you choose by clicking the
appropriate entry in the Mode selector, which provide access to the
MediaManager’s most commonly used functions. As administrator,
you will primarily be interested in Administration mode, which
provides access to the User browser and the Administration task list.
For more information about the other MediaManager modes (Search,
Project, and Catalog modes), see the Avid Unity MediaManager User’s
Guide.
Administration Tasks
As administrator of MediaManager, you are responsible for:
• Creating, editing, and deleting user accounts. You must establish
an account for each client user that needs to access the
MediaManager database. For more information, see Chapter 2.
• Purging media objects from the database. MediaManager users
cannot delete media objects from the database — they are only
able to mark those objects that they don’t need for deletion. You
must purge these objects to actually remove them from
MediaManager. For more information, see “Purging Media
Objects from MediaManager” on page 3-4.
• Backing up the database. Backing up the database regularly
protects your data, allowing you to restore the database to a saved
state in the event of failure. For more information, see
“MediaManager Data Backup and Restore” on page 3-6.
• Other routine maintenance tasks. Other routine maintenance
tasks include checking the database size, performing consistency
checks, and periodically rebooting the server. For more
information, see Chapter 3.
1-9
Logging Out
n
You should log out of MediaManager when you are finished using it
rather than leaving it open or accessing another page in Internet
Explorer. To log out, click Help in the MediaManager banner.
MediaManager logs you out and the login screen opens.
If your MediaManager session is idle for more than 30 minutes, it will
automatically time-out and log you out to make your license available for
other users. If this happens, you will need to start a new session by logging
back in.
Administration Tasks
1-10
Getting Started
CHAPTER 2
Managing User Accounts
User accounts are used to control access to MediaManager. This
chapter describes how to create, edit, and delete user accounts so that
all authorized MediaNet client users can access MediaManager.
This chapter discusses the following topics:
• Overview
• Creating User Accounts
• Editing User Accounts
• Deleting User Accounts
2-2
Overview
You must create a user account for each MediaNet client user and
anyone else who needs to access MediaManager.
n
To simplify user access and administration, create MediaManager user
accounts with the same names and passwords as MediaNet user accounts.
MediaManager Privilege Levels
Each user account has an associated privilege level that determines
whether the user logging in to that account has regular or
administrative privileges to MediaManager.
n
Avid recommends that you restrict administrative privileges to designated
administrators who absolutely need to perform the administrative tasks
described in this book.
The User Browser
You use the User browser when MediaManager is in Administration
mode to view, create, delete, and edit user accounts. Figure 2-1 shows
an example User browser display.
New User icon
Trash icon
Notepad icon
Managing User Accounts
User name
User Icon
Figure 2-1 Example User Browser Display
The topics in the remainder of this chapter describes how to use the
User browser to manage your MediaManager user accounts.
Creating User Accounts
To create a user account:
1. Click the New User icon in the User browser header.
The Create User dialog box appears.
2-3
Creating User Accounts
2-4
2. Specify the standard user account attributes by typing in the
appropriate text boxes:
• Name — The account name (login name).
• Password — The login password. Type the required password
identically in both the Password and Re-Type Password text
boxes.
• Real Name (optional) — The user’s name.
• Description (optional) — A brief description of the user or
notes about the account’s purpose (for example, the user’s
title, role, client type, and so on).
3. Choose the user account privilege level (Regular User or
Administrator) from the Privilege pop-up menu.
4. Click Save.
The new user account is created and added to the User browser list.
Editing User Accounts
To edit a user account:
1. Click a user name (or the User icon or Notepad icon that appear
beside a user name) in the User browser. (To edit your own user
account, you can also click the “Click here
hot link that appears in the Administration task list.)
The Edit User dialog box appears.
Managing User Accounts
to edit your ‘User Info’”
2-5
n
1. Edit the standard user account attributes that you want to change
by typing in the appropriate text boxes:
You cannot edit the account name. To change an account name, you must
create a new user account with the required name and attributes.
• Password — The login password. Type the required password
identically in both the Password and Re-Type Password text
boxes.
• Real Name (optional) — The user’s name.
Editing User Accounts
2-6
• Description (optional) — A brief description of the user or
notes about the account’s purpose (for example, the user’s
title, role, client type, and so on).
2. If necessary, modify the user account privilege level (Regular User
or Administrator) by choosing an item from the Privilege pop-up
menu.
3. Click Save.
The user account is modified.
Deleting User Accounts
To delete a user account, click the Trash icon beside the user name. A
dialog box appears, prompting you to confirm that you want to
proceed with deleting the user account. Click OK to proceed.
Managing User Accounts
The user account is deleted.
CHAPTER 3
MediaManager Maintenance Ta s k s
Although you should not often encounter any problems with the
MediaManager, you must perform a few routine administrative tasks
to maintain the health of the database. Additionally, there are some
procedures that you might need to perform if problems do occur.
This chapter discusses the following topics:
• MediaManager Maintenance Tasks
• Managing Database Size
• Purging Media Objects from MediaManager
• Consistency Checking
• MediaManager Data Backup and Restore
• Restarting the MediaManager
3-2
MediaManager Maintenance Tasks
The MediaManager is a Microsoft SQL Server database running on a
Windows NT system set up as a dedicated server system.
c
c
Do not run any other applications on the database server. They
might interfere with operation of the database and slow its response
time.
You should not use any SQL Server tools other than those described
in this chapter to administer the MediaManager — you may corrupt
your data.
The Microsoft SQL Server service starts when the MediaManager
Server system is started.
Database Maintenance Tasks and Schedule
There are a few administrative tasks that you must perform to
maintain the health of the MediaManager database:
• Regularly check the amount of free space on the MediaManager
server data drives and purge media objects marked for deletion by
users. For details, see “Managing Database Size” on page 3-3.
• Check the consistency of the database daily. For details, see
“Consistency Checking” on page 3-5.
• Back up the MediaManager daily to protect your data. For details,
• Reboot the MediaManager server once a week.
If the database ever crashes or shuts down, you should investigate the
reason for the problems, make repairs, and then restart the database
service. See “Restarting the MediaManager” on page 3-10.
MediaManager Maintenance Tasks
see “MediaManager Data Backup and Restore” on page 3-6.
Performing Database Maintenance Tasks
You perform most database maintenance tasks using functions
available from the Administration task list, which appears when
MediaManager is in Administration mode. Figure 3-1 shows the
Administration task list.
Figure 3-1 Administration Task List
3-3
Managing Database Size
The MediaManager database has no preset maximum size; it is only
really constrained by the amount of drive space that you have
available to accommodate data. Although the MediaManager
database should have enough space to accommodate approximately
100,000 media objects, the actual number of objects that can be stored
in the MediaManager depends to some extent on:
• Your MediaManager drive configuration. If you have a server
configuration in which MediaManager data is stored on the same
drive as the system and database software, there will be less space
available to accommodate database records.
• The number and complexity of sequences that have been checked
in. A record representing a sequence with 1000 cuts takes more
space than one representing a sequence with three cuts.
When the drive or drives containing the MediaManager data are close
to getting full, you should ask users to go through their checked-in
Managing Database Size
3-4
objects and mark those no longer required for deletion. You can then
purge these objects to free up space (see “Purging Media Objects from
MediaManager” on page 3-4).
n
Do not assign MediaManager database data drives for temporary disk storage
or use them for shared public disk space.
Checking Available Drive Space
You should regularly check that there is sufficient available drive
space by looking at the MediaManager data drive properties. To do
this, right-click the appropriate drive entries from the Windows NT
My Computer or Explorer tool.
Purging Media Objects from MediaManager
For data security purposes, MediaManager users cannot delete media
objects from the database; they are only able to mark those objects for
deletion that they don’t need. To physically remove these objects and
free up the space they are using, you or another administrator must
purge them from MediaManager.
To purge media objects marked for deletion from MediaManager:
1. Optionally, select Catalog mode and check the Wastebasket
2. Select Administration mode and click the “Click here
MediaManager Maintenance Tasks
catalog to see which objects are marked for deletion and, if
necessary, remove any that you do not think should be deleted.
For more information on how to do this, see the Avid Unity
MediaManager User’s Guide.
to purge any
deleted clips” hot link.
The Purge Deleted Clips dialog box opens, listing all the media
objects marked for deletion (that is, assigned to the Wastebasket
catalog).
3. To purge the listed media objects, click Continue.
The listed media objects are permanently deleted from
MediaManager’s database.
3-5
Consistency Checking
Hardware problems (disk failures) and operating system problems
(such as a system panic) may cause consistency problems in the
database. You should periodically verify that your database is
consistent by using the SQL Server Query Analysis tool installed with
SQL server 7.0 (see “Database Maintenance Tasks and Schedule” on
page 3-2).
To check the consistency of the database:
1. Start the SQL Server Query Analyzer by clicking Start, pointing to
Programs, pointing to Microsoft SQL Server 7, and then selecting
Query Analyzer. A login dialog box appears.
2. Log in to the database as user sa, with the appropriate password.
Consistency Checking
3-6
The SQL Server Query Analyzer starts and displays a new query
window.
3. Type the following in the query window:
MediaManager_Database_Name
use
4. Press F5 to run the query.
The results appear in the lower panel window.
SQL server should able to fix and recover from most errors that it
finds. If the search returns any data corruption from which it cannot
recover, you should search for warning messages that might provide
additional information about the problem and might be useful to Avid
Customer Support, and then contact them for help. You will then
probably need to restore your database from a recent backup (see
“Restoring the MediaManager Data” on page 3-9).
; dbcc checkdb
MediaManager Data Backup and Restore
Avid recommends that you back up the entire MediaManager
database daily. You use the MediaManager tool to perform all backup
and restore operations.
Specifying the Location for MediaManager Backup Files
To specify the location in which to store MediaManager backup files:
1. Click the “Click here
MediaManager Maintenance Tasks
to set where to store the backup files” hot
link in the Administration task list.
The Backup Location dialog box appears.
3-7
2. Specify the location (drive and directory) for your MediaManager
backup files. The default directory is C:\backup. This location can
be a tape drive or other removable media device but not a network
drive remote from the MediaManager Server.
n
The backup location is on the MediaManager Server; it is not on local drives
if you are accessing the MediaManager UI from a client system.
3. Click Submit.
The new location for MediaManager backup files is stored.
Backing Up the MediaManager Data
You should perform a complete backup of the MediaManager data
daily.
n
You should only back up the MediaManager when user activity is light
because it can take a long time and uses a significant amount of CPU
resources.
To back up the MediaManager data:
1. Click the “Click here to create database backup to a file” hot link in
the Administration task list. The Create Backup dialog box
appears.
MediaManager Data Backup and Restore
3-8
2. Create a new backup file name or select an existing one:
• To create a new backup, select New and then type the name of
the file in the text box.
3. Optionally, type a description to be associated with the backup in
4. Click Start.
The backup procedure begins. It can take a long time. For example,
backing up the database takes about 50 minutes for 40,000 media
objects when the MediaManager server is a 500-MHz Pentium II, your
configuration is not mirrored, and uses a single drive for data.
MediaManager Maintenance Tasks
• To overwrite an existing backup file, select Existing and then
choose an existing file from the pop-up menu that appears.
the Description text box.
Restoring the MediaManager Data
If the database loses its data or becomes corrupted for any reason, you
will need to copy the data from your most recent database backup files
back to the database. (This is known as restoring the database.)
To restore the MediaManager database:
1. Check that the specified backup location (see “Specifying the
Location for MediaManager Backup Files” on page 3-6) contains
the backup file that you want to restore.
2. Click the “Click here to query and restore the database from
backup file” hot link in the Administration task list. The Restore
From Backup dialog box appears.
3-9
3. Choose the backup file to be restored from the Backup File pop-up
menu. Any description associated with the chosen backup file
appears in the Description text box.
MediaManager Data Backup and Restore
3-10
4. Specify the directory in which the existing MediaManager
database is installed by typing it in the Database Directory text
box (for example C:\MSSQL\data).
5. Specify a temporary database name to create from the backup file
by typing it in the Database Name text box. The name must be
unique (different than the current database name).
6. Specify the SQL Server database access password (the password
associated with the sa account for the SQL Server database) by
typing it in the DBA Password text box.
7. Click Restore.
A progress indicator appears, and then a dialog appears
displaying the numbers of different types of media object in the
database being restored.
8. If the database being restored is correct, click Accept to override
the current database. Otherwise, click Cancel to stop the restore
operation.
c
Proceeding with the restore operation will overwrite your existing
database. If you want to preserve it, you should back up your
database before completing the restore.
If you clicked Accept, the database restore operation proceeds,
copying the xml and headframe files from the backup file to the
appropriate directories. This can take a long time, depending on
the number of objects in the database being restored. When the
operation is complete, a dialog box appears informing you of this.
9. Restart the MediaManager Server.
Restarting the MediaManager
To restart the MediaManager if it ever fails, simply reboot the
MediaManager Server.
MediaManager Maintenance Tasks
Loading...