recreate msdb

Posted on 2007-07-31
Last Modified: 2008-01-09
On SQL Server 2000, We received a page fault on the msdb database and all of our dts packages dissappeared.  We are not able to restore directly to msdb but can restore to a new database (msdb2).  Can I create a clean msdb and just move the data from msdb2 into msdb?
Question by:lovingatx
    1 Comment
    LVL 2

    Accepted Solution

    What I have done in the past, with other databases, is to restore to a different db name (msdb2) and to take the original database offline. Then rename the original files (msdb.mdf & msdb.ldf) to something else, and rename the restored files (msdb2.mdf & msdb2.ldf) to the original file name (msdb.mdf & msdb.ldf). Then bring it back online and its happy.

    Since you do not have the choice to take msdb offline, this could be tricky. You may be able to manipulate the files if the service is stopped, i am not sure.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    MySQL 11 53
    How to script out data export 36 56
    vb6 connector to SQL Server 2 23
    SQL - combining multiple records into 1 record 5 22
    This article describes some very basic things about SQL Server filegroups.
    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now