Running sp_attach_single_file_db gives this error:
The log scan number (10913:125:2) passed to log scan in database 'myDB' is not valid
Isn't it supposed to re-create the log file?
How else would I be able to attach/repair that .mdf file?
views:
637answers:
4
+1
A:
It depends what mode your database was in when it was detached, it's possible there are uncommitted/unwritten transactions in that log file that are needed to attach the database, otherwise there would be data loss. Do you know what recovery mode you were in when it was detached?
Nick Craver
2008-09-18 17:49:33
A:
there is no log file ;-) and it's just dummy data, just need it to work again so i can continue to dev... basically it used to work like 2 months ago, then i had to re-install sql2005 (express) and now i cannot re-attach it... not sure if that helps?
handsomeGun
2008-09-18 17:52:25
+1
A:
fyi: it worked! when i installed another one (with .ldf log file) then the one in question, then detached the first one again. don't ask me why....
handsomeGun
2008-09-18 18:59:39
+1
A: