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 |
|
mdelgado
Posting Yak Master
141 Posts |
 Posted - 2003-10-28 : 12:04:59
|
| Can anyone please tell me how to stop SQL automated recovery process so that I can do a manual restore?thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-28 : 12:19:50
|
| You could just stop the service. The database will probably be marked suspect or in loading state after the service is started, but at that point you can just delete it and then do your manual restore.You also might be able to KILL the spid, but I'm not sure.Tara |
 |
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2003-10-28 : 16:06:05
|
| Tried that. I even went as far as to cycle the server and when everything came back up, it continued to recover. It took almost 4 hours this morning. If I could have stopped the recovery and manually restored, that would have only taken about 15 minutes. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-28 : 17:09:52
|
| You could have stopped the service, then deleted the MDF and LDF file. Then the database would come up as suspect. You could have then manually deleted it.Tara |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-28 : 21:01:44
|
| There is an undocumented trace flag that will prevent auto-recovery, 3608. You would need to shut down SQL Server and restart it manually from a command prompt. Books Online describes this process under "command prompt utilities, sqlservr". You would need to specify the -T parameter like so: -T3608. You will probably also need to use the -f, -c, and -m parameters as well. |
|
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2003-10-29 : 07:45:16
|
| great advice. thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-29 : 12:00:12
|
| Thanks for the info Rob, I'll have to remember that one.Tara |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
|
|
stop auto recovery.