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 |
|
bpgupta
Yak Posting Veteran
75 Posts |
 Posted - 2007-04-13 : 05:38:58
|
| I have lost my MSDB db , only i have the Complete db backup and transactional backup.How do i can recover the database ,Is any way to recover it.BP |
|
|
Kristen
Test
22859 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-13 : 11:04:28
|
| Please do not post duplicate threads on this forum:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82065 |
 |
|
|
bpgupta
Yak Posting Veteran
75 Posts |
Posted - 2007-04-16 : 02:11:18
|
| The Restore Statemeent is not working for Transaction Backup with Norecovery option , since i don;t have the sequence of transaction backup.I have lost MSDB .I have done the Compleat Backup Restore, now I having the Transactional Backup file ,This Tran.File is basically comprises of more than Ten Transaction Backup Taken in NOINIT mode.Then how do i will get the Sequence of Transaction Backup. I don;t have multiple transaction backup files for multiple transaction backup done.Since all the Tran.backup sequence maintain by MSDB and i have lost my MSDB.Please help me. |
|
|
|
|
|
|
Recover the user DB without MSDB