|
dolphin123
Starting Member
USA
44 Posts |
 Posted - 08/13/2012 : 09:55:10
|
Hi,
I ran this on the wrong. DB. :(
How do I stop the restore in the middle?? please help
restore database blah
from disk='\\mybackups\thismonth\backup1.BAK'
with replace, recovery, stats=5, maxtransfersize=1048576
D |
|
|
dolphin123
Starting Member
USA
44 Posts |
Posted - 08/13/2012 : 10:23:21
|
hi,
I kept trying the following command and it did not show any restore items on the instance.
SELECT sysdb.NAME,
dmv.PERCENT_COMPLETE AS [PercentComplete],
dmv.TOTAL_ELAPSED_TIME/60000 AS [Elapsed_Time_in_Minutes],
dmv.ESTIMATED_COMPLETION_TIME/60000 AS [Time_Remaining_in_Minutes],
(SELECT TEXT FROM sys.dm_exec_sql_text(dmv.SQL_HANDLE))AS COMMAND FROM
MASTER..SYSDATABASES sysdb, sys.dm_exec_requests dmv
WHERE sysdb.DBID=dmv.DATABASE_ID AND dmv.COMMAND LIKE '%restore%'
ORDER BY percent_complete desc,dmv.TOTAL_ELAPSED_TIME/60000 desc
So, it looks like the restore stopped when i closed the query windows. Thank god.
But the DB says "Restoring" and I am not able to open it.
How do I open it?
- D |
 |
|
How do I stop a restore in the middle
