Learn how to a build a cloud-first strategyRegister Now


recreate msdb

Posted on 2007-07-31
Medium Priority
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

Accepted Solution

UnTwstr earned 1500 total points
ID: 19605569
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

810 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