Revert to checkpoint

Hi,
Our application has an automatic software update feature.
We want to create a checkpoint (certain point in time) in the database
in order to revert to this checkpoint when somewhere in the software
update sequence error(s) occur...
Is this possible in MSSQL?
Transaction blocks are not possible because queries are executed from
different parts of our code...
Thanks in advance,
Greetz,
R. OosterholtHi
Your code sounds to be a nightmare especially as this is a software upgrade.
I suggest that you backup the database at given points so that you can
restore to a known point, or instigate a mechanism that you can log the time
s
when you can recover to a known point in time.
John
"r.oosterholt@.gmail.com" wrote:

> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
> Thanks in advance,
> Greetz,
> R. Oosterholt
>|||One option could be to set a log marker (BAGINF TRAN ... WITH MARK) so you l
ater can restore to that
point when you restore a transaction log backup. Assumes a sound backup stra
tegy, of course.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<r.oosterholt@.gmail.com> wrote in message
news:1163779835.179635.247540@.b28g2000cwb.googlegroups.com...
> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
> Thanks in advance,
> Greetz,
> R. Oosterholt
>|||r.oosterholt@.gmail.com wrote:
> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
> Thanks in advance,
> Greetz,
> R. Oosterholt
>
If you're doing regular transaction log backups, you can restore a
database to any point in time using the STOPAT clause on the RESTORE
command...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||<r.oosterholt@.gmail.com> wrote in message
news:1163779835.179635.247540@.b28g2000cwb.googlegroups.com...
> Hi,
> Our application has an automatic software update feature.
> We want to create a checkpoint (certain point in time) in the database
> in order to revert to this checkpoint when somewhere in the software
> update sequence error(s) occur...
> Is this possible in MSSQL?
> Transaction blocks are not possible because queries are executed from
> different parts of our code...
>
Can you just take a full database backup, and restore the backup on failure?
Also on Enterprise Edition, you can take a Database Snapshot, and restore
from that.
David|||Thanks all!
Snapshot is the best option for us.
Pity it is only available in 2005 EE...
Rick O.
On 17 nov, 17:25, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:[vbcol=seagreen]
> One option could be to set a log marker (BAGINF TRAN ... WITH MARK) so you
later can restore to that
> point when you restore a transaction log backup. Assumes a sound backup st
rategy, of course.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph
ttp://www.solidqualitylearning.com/
> <r.oosterh...@.gmail.com> wrote in messagenews:1163779835.179635.247540@.b28
g2000cwb.googlegroups.com...
>
>
>
>
>
>
>