How to restore Database
-
Hi, I backup my SQL server database to deploy it to another computer. But i don't know that how to restore it on the other computer. What r the steps. Kindly help me in this regard. Bye EsHbAn BaHaDuR
* Copy the backup file on to the other computer * In Enterprise Manager, open the tree on to the SQL Server instance running on the other computer (you may have to register the other SQL Server with your local Enterprise Manager if it is not already there - alternatively go to the Enterprise Manager on the other computer) * Right click on the databases folder icon in Enterprise manager and select All Tasks-->Restore Database
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
-
Hi, I backup my SQL server database to deploy it to another computer. But i don't know that how to restore it on the other computer. What r the steps. Kindly help me in this regard. Bye EsHbAn BaHaDuR
You went to Action/All Tasks/Backup Database to back it up, just underneath Backup Database, it says Restore Database. :doh: Christian Graus - Microsoft MVP - C++