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 |
|
makimark
Starting Member
34 Posts |
 Posted - 2003-06-20 : 03:05:37
|
| HiIs ist possible to restore a sql2000 db without having the log file ? I only have the mdf. thanksMark |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-06-20 : 03:22:51
|
| Geez, man, it's not even possible to RESTORE with a .mdf ....Maybe you mean attach? ... look up sp_attach_single_file_dbJay White{0} |
 |
|
|
makimark
Starting Member
34 Posts |
Posted - 2003-06-20 : 03:27:17
|
ok, ok a little miss-phrased my question was; but thanks nonetheless.quote:
Geez, man, it's not even possible to RESTORE with a .mdf ....Maybe you mean attach? ... look up sp_attach_single_file_dbJay White{0}
|
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-06-20 : 03:30:54
|
Well, DON'T LET IT HAPPEN AGAIN ...  (joke)Jay White{0} |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-20 : 12:17:14
|
| Hopefully the MDF file that you have is good. What makes the MDF file useable is when the MSSQLSERVER service was stopped and the MDF was copied somewhere else, or the MDF was detached from SQL Server. I have not had any occassion where I tried to attach an MDF without having the prior two things be true, but I believe that other people have been able to do it successfully. Hopefully it'll work for you. Let us know how it goes.Tara |
|
|
|
|
|
|
Restoring without log file