E-mail
 | Warning: MS SQL Server 2000 is no longer supported by MetaCommunications products. This information is retained for customers using older versions. |
- Open Microsoft SQL Server 2000 Enterprise Manager, log in, and navigate to the database you want to back up.
- Right click the database you want to back up. A context menu will appear.
- Select All Tasks and Backup Database... in the context menu. The SQL Server Backup window will open.
- Select the database you want to back up from the Database drop down list.
- Select “Full” from the Backup type drop down list in the Source group.
- Type a name for the backup in the Name field.
- Type a description for the backup in the Description field.
- Select the “Database - complete” radio button in the Backup group.
- Click Add in the Destination group. The Select Backup Destination window will open.
- Browse to and select the backup destination. The selected destination will appear in the File name field.
- Type the backup file name at the end of the destination appearing above. Make sure to use a “.bak” extension for the file name. The file name field should now look similar to what appears in the screen capture below.
- Click OK when finished defining the backup destination and file name. The Select Backup Destination window will close, returning you to the SQL Server Backup window.
- Select the Append to media radio button in the Overwrite group. This will ensure that the database backup is appended to any existing backup file with the same name as that specified in the steps above. If you elect to use the Overwrite setting, any existing backup files with the specified name will be overwritten with the new backup file.
- Click OK when done. A backup progress window will appear.
When the backup is complete, the Backup Progress window will close and a Backup Complete window will appear.
- Click OK in the Backup Complete window. The window will close and return you to the MS SQL Server 2000 Enterprise Manager.
At this point you have successfully created a full backup of your database. You can repeat this procedure for other MetaCommunications databases you want to back up.