Monday, March 12, 2012

Msg 3710, Level 16, State 1, Line 1

Hello Folks,

I am moving the model & Msdb databases to a different location and I have this error.

Thanks

Msg 3710, Level 16, State 1, Line 1

Cannot detach an opened database when the server is in minimally configured mode.

I was able to fix it, I used an ALTER DATABASE statement.

Thanks for the time.

|||What command are you using...the Alter DB stmt only works with TEMPDB...I thought? I am getting "

Cannot detach an opened database when the server is in minimally configured mode." as well. I set the trace flag -T3608 and I get the message when I exec sp_detach_db 'msdb'

|||I was able to resolve this error by restarting SQL Server

No comments:

Post a Comment