Re: MSDB (Subspect)
From: Philip (anonymous_at_discussions.microsoft.com)
Date: 04/20/04
- Next message: hansje: "Re: MAPI error 273"
- Previous message: Faheem: "RE: sql server performance"
- In reply to: Tibor Karaszi: "Re: MSDB (Subspect)"
- Next in thread: Tibor Karaszi: "Re: MSDB (Subspect)"
- Reply: Tibor Karaszi: "Re: MSDB (Subspect)"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Apr 2004 03:56:01 -0700
Hi,
I have already tried restore the msdb database from the backup but don't know why still subspected.....
Any Idea?
----- Tibor Karaszi wrote: -----
Just restore your latest backup of the msdb database. Msdb is just like any other database when it comes to
handling a suspect database. General recommendations for handling a suspect database:
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Philip" <zeta_01@hotmail.com> wrote in message news:A51A7CEF-958B-4911-B647-810C27A2DCE4@microsoft.com...
> Does anyone know how I can recover the MSDB once it is not subspect?
>> The reason is the server was down during the backup job running in night and I have already copy the
database file to the orginial location but only the MSDB was subspected....
>>
- Next message: hansje: "Re: MAPI error 273"
- Previous message: Faheem: "RE: sql server performance"
- In reply to: Tibor Karaszi: "Re: MSDB (Subspect)"
- Next in thread: Tibor Karaszi: "Re: MSDB (Subspect)"
- Reply: Tibor Karaszi: "Re: MSDB (Subspect)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
