Re: msdb database marked as "suspect"

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/20/04 

Date: Wed, 20 Oct 2004 18:50:40 +0200

Search Google and KB for suitable phrases such as "rebuild" and "msdb", and you should find articles
covering this. In general, you run instmsdb.sql to get a new fresh msdb database. But SQL Server
might not be so keen to let you do this without setting some trace flag etc, hence my recommendation
to do a search first... 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Trifon Triantafillidis" <trifont@otenet.gr> wrote in message news:cl64mf$nuh$1@usenet.otenet.gr...
>I don't have a backup of msdb.
>
> I had only one maintenance plan that I can easily recreate it.
>
> Thank you.
>
> Ο "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> έγραψε
> στο μήνυμα news:OklHrDstEHA.1292@TK2MSFTNGP10.phx.gbl...
>> I'd restore the last clean backup of msdb, quite simply.
>>
>> -- 
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>>
>> "Trifon Triantafillidis" <trifont@otenet.gr> wrote in message
> news:cl61o2$be0$1@usenet.otenet.gr...
>> > In my SQL server installation the msdb database has been marked
> "suspect"
>> > and also the SQL agent cannot be started. Also I can not define any
> backups
>> > in database management plans (there was on but now it is not working).
>> >
>> > The rest database seems to work fine for more than 2 weeks now.
>> >
>> > Any ideas?
>> >
>> > Thanks
>> >
>> >
>>
>>
>
>

Relevant Pages

  • Re: What is stored in MSDB database for SQL Server 2005 Express ?
    ... Seems that the applicaton create jobs, wich are stored in msdb ... QuitWithRollback END COMMIT TRANSACTION GOTO EndSave QuitWithRollback: IF ROLLBACK TRANSACTION EndSave: ... Normally applications outside of SQL Server will never update anything in MSDB and there are much better places to store temporary files such as the file system or a user defined db or maybe even tempdb depending on what the requirements are? ... it seems that there is no reason the application has to make use of the MSDB database during database upgrade. ...
    (microsoft.public.sqlserver.server)
  • Database is not starting up
    ... I was trying to move the MSDB and Model datafiles from one ... To move the MSDB database on SQL Server 2000, ... Stop and then restart SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Stored Packages - MSDB Access
    ... I have written the SSIS Project and created the ... I have successfully deploy the package to MSDB, ... can not browse MSDB either locally on the server from SQL Server Management ... why is it saying that anything about remote ...
    (microsoft.public.sqlserver.dts)
  • Re: Stored Packages - MSDB Access
    ... I have successfully deploy the package to MSDB, ... can not browse MSDB either locally on the server from SQL Server Management ... why is it saying that anything about remote ... The MSDB node under Integration Services->Stored Packages refuses to open. ...
    (microsoft.public.sqlserver.dts)
  • RE: why inconsistency errors on msdb again?
    ... you saw errors on msdb. ... Yes, just the msdb database. ... or hardware problems are most unlikely? ... negative impact on the SQL server? ...
    (microsoft.public.sqlserver.server)