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 |
|
dwells
Starting Member
1 Post |
 Posted - 2005-09-07 : 09:52:33
|
| Hi AllForgive my ignorance. I have been told you cannot run a force restore without SQL Agent running? Is that so?Also, is it possible to execute a force restore from a command line. If so, how would you go about do this.I ask these questions because recently our database and MSBD files became corrupted and couldn't restore them in the normal way. Had to manually rebuild MSDB file.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-07 : 13:03:42
|
| What do you mean by force restore? SQL Agent only needs to be running if you are going to do this in a job. What is an MSDB file?Tara |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-07 : 22:51:46
|
read isql or osql in books online, it's the same as using restore in Query Analyzer only in dos modequote:
Originally posted by dwells
Hi AllAlso, is it possible to execute a force restore from a command line. If so, how would you go about do this.
How did you go about restoration the normal way? Did you encounter errors?--------------------keeping it simple... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-08 : 06:31:25
|
| "What do you mean by force restore"Maybe this:ALTER DATABASE MyDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATEKristen |
|
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2005-09-08 : 09:41:33
|
| In Enterprise Manager, when restoring a database, there's a selection "Force Restore over Existing Database". Perhaps that's what's being referred to ? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-09 : 19:54:21
|
| Kristen's command, if ran right before the restore, will have the same affect.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Force Restore