beautypg.com

Back up sql server 2005 database – Grass Valley K2 Storage System Instruction Manual v.3.3 User Manual

Page 529

background image

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.