How to Create Backup and Restore in SQL Server 2008

If you want to know how to backup and restore procedure is carried out in SQL Management studio for MDF file database then user need to follow given below following steps.

Backup Procedure in SQL Management Studio

  • At very first open SQL Server Management Studio

Go to Start button --> All Programs –> MS SQL Server 2008-> SQL Server Management Studio

ssms start
  • In next window user will see a pop-window as given below where you need to fill some credentials to connect to the SQL Server.

ssms login window
  • After clicking on Connect button you will see the list of the databases click on the required one to take backup as given below picture showing master123 database. Then explore it by clicking on plus button.
select master database
  • In next step select Tasks and then Back up option as depicted below.
select backup
  • Next window select Backup type – Full and then Destination path for the file to be saved. Then click Ok button.
full sql backup and location
  • At the same time in above STEP select Backup type – Transaction Log and Destination path for the file to be saved.Then Click Ok. "Transaction log backup is strictly required so that database will be restored".
transaction log backup
  • After that Backup Execution process status will be shown on the left bottom corner.
execution process
  • At last Window will show successful completion message as below. Then click Ok.
backup completion message
  • Follow the Address bar path like C:\MSSQL10_50.MSSQLSERVER\MSSQL\Backup to view backup file.
backup file path

Restore Procedure in SQL Server

  • Follow Starting 3 steps of the Backup procedure as above explained.
  • To restore selected database right click on the database then Tasks – Restore and then Database.
restore database
  • Next Window will show full backup database and transaction log backup file, select both file and click on Ok button.
bak and log file
  • By clicking on On button in left botton corner Execution Process will be shown.
restore execution process
  • After execution process completion a successful restore database message will be come up on the screen. Then click Ok.
restore successful

By following above manual steps user will be able to take backup and backup database restore procedure. But while following steps there might be possibilities that user can get error messages or database damage and if these steps dont results in the required goal or somehow fails to restore database then there is another method i.e. SQL backup recovery tool. It will restore damaged backup database very safely without having any interruptions. Download demo version of the tool free of cost which will show restored database items preview.