The Windows os on my server crushed. I do have disk file access. I can get the mdf and ldf files of my sql 2008 database is it possible to restore the database from those files, and how to do it ? Thanks, Dani
2 Answers
Yes, as long as the files didn't get corrupted you can do a reattach. In SQL Server Management Studio, right-click on Databases on your new server instances and choose Attach Database. It will ask you the location of your mdf file, and you might also have to browse to your ldf file. Should be no problem. Might take a minute depending on how much in your transaction log has not been committed.
Attach Database
If you have the files you can copy them over to the new database server and "Attach Database" via the MS-SQL GUI.
You'll be prompted for the locations of the files and then the system will grind away for a bit and (hopefully if there's no corruption) attach the database.
Good luck!