Recovering a Database 1

[Beerice]

Ok.. Here is the situation. Sever died a horrible death. OS Crapped out big time. Even after wiping the OS partition and trying to reinstall, no go. The databases are on a seperate partition of the raid array. I can boot with my ERD Commander Software and get dos type access to the drives and can see the mdf and ldf for the database. Can I copy these out somehow and use them to recover the DB after I rebuild the server. I am somewhat of an SQL Newbie...

If this won't work.. Any other suggestions?

Thanks

 

[tlbroadbent]

You can copy the files and attach them. See "Attaching and Detaching a Database" in SQL BOL.

http://msdn.microsoft.com/library/en-us/createdb/cm_8_des_03_89pv.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Beerice]

Forgot to mention this is on Sql 7.0, does that make any difference?

 

[tlbroadbent]

No. The process works in SQL 7 and higher. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.