Back up sql server 2005 database – Grass Valley K2 Storage System Instruction Manual v.3.2 Aug.01 2007 User Manual

Page 362

Advertising
background image

362

K2 Storage System Instruction Manual

July 3, 2007

Chapter 11 Administering and maintaining the K2 Storage System

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.

2. In Management Studio, expand the tree view and open the

Databases

node.

3. In the Management Studio tree view, right-click the

media

node and select

Tasks |

Backup

. The Back Up Database dialog box opens.

Advertising