Create Backup and Restore the Database in Microsoft SQL Server
This article was originally published on mesameergaikwad as Create Backup and Restore the Database in Microsoft SQL Server
Create Backup and Restore the Database in Microsoft SQL Server
This article was originally published on mesameergaikwad as Create Backup and Restore the Database in Microsoft SQL Server
When using a database you often need to create a backup file of the database to store the information periodically, which is useful when you have lost your database from SQL Server for whatever reason. In this situation, you can restore your database from the backup file and get the deleted information back.
Use the following procedure to create and restore a database backup file.
Creating the Backup
Step 1
Open SQL Server 2012 and create a database then right-click on the “Name of database” >> “Task” >> “Backup”.
Step 2
Now the Backup database window will be shown; click on the “Add” button to add the designation to save the backup file on the hard disk.