July 6, 2007 at 7:21 am
Bye,
I had a anomaly during the commit of a vud file on vhd file. In practice my sql server 2000 virtual machine hasn't the last modifies.
Using a recovery files software I found the last backup of manteinance plan of the day before crash, and I would restore these ones.
I copied all .bak files in the same path where manteinance plan saved the scheduled backup, but during restoring I have this error:
Error 3242 ....Microsoft Tape Format not valid ( SQL-DMODBC 4200)
I tried all known commands:
restore database ....
restore filelistonly.....
restore headeronly....
restore verifyonly.....
etc...etc...
How can i recover my backups?
Thanks
July 9, 2007 at 12:14 am
Try these links anyone might help you.
http://support.microsoft.com/kb/905616
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=575666&SiteID=1
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 9, 2007 at 1:29 am
Thanks for your replay, but two links doesn't help me. My scheduled backup are made on device, and not on tape.
I recovered all backup of the day before crash.... I'm talking about of a sql server virtual machine are not made the commit during shutdown....This is my really problem.....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply