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 |
|
giano01
Starting Member
1 Post |
 Posted - 2003-05-09 : 07:48:57
|
| Hi,I have a msde backup file. I want restore a database with this backup file, but i get the following error :"Error 3256The backup set on device '%ls' was terminated while it was being created and is incomplete. RESTORE sequence is terminated abnormally"I suspect that the .ldf file is damaged.How i can manage this situation ?Can I restore a database without a transaction log.Others backups are not avalaible.Could you help me?ThanksGiano |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-05-09 : 09:38:15
|
| Sadly, it sounds like you have a corrupt backup. I doubt you'll be able to use it.Restore verifyonlyrestore filelistonlyeither of that run for you ?If you had mdf and ldf, you could try attaching just mdf, and try and get SQL to create ldf, although since these are system DB's, that would be difficult (-T3608 needed ? BE CAREFUL!)I hate to say it, but it sounds like you're not getting msdb back.Can what you need be rebuilt somehow - from the source code that you kept, or have on your dev box ? (hoping you have either of these!). GOOD LUCK !! and be careful when playing with system databases !!!*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-09 : 15:18:53
|
quote:
Sadly, it sounds like you have a corrupt backup. I doubt you'll be able to use it.Restore verifyonlyrestore filelistonlyeither of that run for you ?If you had mdf and ldf, you could try attaching just mdf, and try and get SQL to create ldf, although since these are system DB's, that would be difficult (-T3608 needed ? BE CAREFUL!)I hate to say it, but it sounds like you're not getting msdb back.Can what you need be rebuilt somehow - from the source code that you kept, or have on your dev box ? (hoping you have either of these!). GOOD LUCK !! and be careful when playing with system databases !!!*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here!
giano01 is talking about an MSDE database, not the MSDB system database. But the answer is still the same.Tara |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-05-12 : 06:49:15
|
| msdE ... Doh !!! need eye's checked !!!*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
|
|
|
|
restore a msde database