Restore backup in SQL Server 2008

Steps to restore the database backup

Open SQL Server Management Studio. It will ask for server credentials. Enter the server name, username, password and click on connect button.

Right click on the databases and select Restore database option.

Click on “From device” radio button and select the BAK file.

Enter the database name in the text box “To database”. Select the checkbox “Restore” as shown below.

Go to “Options” tab, Click on “Restore As” and change the files name with the database name as shown. Leave the extension (.mdf and .ldf) as it is.

Click on Ok button, message will be displayed – Restore of database completed successfully as shown below.

Database backup in SQL Server 2008

Steps to take the database backup

Open SQL Server Management Studio. It will ask for server credentials. Enter the server name, username, password and click on connect button.

After the successful connection you can find all the databases in the server.

Select the required database and right click on that, select Tasks --> Backup option.

Click on remove button and then click on Add button to enter the filename for the backup and the path where it has to be saved. Select the path where it has to be saved and mention the filename with “.bak” extension. Click on Ok button.

Click on Ok button twice and the backup of the selected database starts. Once the backup is finished the message will be displayed – The backup of database ‘IOCDocs’ completed successfully.