Solved

System Databases Help!!!!

Posted on 2007-12-06
7
212 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
ID: 20423016
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
ID: 20423099
Not keen on using a utility I havent used before as this is a live system
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20423555
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

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

Author Comment

by:novicedbaUK
ID: 20426097
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
ID: 20430356
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
ID: 20598268
moved master back to the Cdrive
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

789 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