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.
Содержание K2 BASECAMP EXPRESS
Страница 1: ...K2 STORAGE SYSTEM Instruction Manual SOFTWARE VERSION 3 2 071 8461 02 JULY 2007 ...
Страница 8: ...8 K2 Storage System Instruction Manual July 3 2007 Contents ...
Страница 14: ...14 K2 Storage System Instruction Manual July 3 2007 Safety Summaries ...
Страница 20: ...20 K2 Storage System Instruction Manual July 3 2007 Finding Information ...
Страница 24: ...24 K2 Storage System Instruction Manual July 3 2007 Chapter 1 Product Description ...
Страница 67: ...July 3 2007 K2 Storage System Instruction Manual 67 ...
Страница 68: ...68 K2 Storage System Instruction Manual July 3 2007 Chapter 2 Installing the Level 2 Storage System ...
Страница 172: ...172 K2 Storage System Instruction Manual July 3 2007 Chapter 4 Installing the Level 3 Storage System ...
Страница 236: ...236 K2 Storage System Instruction Manual July 3 2007 Chapter 5 Installing the Level 3R Storage System ...
Страница 282: ...282 K2 Storage System Instruction Manual July 3 2007 Chapter 6 Installing the Nearline Storage System ...
Страница 294: ...294 K2 Storage System Instruction Manual July 3 2007 Chapter 7 Description of K2 Storage Devices ...
Страница 300: ...300 K2 Storage System Instruction Manual July 3 2007 Chapter 8 Overview of K2 Storage Tools ...
Страница 390: ...390 K2 Storage System Instruction Manual July 3 2007 Chapter 11 Administering and maintaining the K2 Storage System ...