• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

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
0
novicedbaUK
Asked:
novicedbaUK
  • 4
  • 3
1 Solution
 
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
 
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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
 
novicedbaUKAuthor Commented:
moved master back to the Cdrive
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now