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 |
|
BreakingEagle8
Starting Member
2 Posts |
 Posted - 2011-08-10 : 12:11:14
|
| The SQL server was brought down a couple of times by a faulty UPS. Since that time backups of my msdb have failed. Also I had a problem with my backup system that caused me to lose all the backups of msdb. I need to restore my msdb database, my questio has to do with restoring from a backup on a different server. The two servers are at the same version level and have the same user databases. The server I am having a problem with is the live server the one with a good backup is the training server.I am rather new to managing databases, but it has now been added to my job. I read an article on repairing the msdb by detaching the database, moving the files then running the instmsdb.sql script. But I was just curious if restoring from another server would work?I am running SQL Server 2005 Service pack two on both servers. I appreciate any help you could offer. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-10 : 14:18:43
|
| Restoring a backup from another server would work, but does that server have the same jobs, ssis packages, schedules etc? |
 |
|
|
BreakingEagle8
Starting Member
2 Posts |
Posted - 2011-08-11 : 10:54:47
|
| The only difference is the location of the transaction logs in one of the databases. But I thought I would recreate all the maintenance plans after I restore. The msdb won't backup and when you change anything the process to make the insert hangs I am thinking the database is corrupt. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-11 : 11:39:12
|
| what's the output of DBCC CHECKDB(msdb) WITH ALL_ERRORMSGS, NO_INFOMSGS;What's the error message when you try to restore?Use the WITH MOVE option when restoring |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2011-09-09 : 15:14:38
|
| you can always restore the msdb as a user database and script out the jobs you require from thereanother idea is perhaps copy over the mdf and ldf files and overwrite the new ones on a test server and see if you get the jobs recreated--------------------keeping it simple... |
|
|
|
|
|
|
Restore MSDB from another server backup