fbpx

How to create backup for the database

 

To create backup for the database, right click on the database in Object Explorer and choose backup from the Task Menu that opens backup dialog box. Within this dialog box specify the path where we want to create backup along with file name with extension .bak using destination option and click on OK button.

Restoring Database from Backup: To restore the database from backup file within Object Explorer right click on databases note and choose Restore Database option. This will open a dialog box. Within this dialog box specify the database, choose the option from device, select the backup file from which we want to restore the database, check the Restore Checkbox for selected backup and click on OK button.

Related Posts

Leave a comment

Contact Us Now
close slider