November 6, 2011 at 6:01 am
hello :
We have a CRM 4.0 and sql server 2005. as I deleted some contetnt on cm accidentally I had to restore my sql databases. as told in the user guides I was starting with the master database, but when I was restoring it said I should use a single mode start up. I followed the instructions and changed the startup parameters in properties of sql sercer in configuration manager from -d to -m but i got this error after starting the sql server :
"The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details."
and when I changed it back I still get this message. any help will be appriciated.
naz
November 6, 2011 at 7:04 am
Did you check the event viewer for more details?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 6, 2011 at 8:51 am
changed the startup parameters in properties of sql sercer in configuration manager from -d to -m but i got this error after starting the sql server :
There's your problem. You don't change the startup parameters to get SQL to start in single user mode. By not having the -d parameter SQL now has no idea whatsoever where the master data file is (that's what -d is for)
You add extra startup parameters, like -m or -T<traceflag>.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2011 at 3:37 pm
in fact, don't start SQL Server in single user mode by modifying the startup parameters, stop the service and then use the command prompt to start your instance in single user mode
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply