How do I restore a db from the data directory?

[andersw]

I have a backup of the MSSQL/Data directory of a previous installation where I had a database I now wish to restore. I have no back ups of this database only the Data directory itself.

How do I now restore the database from this Data directory? Is there some utility I can use maybe? [sig][/sig]

 

[foxdev]

Use the sp_attach_db system stored procedure, or its sister sp_attach_single_file_db. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[andersw]

Thanks a bunch! I used it and then I used another sp to fix the probs with the homeless user rights of that database. So now the database can be used again.. Once again thanks! [sig][/sig]