Re: Error 823 with msdb

From: Yih-Yoon Lee (yihyoon_at_gmail.com)
Date: 01/23/05 

Date: Sat, 22 Jan 2005 18:01:20 -0600

There is a way to rebuild msdb from scratch. May not be a supported one.
Try this on a test server before doing this on a production server

Start SQL Server from the command prompt recover just the master
database, such as sqlservr.exe -c -f -T3608 -T4022

you can then connect to sql server from query analzyer (-f means yo
uwill only get single connection), then you can delete MSDB database.

There is a script in mssql\install folder called instmsdb.sql. This is
the script to recreate MSDB database.

I have to warn you this is probably not a supported solution by
Microsoft. I am not responsible for any damage :) But if you are
thinking of rebuilding master database anyway, why not give this a try?

the idea is test it thoroughly and make sure it test in your development
server.

Yih-Yoon Lee
My blog http://www.mssql-tools.com/blog
E-mail: yihyoon.online@gmail.com
/* remove .online to send me e-mail */

Russell Stevens wrote:
> Yih-Yoon,
>
> <<In your case, you have to recreate the maintenance plan, which should not
> be a big issue. In fact if that is the only problem that you get after
> the repair, you should be happy.>>
>
> No - I am not happy <g> - I couldn't create a maintenance plan before the
> repair or after the repair. I can't add a plan or revise a plan. Until msdb
> is fixed, I am dead in the water (the existing plans still run fine). And I
> can't restore from an msdb backup as I evidently don't have one that was
> made before the problem started (I only keep a few weeks).
>
> Looks like I need to rebuild the master and start over. It just seems that
> MS should have a way of rebuilding just msdb without having to rebuild the
> master.
>
> Thanks
> Russ Stevens
>
>

Relevant Pages

  • Re: Move databases between servers
    ... Tell me why you need to move master, msdb, and model? ... When you restore databases on your other server SQL Server adds ... If you have lots of jobs defined you could try restoring MSDB. ...
    (microsoft.public.sqlserver.setup)
  • Re: Access denied after OS Disk upgrade!?
    ... Thanks Kevin for the insight. ... I took your suggestion and read the Rebuild ... master utility information and ran the rebuild program. ... > Not sure if this is what you need, but since SQL Server isn't working at ...
    (microsoft.public.sqlserver.connect)
  • Re: rebuild master again...
    ... You have to restore the MSDB to retrive back all the ... "Important The Rebuild Master utility rebuilds master completely. ...
    (microsoft.public.sqlserver.server)
  • Re: MSDB and MASTER DB
    ... For these volumes I would use transactional replication if possible. ... In master your linked servers and logins live. ... Your msdb databsae ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • What hot fix is needed to get version 859 for SQL 2000
    ... I applied a hot fix on my server and I need to restore ... master and msdb on a new set of disks to replace the old ...
    (microsoft.public.sqlserver.server)