Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nazanintb
Starting Member
1 Post |
 Posted - 2011-11-06 : 07:50:08
|
| 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 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-11-06 : 08:54:00
|
| Kill the sql server sevice using command promptsc queryex Yoursqlservice which will return the PID of the service then run thistaskkill /PID PIDNumber/FPBUH |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-11-06 : 10:13:54
|
| Wait...You deleted data in a user database and needed to recover that data, and you decided to completely restore the whole system? Including all system databases, all user databases, everything?I hope you haven't gotten too far into that process, as that is a very drastic measure to recover deleted data from one user database.The easiest method would have been to restore the user database as a different database (including log backups up to right before you deleted the data), then copy from this database the deleted data and put it back in the production database.The next best method would have been to restore the user database, including all transaction log backups up to the point in time of your delete and accept the data loss from that point forward.At this point, is SQL Server down and unavailable? If so, can you restart it normally and get the system back up and available as it was before you started this process?Jeff |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
sql server starup problem