• Allocation and structural integrity of all the objects in the MVF database
• Consistency of disk space allocation structures for MVF database
• Consistency in and between system tables in the MVF database
To perform the database check
1. In the SQL Server Query Analyzer window, type the following, pressing
Enter
between each
command:
DBCC CHECKDB
GO
DBCC CHECKALLOC
GO
DBCC CHECKCATALOG('MVF')
GO
2. Click
Execute
.
Check the results and make sure the error is 0.
Backing up the database
11.
Create a backup of the database before upgrading the system. If you are backing up the database from
the command line, you must be in the SQL environment to run the backup command.
After the backup is complete, if you performed a backup to disk, copy the backup file to another location
on the network. If you performed a backup to tape, remove the tape from the drive.
To back up a database using the Enterprise Manager
1. Select
Start
>
All Programs
>
Microsoft SQL Server
>
Enterprise Manager
.
2. In the Explorer window of the Enterprise Manager, expand
Console Root
>
Microsoft SQL
Servers
>
SQL Server Group
>
<server>
>
Databases
>
<database name>
where
<server>
is the name of the SQL Server that the program is running under and
<database
name>
is the name of the database to be backed up.
3. Select
Action
>
All Tasks
>
Backup database
.
4. Configure the
General
and
Options
tabs according to your preferences for items such as the type
of backup, the destination, and whether to overwrite or append to the media.
Ensure that the
Verify upon completion
option is selected.
5. To start the backup, click
OK
.
6. Exit the SQL Server Enterprise Manager.
To back up the database from the command line
1. At a command prompt, type:
IMPAX 6.3 AS300 Installation Guide
73
