How can i restore a database in SQL Server 2005?

Asked By 1070 points N/A Posted on -
qa-featured

Hello,

I am using Microsoft SQL Server 2005 edition. I want to restore a database. I have the backup file for my desired database. As i am new to SQL Server, I can not restore this back up file as a working database. I need help to restore this.
 
One thing should be mentioned is that the restored database must do as it did before. Can anyone tell me how can I restore the backup file as a database in Microsoft SQL Server 2005?
SHARE
Best Answer by jakie
Best Answer
Best Answer
Answered By 450 points N/A #99600

How can i restore a database in SQL Server 2005?

qa-featured

 

Restoring a database from its back up file is too easy.
 
First go to MS SQL server and create a database named as you desired. Then go to tasks of that database and select restore database by clicking right button of your mouse.
 
Now select from device in new form of MS SQL and specify the backup file by adding the file path. After adding the file path now click ok to create restore point. Then select the checkbox in front of your file location to select the restore point.
 
Now go to the options and select the first checkbox named as overwrite the existing database now select ok to accomplish the restoring process. It takes few seconds to restore the database.
 
After a few seconds, you are given a new message that "restored successfully". Now you have the previous database as you wanted. Check it that you have all previous tables, views etc in your restored database.
Answered By 0 points N/A #99601

How can i restore a database in SQL Server 2005?

qa-featured

 

RESTORE DATABASE:
 
  1. Copy the backup file from source server to destination server. I’ve copied it into the same directory as source server.
  2. Connect to destination server. Open Microsoft SQL Server Management Studio Express and connect to BK01BIZ001.
  3. Right-click on Databases. Select Restore Database.
  4. Restore Database window appears. On Source for restore, select From device and click […] button to browse file.
  5. On Specify Backup, ensure that Backup media is “File” and click Add.
  6. On Locate Backup File, select the backup file. This is the backup file that was created in "Backup a database" section and was copied to this server. Click OK.
  7. Back to Restore Database window.
  8. On Destination for restore, select “AdventureWorks”.
  9. Note: If you haven’t added the backup file on Source before (step 4-6), you won’t see the database name on Destination.
  10. On Source for restore, check the box in front of the backup name (in Restore column).
  11. Click OK.
  12. Wait until restore finishes and there’ll be a pop-up message to notify you.
  13. Now you’ll see the restored database on the destination SQL Server.

Login/Register to Answer

Related Questions