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 |
|
Shogun
Starting Member
9 Posts |
 Posted - 2008-10-06 : 02:29:16
|
Hi guys,I've got a SQL 2k database which I forgot to back up before I reinstalled my O/S.  I still have the *.mdf and the log files and desperately need the data. When I reinstalled the O/S (XP Pro) I installed SQL Server 2005. My question is how can I get the data from the *.mdf file into a new SQL 2005 db?I tried creating a new db and then importing, and also tried to restore it, but I can't get it to work. Does anybody have any idea how I might be able to recover the data without reinstalling SQL Server 2k and setting it up the same way as I previously had it?Thanks a bunch,Jason |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 02:32:45
|
| http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3894067&SiteID=17 |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-06 : 09:59:24
|
| Was database detached properly before Reinstalling OS? You need to attach not restore:Look for sp_attach_db in books online. |
|
|
|
Shogun
Starting Member
9 Posts |
Posted - 2008-10-07 : 18:43:26
|
| Great thanks guys.I'll check it out.- Jason |
|
|
|
|
|
|
How to restore from .mdf