Back up sql server 2005 database – Grass Valley K2 Storage System Instruction Manual v.3.3 User Manual
Page 529
June 25, 2009
K2 Storage System Instruction Manual
529
Backing up the media database
7. In the Backup Device Location dialog box, browse to your desired location to store
the database backup file. For example, you could store the database backup on the
E: partition.
NOTE: Do not store the backup file on the C: drive.
8. In the Backup Device Location dialog box, specify a file name with a “.bak”
extension and click
OK
. The Backup Device Location dialog box closes and reveals
the Select Backup Destination dialog box.
9. In the Select Backup Destination dialog box, click
OK
. The Select Backup
Destination dialog box closes and reveals the SQL Server Backup dialog box.
10.In the SQL Server Backup dialog box, click
OK
.
A Backup Progress dialog box displays progress as the backup process runs. When
finished, a “…completed successfully” message is displayed.
Back up SQL Server 2005 database
If the K2 Media Server has SQL Server 2005, 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 2005 | SQL Server Management Studio
. When prompted, click
Connect
to connect to the server. Management Studio opens.