Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Start instance without MSDB and MODEL?

Author  Topic 

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2009-10-06 : 09:15:37
MS SQL Server 2005
I attempted to move the model and msdb databases and now the engine won't start.

Is there a way to start with just the Master DB so I can troubleshoot?


jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2009-10-07 : 08:10:35
as far as i know, no.
1. can you move them back to the original location?
2. can you attach them to another sql instance or server? then pick up your pieces from there?



--------------------
keeping it simple...
Go to Top of Page

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2009-10-07 : 10:26:22
Thanks. I moved them back to their original locations and then started again from the top..
Go to Top of Page
   

- Advertisement -