August 26, 2009 at 7:52 am
Hello ,
I'm working on SQL 2005 STD Edition. Tried moving the MSDB database this
w/end to another drive but was unsuccessful
The problem I'm having is...after restarting the SQL Service in Single Mode with the following parameters:
NET START MSSQLSERVER /c /m /T3608
Before I can log into SQL Server Management Studio one of my applications is taking up that Single User, which means I can't get in.
I've even tried
NET START MSSQLSERVER /c /m"Microsoft SQL Server Management Studio - Query" /T3608
But still same issue.
My thoughts are that I can do the following to solve this:
1. Stop the IIS layers on all the application servers
If there is another way I will greatly appreciate any feedback
August 26, 2009 at 8:21 am
Try the DAC first.
http://msdn.microsoft.com/en-us/library/ms189595%28SQL.90%29.aspx
~sqlbot
Craig Outcalt
August 26, 2009 at 9:00 am
- disabling tcp\ip for that instance may get you to it !
- follow "Moving the MSDB database" in this KB-art : http://support.microsoft.com/kb/224071
- this may also help out: http://www.sqlservercentral.com/articles/Administration/2605/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 26, 2009 at 11:07 am
Something we have done in the past is to block apps at the firewall - if you have your database servers in a protected zone.
Another method is to disable the users that would be accessing the databases before restarting the service in single-user mode.
After you are finished with the move of the msdb, then re-enable the users.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply