The follow steps apply to SQL Server Management Studio 2005 - 2008r2. To back up a database, follow the below steps:
1. Open SQL Server Management Studio and connect to the server.
2. Expand Databases.
3. Right-click on the Momentus Enterprise database and select Tasks -> Back Up.
4. In the Source section, verify Backup Type is set to Full.
5. In the Destination section, select the Disk radio button.
6. To save the backup file to a location other than the default, click the Remove button.
7. Once the location has been removed, click the Add button.
8. Browse to the location for the backup file.
9. In the Files of type field, select Backup Files (*.bak; *.trn).
10. Enter a File name, including the file extension. For example, USIbackup.bak.
11. On the left side of the Back Up Database screen, select Options.
12. In the Overwrite media section, select to Back up to the existing media set and to overwrite all existing backup sets.
13. In the Reliability section, select Verify backup with finished.
14. Click OK.
If transferring the database backup to the Momentus Enterprise FTP site, please zip the backup file before uploading.
If the zip file is larger than 1 GB, use the tools available in the compression program (WinZip, WinRAR, etc.) to split the file into smaller parts of 1 GB or less.
Comments
0 comments
Please sign in to leave a comment.