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 |
|
YogeshDesai
Posting Yak Master
136 Posts |
 Posted - 2007-09-20 : 12:50:03
|
| Hi Guys, I am restoring master database from backup. I have started SQL server in single user mode and select the option to restore master. It's just showing me the restoring window and db size is 17 mb. from last couple of min. It's not showing anything could you help me how to check.How much time it will take to restore How can I check it's in process any clues ...or suggestion for or steps to restore master from backup so I can cancle and start it again.SQL IN Minds |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-20 : 12:53:46
|
| Did you use the -c and -m options from the command prompt? There is no way to check the progress of the restore unless you are doing it through the GUI.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
YogeshDesai
Posting Yak Master
136 Posts |
Posted - 2007-09-20 : 13:01:34
|
yes i check it. For reference please find the screeshotsSQL IN Minds and the other one  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-20 : 20:01:58
|
"There is no way to check the progress of the restore unless you are doing it through the GUI."Even using the STATS option of RESTORE? or am I missing the point again?  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-21 : 12:39:50
|
| D'oh! Although I haven't found the STATS option to be very accurate, but at least it indicates progress in general.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-21 : 12:45:33
|
| My guess would be that the same programmer who wrote the chucking-sheets-of-paper moving icons and general file copying "thermometer bars" also got to calculate the restore percentages for the Restore STATS option! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-21 : 13:01:44
|
| LMAO! And agreed on that. You'd think they'd have improved this algorithm by now.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Restoring master database