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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How do I stop a restore in the middle

Author  Topic 

dolphin123
Yak Posting Veteran

84 Posts

Posted - 2012-08-13 : 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
Yak Posting Veteran

84 Posts

Posted - 2012-08-13 : 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
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2012-08-22 : 23:34:19
Check this article, it will help you to resolve this issue:
http://beyondrelational.com/modules/2/blogs/634/posts/17529/how-to-recover-a-database-stuck-in-restore-mode.aspx
Go to Top of Page

adolfmitchel
Starting Member

3 Posts

Posted - 2014-10-26 : 14:03:11
When you use group by, each column in the select clause must be either defined. use Recovery Toolbox for SQL Server

Please follow this link to solve the problem: unspammed
Go to Top of Page
   

- Advertisement -