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.
Summary of Contents for K2 BASECAMP EXPRESS
Page 1: ...K2 STORAGE SYSTEM Instruction Manual SOFTWARE VERSION 3 2 071 8461 02 JULY 2007 ...
Page 8: ...8 K2 Storage System Instruction Manual July 3 2007 Contents ...
Page 14: ...14 K2 Storage System Instruction Manual July 3 2007 Safety Summaries ...
Page 20: ...20 K2 Storage System Instruction Manual July 3 2007 Finding Information ...
Page 24: ...24 K2 Storage System Instruction Manual July 3 2007 Chapter 1 Product Description ...
Page 67: ...July 3 2007 K2 Storage System Instruction Manual 67 ...
Page 300: ...300 K2 Storage System Instruction Manual July 3 2007 Chapter 8 Overview of K2 Storage Tools ...