Re: MSDB (Subspect)

From: Philip (anonymous_at_discussions.microsoft.com)
Date: 04/20/04 

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....
>>

Relevant Pages

  • Re: Newbie ? -- Does master transaction log need to be backed up?
    ... Be aware that the backup history is in the msdb database. ... I also do log backup for msdb. ...
    (microsoft.public.sqlserver.server)
  • Re: Torn page problem
    ... backup of MSdb because the job definitions are there. ... place that in order to restore MSdb I need to ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: msdb database marked as "suspect"
    ... I don't have a backup of msdb. ... > I'd restore the last clean backup of msdb, ... > Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Deleted versions of DTS package
    ... If you happen to have a backup of ... your msdb database, may be you could restore that to a different box, and ... copy out the version that you need, as a .dts file. ...
    (microsoft.public.sqlserver.dts)
  • Re: Backup aborts halfway through with no error
    ... Your application needs to query the msdb database for to see if the backup ... > gets terminated for some reason, that the .BAK file gets deleted? ... > users will know the backup has failed without having to do a test restore. ...
    (microsoft.public.sqlserver.msde)