Grass Valley NewsBrowse Desktop Browsing System Installation v.2.7 - Manual (Page 126)

126 NewsBrowse Installation and Configuration Guide December 16, 2004
Chapter 4 Recovery Planning
2000 Database Maintenance Planner wizard make sure that the
SQLSERVERAGENT service is started and its properties are set to auto start for a
local system account. If the SQLSERVERAGENT is not running, the database
maintenance plan will not run. The following steps describe how to launch and
configure the SQL 2000 Database Maintenance Planner:
1. Open SQL 2000 Enterprise Manager.
2. Expand Microsoft SQL Servers, expand the SQL Server Group and select the SQL
server.
3. On the Tools menu, click Database Maintenance Planner…
4. After the wizard launches click the Next> button.
5. Select These databases radio button and select the MediaFrame and NBIngest
databases.
6. Click the Next> button to navigate to the Update Data Optimization Information page.
7. Select the Update statistics used by query optimizer. Sample check box and set it to
10% of the database.
8. Check the schedule to verify that the time scheduled will not conflict with peak
usage of the system. If a schedule time change is needed, click the Change… button
to modify the time. This option can be run daily but once a week is good.
9. Click the Next> button to navigate to the Database Integrity Check page.
10.Select the Check database integrity check box.
11.Select the Include indexes radio button.
12.Select the Attempt to repair any minor problems check box.
13.Select the Perform these checks before doing backups check box.
14.Check the schedule to verify that the time scheduled will not conflict with peak
usage of the system. If a schedule time change is needed, click the Change… button
to modify the time. This option can be run daily but once a week is good.
15.Click the Next> button to navigate to the Specify the Database Backup plan page.
16.Select Back up the database as part of the maintenance plan check box.
17.Select Verify the integrity of the backup when complete check box.
18.Select the Disk radio button
19.Change the schedule from once a week to daily by clicking the Change… button.
20.Select the Daily radio button and set the interval to Every 1 day(s) .
21.Select the Occurs once at radio button. If the default time of 2:00:00 AM is not
good, change it to a more suitable time.
22.Make sure that the Start Date is today's date and that the No end date radio buttons
are selected.
23.Click the OK button and verify the schedule.
24.Click the Next> button to navigate to the Specify Backup Disk Directory page.