How do I restore a SQL database?

You are here : ROCK Internet » » How do I restore a SQL database?
  • Mount a point in time backup image containing your ldf and mdf files.
  • Copy the ldf and mdf files to the server running SQL Server (default location is C:/Program files/Microsoft SQL Server/MSSQL/Data).
  • Restore the ldf and mdf files using SQL Enterprise Manager.

For more information, reference the links below:

http://msdn.microsoft.com/en-us/library/ms177429.aspx
http://www.databasedesign-resource.com/sql-server-restore-database.html
http://msdn.microsoft.com/en-us/library/aa237568(SQL.80).aspx

Both comments and pings are currently closed.

Comments are closed.


 

 
.