System Databases Help!!!!

someone please help. I need an answer ASAP

I have moved my system databases elsewhere from the C drive. Temp, msdb and model worked ok. Have changed startup parameters for master and restarted the instance in single user mode. This is now running. However, I am unable to log back in so as to move the resource databases as says another user is logged in. I was assured that all the services were stopped so dont know what is going on here. Could someone please tell me how to reverse, so as to move master back to the C drive. This could be a simple case of changing the startup parameters again but dont want to mess it up. Please help as need system up and running in an hour

Thanks
novicedbaUKAsked:
Who is Participating?
 
YveauCommented:
If you are going to give it another shot:
1. test it on a non production environment :-)
2. read these:
    http://support.microsoft.com/kb/224071
    http://msdn2.microsoft.com/en-us/library/ms345408.aspx

Hope this helps ...
0
 
YveauCommented:
can't you use the Dedicated Admin Connection ? (DAC)

http://technet.microsoft.com/en-us/library/ms189595.aspx

Hope this helps ...
0
 
novicedbaUKAuthor Commented:
Not keen on using a utility I havent used before as this is a live system
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
YveauCommented:
not a utility, just a normal SQL connection, reserved for the sysadmin in situations just like this !
connect as usual, only with the 'admin:' word in the connection:

normal: sqlcmd -S Yveau -E
now: sqlcmd -S admin:Yveau -E

voila ! your in ...
also works with the SSMS

Hope this helps ...
0
 
novicedbaUKAuthor Commented:
Didnt work as DAC not enabled. Oh dear me! Its motning and the users are whinging
0
 
novicedbaUKAuthor Commented:
Have had to move master back to the C drive. Instance is now up and running. Thanks for your help
0
 
novicedbaUKAuthor Commented:
moved master back to the Cdrive
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.