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

Get Free Consultation Today!

    Choose your Plan

    Get An Instant Quote

      What Service You Want ?


      We’d love to hear from you
      Best Consultant