How to perform backup using SQL Enterprise Manager.?
Posted Answers
SQL Enterprise manager enables you to quickly back up a database. This should be done to create a one-off backup to transfer data or to test backup device. Here’s the procedure:
1. Open the Databases folder, and then right click on the database you want to back up.
2. From the context menu, choose Tools and the Backup Database.
3. Fill in the description field, and then choose the backup type (complete, differential, Transaction log, or file group). Choose the destination, you can choose multiple destinations for your backups if you want to back up to multiple devices at the same time. Choose whether or not to overwrite the existing media or add a backup set to existing media.
4. On the options tab, you’ll find all the options that are available in the Transact-SQL version of the command, including options for ejecting the tape on completion and working with media sets.
5. Click on Ok to stat the backup. The backup begins. When the backup is complete, a message box appears, saying the backup operation has completed successfully.
The backup process will take some time, depending on the size of the database and the speed of the media being backed up to.
Answer by: Anonymous
