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 : 01:30:09
|
| I am facing the Database recovery problems sicne I have lost my MSDB db , only i have the Complete db backup and transactional backup.How do i can recover the database since i don't have the MSDB database |
|
|
SatyaSKJ
Starting Member
46 Posts |
Posted - 2007-04-18 : 05:00:14
|
| You need MSDB database in case you have to restore or get back the scheduled jobs & DTS packages. IN this case it looks like your user database is also offline, please be specific about your requirement and if you are getting any error while restoring the database backups then let us know.Satya SKJSQL Server MVPhttp://www.sqlserver-qa.net |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-18 : 15:55:30
|
| You can restore db from backup files with restore statement. |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Recover the Backup set with MSDB