 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / June 2008stopping restore
Dear ALL, in SQL SERVER 2005 environmente how can I stop a restore? Regards Alberto Whatever tool you are executing the RESTORE command can signal an attention signal to stop the restore. The attention signal is what happens when you from SSMS Query window press the "Cancel Executing Query" button. SQL Server should adhere to this request and stop the restore process. Of course the database name you restore into will be useless and you either have to drop it or re-do the restore. Or, if your situation is that you did by mistake RESTORE using the NORECOVERY option, and want to perform the REDO phase, just execute: RESTORE DATABASE dbname WITH RECOVERY  SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > Dear ALL, > [quoted text clipped - 3 lines] > > Alberto It is started by a cmmands' job, and the job is stop now but the restoring seems to be looping > Whatever tool you are executing the RESTORE command can signal an > attention signal to stop the restore. The attention signal is what happens [quoted text clipped - 14 lines] >> >> Alberto > but the restoring > seems to be looping How do you determine that? SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > It is started by a cmmands' job, and the job is stop now but the restoring > seems to be looping [quoted text clipped - 17 lines] >>> >>> Alberto Database is in restoring mode, and no activity is regestered on the server >> but the restoring seems to be looping > [quoted text clipped - 21 lines] >>>> >>>> Alberto Then you probably did the restore using the NORECOVERY option Try below as suggested in my first reply: RESTORE DATABASE dbname WITH RECOVERY SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > Database is in restoring mode, and no activity is regestered on the server > [quoted text clipped - 21 lines] >>>>> >>>>> Alberto |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.