I am trying to move the msdb database, I am following the MS technet
document. I have added trace flag "-T3608" to startup parameters,
restarted the SQL server, stopped the agent, detatached the msdb
successfully. I moved the mdf and ldf to the new location and I removed
trace flag and when restarted the SQL server is not starting up, I
checked Event log it is giving this error
17052 :Could not find database ID 3. Database may not be activated yet
or may be in transition.
Please help me
Thanks in advanceI believe that database ID 3 is the "model" database....Did you also
try and move the model database?|||(nate.vu@.gmail.com) writes:
> I believe that database ID 3 is the "model" database....Did you also
> try and move the model database?
Correct. msdb is dbid = 4.
Looks like Raj should restore the trace flag, and then check what he
actually moved.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Ah OK, it does sound like the model database has been moved then. From
memory, it has to be re-attached before msdb. Also, model must be
re-attached with the trace flag on but msdb should be re-attached with
the trace flag off...
