October 6, 2009 at 6:20 pm
I am attempting to move the system databases from the c drive of server to another drive. The server is set to windows authentication mode.
after i have changed the startup parameter to point to D drive of server. I ran a cmd line to start the server in master recovery mode. when I try to connect to sql server to run a script to move the mssqlsystemresouce data file and log file i get an error message stating that the server is in single access mode.
The user i am trying to connect as is apart of the builtin adminsitrators group. Do i need to change the authentication mode to mix and enable sa so that i can connect and move these databases?
Your suggestions is greatly appreciated.
October 7, 2009 at 12:56 am
Can you list the exact steps you've done?
You cannot move the resource db, see BOL ---> Moving System Databases
October 7, 2009 at 1:54 am
- did you grant the needed auth for your service account on the windows folders at the new drive ?
- did you follow the procedure as explained in BOL ?
- What's the exact error message you get ?
- Do you find info in the ERRORLOG file for your instance ? (old location / new location)
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
October 7, 2009 at 7:08 am
were you using SSMS to try and connect?You will have to use SQLCMD.
If that message still occurs someone or something is beating you to the single connection. If you have reporting services stop that service.
BTW you can move the resource database in SQL2005, BUT, keep it together with the master database and keep the data and log files together (for both databases)
---------------------------------------------------------------------
October 8, 2009 at 1:59 pm
You can use SQL Server Comfiguration Manager and look at SQL Server Services. Stop all services before entering single user mode. Then as previously suggested use SQLCMD.
October 8, 2009 at 3:12 pm
Absolutely! I figured it out after i had posted my question.
thanks for all you help & suggestions. They are greatly appreciated.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply