stopping restore
in [Server Configuration]
|
From: Alberto Brivio on 30 Jun 2008 10:41 Dear ALL, in SQL SERVER 2005 environmente how can I stop a restore? Regards Alberto
From: Tibor Karaszi on 30 Jun 2008 11:21 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 -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Alberto Brivio" <a.brivio(a)adb.it> wrote in message news:eDSGj8r2IHA.5472(a)TK2MSFTNGP06.phx.gbl... > Dear ALL, > > in SQL SERVER 2005 environmente how can I stop a restore? > > Regards > > Alberto >
From: Alberto Brivio on 30 Jun 2008 11:45 It is started by a cmmands' job, and the job is stop now but the restoring seems to be looping "Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> ha scritto nel messaggio news:E6316F02-33F6-4BD6-BA1F-11A2D5119C8D(a)microsoft.com... > 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 > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > "Alberto Brivio" <a.brivio(a)adb.it> wrote in message > news:eDSGj8r2IHA.5472(a)TK2MSFTNGP06.phx.gbl... >> Dear ALL, >> >> in SQL SERVER 2005 environmente how can I stop a restore? >> >> Regards >> >> Alberto >> >
From: Tibor Karaszi on 30 Jun 2008 12:04 > but the restoring > seems to be looping How do you determine that? -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Alberto Brivio" <a.brivio(a)adb.it> wrote in message news:uuBcMgs2IHA.5920(a)TK2MSFTNGP06.phx.gbl... > It is started by a cmmands' job, and the job is stop now but the restoring > seems to be looping > > > "Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> ha > scritto nel messaggio > news:E6316F02-33F6-4BD6-BA1F-11A2D5119C8D(a)microsoft.com... >> 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 >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://sqlblog.com/blogs/tibor_karaszi >> >> >> "Alberto Brivio" <a.brivio(a)adb.it> wrote in message >> news:eDSGj8r2IHA.5472(a)TK2MSFTNGP06.phx.gbl... >>> Dear ALL, >>> >>> in SQL SERVER 2005 environmente how can I stop a restore? >>> >>> Regards >>> >>> Alberto >>> >> > >
From: Alberto Brivio on 30 Jun 2008 12:21 Database is in restoring mode, and no activity is regestered on the server "Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> ha scritto nel messaggio news:17811F3D-C470-4861-AAE2-5D59E9F1A3C4(a)microsoft.com... >> but the restoring seems to be looping > > How do you determine that? > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > "Alberto Brivio" <a.brivio(a)adb.it> wrote in message > news:uuBcMgs2IHA.5920(a)TK2MSFTNGP06.phx.gbl... >> It is started by a cmmands' job, and the job is stop now but the >> restoring seems to be looping >> >> >> "Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> ha >> scritto nel messaggio >> news:E6316F02-33F6-4BD6-BA1F-11A2D5119C8D(a)microsoft.com... >>> 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 >>> >>> -- >>> Tibor Karaszi, SQL Server MVP >>> http://www.karaszi.com/sqlserver/default.asp >>> http://sqlblog.com/blogs/tibor_karaszi >>> >>> >>> "Alberto Brivio" <a.brivio(a)adb.it> wrote in message >>> news:eDSGj8r2IHA.5472(a)TK2MSFTNGP06.phx.gbl... >>>> Dear ALL, >>>> >>>> in SQL SERVER 2005 environmente how can I stop a restore? >>>> >>>> Regards >>>> >>>> Alberto >>>> >>> >>
|
Next
|
Last
Pages: 1 2 Prev: Newbie - What's the default location of my database Next: Saving SP takes a long time.... |