Solved

System Databases Help!!!!

Posted on 2007-12-06
7
184 Views
Last Modified: 2010-03-19
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
Comment
Question by:novicedbaUK
  • 4
  • 3
7 Comments
 
LVL 18

Expert Comment

by:Yveau
Comment Utility
can't you use the Dedicated Admin Connection ? (DAC)

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

Hope this helps ...
0
 

Author Comment

by:novicedbaUK
Comment Utility
Not keen on using a utility I havent used before as this is a live system
0
 
LVL 18

Expert Comment

by:Yveau
Comment Utility
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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:novicedbaUK
Comment Utility
Didnt work as DAC not enabled. Oh dear me! Its motning and the users are whinging
0
 

Author Comment

by:novicedbaUK
Comment Utility
Have had to move master back to the C drive. Instance is now up and running. Thanks for your help
0
 
LVL 18

Accepted Solution

by:
Yveau earned 500 total points
Comment Utility
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
 

Author Comment

by:novicedbaUK
Comment Utility
moved master back to the Cdrive
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now