Tuesday, February 14, 2012

Can I recover?

An update statement was made against a table that did not include a 'where'
clause and hence all the records were updated and basically destroying all
the data.
There is no recent backup of the database ( the last one was in February).
Is there anyway to get back to the the way the table was before the update?
Thanks for any help,
Patrick
--== Posted via mcse.ms - Unlimited-Uncensored-Secure Usenet News==-
--
http://www.mcse.ms The #1 Newsgroup Service in the World! 120,000+ New
sgroups
--= East and West-Coast Server Farms - Total Privacy via Encryption =--> There is no recent backup of the database ( the last one was in February).
WHOOPS!

> Is there anyway to get back to the the way the table was before the
> update?
http://www.aspfaq.com/2449|||"Patrick Nolan" <nolanpa@.bcsd.com> wrote in message
news:1126123461_16397@.spool6-east.superfeed.net...
> An update statement was made against a table that did not include a
> 'where'
> clause and hence all the records were updated and basically destroying all
> the data.
> There is no recent backup of the database ( the last one was in February).
> Is there anyway to get back to the the way the table was before the
> update?
> Thanks for any help,
> Patrick
>
Ouch!!!
You can purchase one of several well-known products that Aaron listed, or if
you know about the time that the update took place *AND* you have
transaction logs, then you can do a Point in Time restore.
Check the BOL for specifics on this.
Rick Sawtell
MCT, MCSD, MCDBA|||It depends on the recovery model you're using. If you're using the full
recovery model, then you can probably use a log reader. If you're using the
simple recovery model, then you might be out of luck.
"Patrick Nolan" <nolanpa@.bcsd.com> wrote in message
news:1126123461_16397@.spool6-east.superfeed.net...
> An update statement was made against a table that did not include a
'where'
> clause and hence all the records were updated and basically destroying all
> the data.
> There is no recent backup of the database ( the last one was in February).
> Is there anyway to get back to the the way the table was before the
update?
> Thanks for any help,
> Patrick
>
> --== Posted via mcse.ms - Unlimited-Uncensored-Secure Usenet
News==--
> http://www.mcse.ms The #1 Newsgroup Service in the World! 120,000+
Newsgroups
> --= East and West-Coast Server Farms - Total Privacy via Encryption
=--|||Rick..how is your solution accomplished? I did not think this was possible
without a DB backup. I just want to understand in case I ever need it too.
Thanks..
"Rick Sawtell" wrote:

> "Patrick Nolan" <nolanpa@.bcsd.com> wrote in message
> news:1126123461_16397@.spool6-east.superfeed.net...
> Ouch!!!
> You can purchase one of several well-known products that Aaron listed, or
if
> you know about the time that the update took place *AND* you have
> transaction logs, then you can do a Point in Time restore.
> Check the BOL for specifics on this.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||"NetByTelDBA" <NetByTelDBA@.discussions.microsoft.com> wrote in message
news:644AA6A1-220F-4A59-84AE-70FA438E6157@.microsoft.com...
> Rick..how is your solution accomplished? I did not think this was
> possible
> without a DB backup. I just want to understand in case I ever need it
> too.
> Thanks..
> "Rick Sawtell" wrote:
>
Check the BOL for:
RESTORE LOG ... WITH STOPAT
Rick Sawtell
MCT, MCSD, MCDBA|||Rick, thanks, but I am still . Looked at the STOPAT, but still
thought a DB restore would be needed first, which was indicated by BOL. Can
the restore log command be accomplished without restoring a DB backup? Just
trying to learn all I can. thanks again..
"Rick Sawtell" wrote:

> "NetByTelDBA" <NetByTelDBA@.discussions.microsoft.com> wrote in message
> news:644AA6A1-220F-4A59-84AE-70FA438E6157@.microsoft.com...
> Check the BOL for:
> RESTORE LOG ... WITH STOPAT
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Maybe you should also look into preventing such... khm... situations.
For instance - doing it step by step (in transaction):
begin tran
-- do your modifications here
-- check results
-- then either:
rollback tran -- if something went wrong
-- or:
commit tran -- if all is well in the world of data storage
ML
p.s. oh, and yeah - backup.|||If the one that you made on Feb was a Full Database Backup and the recovery
mode has been setup with "Full", I believe you can backup the current
Transaction Log and then you can still do a "Point In Time" restore.
Ed
"Patrick Nolan" wrote:

> An update statement was made against a table that did not include a 'where
'
> clause and hence all the records were updated and basically destroying all
> the data.
> There is no recent backup of the database ( the last one was in February).
> Is there anyway to get back to the the way the table was before the update
?
> Thanks for any help,
> Patrick
>
> --== Posted via mcse.ms - Unlimited-Uncensored-Secure Usenet News=
=--
> http://www.mcse.ms The #1 Newsgroup Service in the World! 120,000+ N
ewsgroups
> --= East and West-Coast Server Farms - Total Privacy via Encryption =--
-
>|||> Rick, thanks, but I am still . Looked at the STOPAT, but still
> thought a DB restore would be needed first, which was indicated by BOL.
Correct. So your only option is if the db has been in full recovery mode sin
ce your last db backup
(not likely) and you now do a log backup. Or use a log reader tool. Some add
itional info at
http://www.karaszi.com/SQLServer/in...eral_times.asp.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"NetByTelDBA" <NetByTelDBA@.discussions.microsoft.com> wrote in message
news:DA40AC62-F241-4356-A5EB-83B83ABF80F9@.microsoft.com...
> Rick, thanks, but I am still . Looked at the STOPAT, but still
> thought a DB restore would be needed first, which was indicated by BOL. C
an
> the restore log command be accomplished without restoring a DB backup? Ju
st
> trying to learn all I can. thanks again..
> "Rick Sawtell" wrote:
>

No comments:

Post a Comment