Can I restore msdb from another sqlserver 's backup

My msdb,system database, of sqlserver is marked suspected,
I cant recovery it for any method.
Therefore, Can I restore it from another sqlserver's
msdb backup?Hi,
It is not required to restore the MSDB from another server. Best option
will be drop the MSDB database and run the INSTMSDB.SQL script
from sql server installation directory\install folder.
Follow the below steps:-
1. Login to sql server using query analyzer
2. Drop the MSD database
DROP database MSDB
3. Open the INSTMSDB.SQL file in query analyzer
4. Just execute the script. This create the MSDB database, ALL objects ,
.....
5. After the succesful execution you will get a fresh MSDB.
Thanks
Hari
MCDBA
"StarNet" <anonymous@.discussions.microsoft.com> wrote in message
news:9e5b01c4792d$3cf98050$a601280a@.phx.gbl...
> My msdb,system database, of sqlserver is marked suspected,
> I cant recovery it for any method.
> Therefore, Can I restore it from another sqlserver's
> msdb backup?|||Hi,
We have the same problem with a suspected MSDB.
We tried to drop the msdb but got the message that the database cannot be
droped because it'a a system database.
How can we drop the database anyway and solve our problem?
Best Regards,
Karin W
"Hari Prasad" wrote:

> Hi,
> It is not required to restore the MSDB from another server. Best option
> will be drop the MSDB database and run the INSTMSDB.SQL script
> from sql server installation directory\install folder.
> Follow the below steps:-
> 1. Login to sql server using query analyzer
> 2. Drop the MSD database
> DROP database MSDB
> 3. Open the INSTMSDB.SQL file in query analyzer
> 4. Just execute the script. This create the MSDB database, ALL objects ,
> ......
> 5. After the succesful execution you will get a fresh MSDB.
> Thanks
> Hari
> MCDBA
>
> "StarNet" <anonymous@.discussions.microsoft.com> wrote in message
> news:9e5b01c4792d$3cf98050$a601280a@.phx.gbl...
>
>|||You should find info on this in KB 224071.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Karin W" <Karin W@.discussions.microsoft.com> wrote in message
news:417700A9-7115-481C-8884-BA26136A8E93@.microsoft.com...[vbcol=seagreen]
> Hi,
> We have the same problem with a suspected MSDB.
> We tried to drop the msdb but got the message that the database cannot be
> droped because it'a a system database.
> How can we drop the database anyway and solve our problem?
> Best Regards,
> Karin W
> "Hari Prasad" wrote:
>