Database restore from mdf?

[Matt]

Hello,

The hard drive in my SQL server is dead. I don't have any backup files of the sgvault database, but I do have the MDF and LDF. Is there a way to cleanly restore the database from those files?

This is not a super-critical issue, as I do have backups of the actual source code. But it would sure be nice not to have to re-create my repositories and projects. I just did a fresh install of Vault on a new SQL Server. How dangerous would it be to just drop in the old MDF and LDF files for sgvault?

feeling lucky,
matt

[jclausius]

Do you not have a Database backup? If so, just restore that backup.

Otherwise, you could try :

1) sp_attach_db

OR

2) if you didn't use the .ldf, sp_attach_single_file_db

OR

3) http://groups.google.com/groups?hl=en&l ... kmsftngp05

Report back how things go.

[Matt]

Jeff,

Thanks for the quick reply. I'll let you know what happens when I try your suggestions. I'll be attempting the restore sometime this weekend.

Matt