I am going to let you know about the steps which are required to Restore a SQL Database file to SQL Server 2005. First you need to install SQL Server 2005 Management Studio Express which I am currently using in the screen shots.
If you need to download SQL Server 2005 Express edition which is free the use the below link:
http://www.microsoft.com/en-us/download/details.aspx?id=21844
If you want to purchase SQL Server 2005 Developer Edition then use below link:
Its very easy for the experienced developers and students but very much helpful for the beginners. Just follow the steps along with screen shots and it will take short time to restore a database from database backup file.
Step 1 (Microsoft SQL Server Management Studio):
Open the Microsoft SQL Server Management Studio Express from Programs Menu. In the below screen shot the welcome screen is shown after you login to SQL Server Management Studio. I have highlighted the database currently contained in SQL Server.
Step 2 (Microsoft SQL Server Restore Database Option):
Right click on Databases Folder as shown in blue in below screen. Here you will see Restore Database option which you need to click to move to next step.
Step 3 (Microsoft SQL Server Restore Database Form):
In the below screen shot you can see the highlighted portions. To database field will contain the name of database you want to give to the restored database.
From Device option is to browse the SQLBackup file which needs to be restored.
Step 4 (Specify SQL Backup File):
In this step you need to click the highlighted button in Restored Database form and a Specify Backup window gets open.
When you click on Add highlighted button, a file browser window gets open thorugh which you select the SQL Backup file which you want to restore. After selection of SQL Backup file the path gets shown in Backup Location option. After SQL Backup file selection click OK.
Step 5 (Specify Name for Restored SQL Database):
Now your select the desired database set to Restore and check it. There could be multiple sets to Restore and you have to check which one to restore. Next add the Database Name in To database field. Finally click OK.
Step 6 (SQL Backup Restored):
In the below screen you would be able to see MyDatabase gets restored successfully.
Hope you will find it helpful. Let me know if you have any confusion and I will update it.
If you need to download SQL Server 2005 Express edition which is free the use the below link:
http://www.microsoft.com/en-us/download/details.aspx?id=21844
If you want to purchase SQL Server 2005 Developer Edition then use below link:
Its very easy for the experienced developers and students but very much helpful for the beginners. Just follow the steps along with screen shots and it will take short time to restore a database from database backup file.
Step 1 (Microsoft SQL Server Management Studio):
Open the Microsoft SQL Server Management Studio Express from Programs Menu. In the below screen shot the welcome screen is shown after you login to SQL Server Management Studio. I have highlighted the database currently contained in SQL Server.
Step 2 (Microsoft SQL Server Restore Database Option):
Right click on Databases Folder as shown in blue in below screen. Here you will see Restore Database option which you need to click to move to next step.
Step 3 (Microsoft SQL Server Restore Database Form):
In the below screen shot you can see the highlighted portions. To database field will contain the name of database you want to give to the restored database.
From Device option is to browse the SQLBackup file which needs to be restored.
Step 4 (Specify SQL Backup File):
In this step you need to click the highlighted button in Restored Database form and a Specify Backup window gets open.
When you click on Add highlighted button, a file browser window gets open thorugh which you select the SQL Backup file which you want to restore. After selection of SQL Backup file the path gets shown in Backup Location option. After SQL Backup file selection click OK.
Step 5 (Specify Name for Restored SQL Database):
Now your select the desired database set to Restore and check it. There could be multiple sets to Restore and you have to check which one to restore. Next add the Database Name in To database field. Finally click OK.
Step 6 (SQL Backup Restored):
In the below screen you would be able to see MyDatabase gets restored successfully.
Hope you will find it helpful. Let me know if you have any confusion and I will update it.
I read about all the steps described above and helped me to restore my sql backup database. Thanks for posting such useful information.
ReplyDeleteI also has gone through this blog http://restoremultiplebakfilessql.puzl.com/ which also helped me to restore full database backup in a smooth way.