Grass Valley K2 Storage System Instruction Manual v.3.2 Aug.01 2007 - Manual (Page 359)

July 3, 2007 K2 Storage System Instruction Manual 359
Backing up the media database
Backing up the media database
On a K2 Storage System, you can back up the K2 media database as part of your
system recovery plan. When you back up the database, remember that you are backing
up only the records in the database. These records point to media files, but they are
not the actual media files themselves. Therefore when you backup the database only,
you are not backing up your media.
Use the following procedures to backup and restore the media database, depending on
the version of SQL Server:
• “Determining your SQL Server database version” on page 359
• “Back up SQL Server 2000 database” on page 359
• “Back up SQL Server 2005 database” on page 362
• “Restore SQL Server 2000 database” on page 365
• “Restore SQL Server 2005 database” on page 369
Determining your SQL Server database version
In 2007, K2 Media Servers began shipping from the factory with SQL Server 2005
installed. Prior to that time, SQL Server 2000 was installed. If you are not sure which
version is on your K2 Media Server, use the following procedure.
1. On the K2 Media Server, open the Windows Control Panel.
2. Open Add or Remove Programs .
3. Locate the Microsoft SQL Server program and identify the version.
Back up SQL Server 2000 database
If the K2 Media Server has SQL Server 2000, use the following procedure to back up
the media database.
If you have a redundant K2 Storage System, backup up the database on the K2 Media
Server that is the primary media file system/database server.
1. From the K2 Media Server Windows desktop, open Start | All Programs | Microsoft
SQL Server | Enterprise Manager . Enterprise Manager opens.
2. In Enterprise Manager, expand the tree view as follows:
Microsoft SQL Servers | SQL Server Group | (local) | Databases | media
3. In the Enterprise Manager tree view, right-click the media node and select All Tasks
| Backup Database . The SQL Server Backup dialog box opens.