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 |
|
mahersoft
Starting Member
2 Posts |
 Posted - 2006-07-10 : 08:02:08
|
when i mack backup from my own database sql server get error meaning the msdb can't open but i afraid to restore msdb from another server.can anybody help me fastthanks   |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-10 : 08:15:22
|
| "sql server get error "What is the error message pls?" i afraid to restore msdb from another server"Bad idea to restore MSDB from a different server.Do you have a backup of MSDB from the current server?Kristen |
 |
|
|
mahersoft
Starting Member
2 Posts |
Posted - 2006-07-10 : 08:54:34
|
| sql server error message :"database 'msdb' cannot be opened . it has been marked suspect by recovery . see the SQL server errlog for more information."i don't have backup from msdb.thanxs |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-10 : 09:10:13
|
| Try closing down sql server and copying the user database files to another server and attaching them.If that works then you should be able to reinstall sql server and attach the databases.You will lose anything that was in the system databases so script the logins first.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Backup DB