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 |
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 helprestore database blahfrom disk='\\mybackups\thismonth\backup1.BAK' with replace, recovery, stats=5, maxtransfersize=1048576D |
|
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 FROMMASTER..SYSDATABASES sysdb, sys.dm_exec_requests dmvWHERE sysdb.DBID=dmv.DATABASE_ID AND dmv.COMMAND LIKE '%restore%'ORDER BY percent_complete desc,dmv.TOTAL_ELAPSED_TIME/60000 descSo, 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 |
|
|
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 |
|
|
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 ServerPlease follow this link to solve the problem: unspammed |
|
|
|
|
|
|
|