N/APosted on - 05/17/2011
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?
How can i restore a database in SQL Server 2005?
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.