Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
devdave
Starting Member
3 Posts |
 Posted - 2006-02-08 : 12:13:07
|
| We had a hard drive fail that contains an important SQL Server 2000 database. The hard drive was sent in for a rebuild, and we can now recover the data from it, but cannot actually boot from it (so we can't open SQL Server and export).Can anyone point me towards the proper way of transferring the database to a new (redundant) drive?Thanks,David |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-08 : 12:20:46
|
| Can you put this into another machine and connect to it from another version of SQL Server?Do you not have backups elsewhere? |
 |
|
|
devdave
Starting Member
3 Posts |
Posted - 2006-02-08 : 14:17:31
|
| Are you saying, have a machine with SQL Server running point to the database on that hard drive? What are the basic steps?Thanks!DavidPS Any backups are on the same drive (IT wouldn't let our dept backup to shared drives). |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-08 : 14:26:11
|
| If you can recvoer from it, then aren't your backup files accessible? If so, restore them! OrCopy the MDF file to another server that has SQL Server installed. Attempt to attach it via sp_attach_single_file_db. You could also use sp_attach_db if you care what is in the LDF, but you'd need to copy that file as well.Tara Kizeraka tduggan |
|
|
|
devdave
Starting Member
3 Posts |
Posted - 2006-02-08 : 14:56:24
|
| Thanks, I will give that a try.David |
|
|
|
|
|
|
Hard Drive Failed