Database restore server restore, Best practices, Database restore – VBrick Systems VOD-W Server VBrick v4.2.1 User Manual

Page 33: Server restore

Advertising
background image

Server Administration

VOD-W Admin Guide

25

any content. In order to back up content, you need a separate backup strategy and a robust
storage capability.

T

To run an on-demand database backup:

1. Go to

Start > Control Panel > Scheduled Tasks

.

2. Right-click on

dbbackup

and select

Run

.

3. When done, right-click on

dbdelete

and select

Run

.

4. (You can also modify the backup schedule as desired. Left-click on

dbbackup

and click

on the

Schedule

tab to modify the backup schedule.)

Database Restore

It is unlikely you will ever need to restore the database except in the context of a system crash
in which case you will need to restore the entire server (see Server Restore), including the
database.

T

To restore the database:

1. Go to

C:\Database_Scripts

and double-click on

Restore_Database.bat

. This will restore

the most recent database backup file (

QVIDB_1.dat_bak

). To restore a different backup

file, edit

Restore_Database.sql

and then run the restore script.

2. Wait for the restore to complete, then go to

C:\Database_Scripts

and double-click on

Remove_Add_QVIDBUser.bat

. After this file runs, the database restore is complete.

Server Restore

VBrick and Dell installation CDs are shipped with the server in case the software ever needs
to be restored (see Reinstalling the Software on page 47 for complete details). Note that this
"Server Restore" refers to the server and operating system software only—not to the
database or to any content on the server.

Table 5. Installation CD Contents

Best Practices

All video assets stored on the server should have backup copies available in the event of
disk corruption. This will allow for an easy restoral.

CD-ROM

What it does

Dell Recovery CDs

Restore the Windows 2003 Server Web Edition operating system.

VOD-W Server
Product CD

Installs the following software:

• QuickVideo Content Server application.
• Multicast joiner service and SQL redistribution.
• Database backup utility.
• Configures IIS with ASP.NET, FTP, and creates an FTP account

with a home directory in

e:\StagingArea

• Demo content available. If restoring the server, you must use the

manual ingestion utility to ingest this content (see Manually
Ingesting Content on page 23 fo
r details)

VOD-W License CD Contains a license file (matching your dongle key) that you will need

when reinstalling the VOD-W software.

Advertising