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 |
|
bbondi
Starting Member
20 Posts |
 Posted - 2007-10-26 : 13:58:36
|
| How do I get the Restore process to stop? It has been hung for several hours. The normal time to do a restore is about 5 minutes.The DB is not very large, the .bak file unzipped is about 700,000,000 bytes.TIA,BobDo the Social Engineering teams need QA? Naw, let 'em have fun! |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
bbondi
Starting Member
20 Posts |
Posted - 2007-10-26 : 14:34:46
|
| I'd guess no, it is not in single-user mode.I have a script which starts SQL like this:net start "SQL Server (MSSQLSERVER)"net start "SQL Server Agent (MSSQLSERVER)"net start "SQL Server Browser"net start "SQL Server FullText Search (MSSQLSERVER)"net start "SQL Server Integration Services"net start "SQL Server VSS Writer"The author of the script is not available.I have a script I've been using to do the restore of the DB. Since, I am an SQE I need to test and restore often during the day. This is the 1st time I've had this issue!Do the Social Engineering teams need QA? Naw, let 'em have fun! |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-26 : 17:25:13
|
| Might the Backup file be damaged?Worth checking the database the backup was made from (assuming that is NOT the one you are restoring it to) in case it is damaged:DBCC CHECKDB('MyDatabaseName') WITH NO_INFOMSGSKristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-27 : 00:35:52
|
| You can find db status in ssms, is it still in loading status? Run 'sp_who2 active' in query windows, is restore process in the result? You can kill it if want to stop db restoring. |
|
|
|
|
|
|
CompanyDB (Restoring...) won't stop