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 2000 Forums
 SQL Server Administration (2000)
 Starting sql server in single user mode

Author  Topic 

rushdib
Yak Posting Veteran

93 Posts

Posted - 2007-05-18 : 10:05:26
Hi,
I am in the process of moving system databases to a different folder. I started the server in single user mode using sqlservr.exe -c -m. I tried detaching 'model', but it's still not allowing me. What am I doing wrong here?
Please help

Thanks

rushdib
Yak Posting Veteran

93 Posts

Posted - 2007-05-18 : 10:35:38
I tried using the instructions, but I still can't detach

http://support.microsoft.com/kb/224071

Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-05-18 : 10:45:05
detach model?? why?
back it up and restore it.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

mr_mist
Grunnio

1870 Posts

Posted - 2007-05-18 : 10:47:52
You need to add the trace flag before you can move model. Re-read the article.

-------
Moo. :)
Go to Top of Page
   

- Advertisement -