SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 problems moving model and msdb
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

musicsteve28
Starting Member

2 Posts

Posted - 05/23/2012 :  09:57:24  Show Profile  Reply with Quote
Hello,
I tried to move my model and msdb databases to a different location following the steps outlined here -http://support.microsoft.com/default.aspx?scid=kb en-us 224071. I was able to detach them but can't seem to reattach them.

When I try to reattach, the error log says, "Could not find database ID 3 (which is the Model database). Database may not be activated yet or may be in transition. Reissue the query once the database is available." Sort of a catch 22.

Any ideas?

musicsteve28
Starting Member

2 Posts

Posted - 05/23/2012 :  15:38:57  Show Profile  Reply with Quote
The problem is that the instructions were for 2005 wheras I'm on 2008. Since it was a test instance, I just decided to rebuild the database and use the correct 2008 instructions for moving system databases.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000