Today I did the most stupid step in all my working life ,i was working in our
cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
, and there is an urgent change to bookid number for books due to some
criteria from manager so i a have to change the bookid 252 to -1 to indicate
that is not available but by fault i make the following sql statent (UPDATE
BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
there is no backup since 7 working days ,what should I do to recover from
this ? the daily transactions on book ids in hunderds ...what should i do
please to recover my data? all book id colmun be -1"Minimizing data loss when accidents happens "
http://www.karaszi.com/SQLServer/info_restore_log_several_times.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Raed Sawalha" <RaedSawalha@.discussions.microsoft.com> wrote in message
news:EA39374D-6F2A-48B5-810A-25ABC4B9E0C6@.microsoft.com...
> Today I did the most stupid step in all my working life ,i was working in our
> cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
> , and there is an urgent change to bookid number for books due to some
> criteria from manager so i a have to change the bookid 252 to -1 to indicate
> that is not available but by fault i make the following sql statent (UPDATE
> BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
> there is no backup since 7 working days ,what should I do to recover from
> this ? the daily transactions on book ids in hunderds ...what should i do
> please to recover my data? all book id colmun be -1|||Raed Sawalha wrote:
> Today I did the most stupid step in all my working life ,i was working in our
> cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
> , and there is an urgent change to bookid number for books due to some
> criteria from manager so i a have to change the bookid 252 to -1 to indicate
> that is not available but by fault i make the following sql statent (UPDATE
> BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
> there is no backup since 7 working days ,what should I do to recover from
> this ? the daily transactions on book ids in hunderds ...what should i do
> please to recover my data? all book id colmun be -1
is the database in simple recovery model or bulklogged or full?|||it is bulklogged
"Zarko Jovanovic" wrote:
> Raed Sawalha wrote:
> > Today I did the most stupid step in all my working life ,i was working in our
> > cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
> > , and there is an urgent change to bookid number for books due to some
> > criteria from manager so i a have to change the bookid 252 to -1 to indicate
> > that is not available but by fault i make the following sql statent (UPDATE
> > BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
> > there is no backup since 7 working days ,what should I do to recover from
> > this ? the daily transactions on book ids in hunderds ...what should i do
> > please to recover my data? all book id colmun be -1
> is the database in simple recovery model or bulklogged or full?
>|||Normally, you would now do a transaction log backup. Then restore the most recent database backup
and all subsequent log backups. For the very last log backup (the one you just performed), you would
use the STOPAT option for the restore command to stop just before the accident.
Since you are in bulk logged mode, whether you can do point in time restore for the last log backup
depend on whether you have performed any minimally logged operations. If such have been done, no
point in time.
See the article I posted and Books Online for more information.
Also, a log reader program can be useful (again see my articles).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Raed Sawalha" <RaedSawalha@.discussions.microsoft.com> wrote in message
news:A4289B58-3111-4C4C-B028-29698E9945AB@.microsoft.com...
> it is bulklogged
> "Zarko Jovanovic" wrote:
>> Raed Sawalha wrote:
>> > Today I did the most stupid step in all my working life ,i was working in our
>> > cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
>> > , and there is an urgent change to bookid number for books due to some
>> > criteria from manager so i a have to change the bookid 252 to -1 to indicate
>> > that is not available but by fault i make the following sql statent (UPDATE
>> > BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
>> > there is no backup since 7 working days ,what should I do to recover from
>> > this ? the daily transactions on book ids in hunderds ...what should i do
>> > please to recover my data? all book id colmun be -1
>> is the database in simple recovery model or bulklogged or full?
没有评论:
发表评论