Solved

System Databases Help!!!!

Posted on 2007-12-06
7
193 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

930 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

9 Experts available now in Live!

Get 1:1 Help Now