disaster: How to recover

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?

disaster: How to recover

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/inf...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/
"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:
> 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...[vbcol=seagreen]
> it is bulklogged
> "Zarko Jovanovic" wrote:

disaster: How to recover

Today I did the most stupid step in all my working life ,i was working in ou
r
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/in...veral_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 indica
te
> that is not available but by fault i make the following sql statent (UPDAT
E
> BOOKS SET BOOKID = -1) without the where statment so I destryed my life an
d
> 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 indica
te
> that is not available but by fault i make the following sql statent (UPDAT
E
> BOOKS SET BOOKID = -1) without the where statment so I destryed my life an
d
> 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:
> is the database in simple recovery model or bulklogged or full?
>|||Normally, you would now do a transaction log backup. Then restore the most r
ecent database backup
and all subsequent log backups. For the very last log backup (the one you ju
st performed), you would
use the STOPAT option for the restore command to stop just before the accide
nt.
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 suc
h 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...[vbcol=seagreen]
> it is bulklogged
> "Zarko Jovanovic" wrote:
>

disabling AWE

What are all step do i need to take in order to disable AWE?
Currently, I have /3GB /PAE option setup in my boot.ini and awe is
enabled with 6GB RAM to it what i need to do to disable AWE?Try this,
sp_configure 'awe enabled', 0
GO
RECONFIGURE
GO
Thanks
Hari
<kulkarni.ninad@.gmail.com> wrote in message
news:1174596093.740479.275500@.l77g2000hsb.googlegroups.com...
>
> What are all step do i need to take in order to disable AWE?
> Currently, I have /3GB /PAE option setup in my boot.ini and awe is
> enabled with 6GB RAM to it what i need to do to disable AWE?
>

disabling AWE

What are all step do i need to take in order to disable AWE?
Currently, I have /3GB /PAE option setup in my boot.ini and awe is
enabled with 6GB RAM to it what i need to do to disable AWE?Try this,
sp_configure 'awe enabled', 0
GO
RECONFIGURE
GO
Thanks
Hari
<kulkarni.ninad@.gmail.com> wrote in message
news:1174596093.740479.275500@.l77g2000hsb.googlegroups.com...
>
> What are all step do i need to take in order to disable AWE?
> Currently, I have /3GB /PAE option setup in my boot.ini and awe is
> enabled with 6GB RAM to it what i need to do to disable AWE?
>

disabling AWE

What are all step do i need to take in order to disable AWE?
Currently, I have /3GB /PAE option setup in my boot.ini and awe is
enabled with 6GB RAM to it what i need to do to disable AWE?
Try this,
sp_configure 'awe enabled', 0
GO
RECONFIGURE
GO
Thanks
Hari
<kulkarni.ninad@.gmail.com> wrote in message
news:1174596093.740479.275500@.l77g2000hsb.googlegr oups.com...
>
> What are all step do i need to take in order to disable AWE?
> Currently, I have /3GB /PAE option setup in my boot.ini and awe is
> enabled with 6GB RAM to it what i need to do to disable AWE?
>

Disabling a Step While a Job is Running

Hi,
Kind of a weird question. If I have a SQL job that runs for a long
time and while it is running I realize I want to skip one of the steps
which is still to come, can I update the job while it's running to
make it's On Success action either be, Stop the Job Reporting Success
or Go To Step X? Or does the job essentially get "loaded" when it
starts and no changes will take effect until the next run?
Thanks,
BillMy gut says no, but you could test it easilly by setting job steps with
'WAITFOR' .
"zinck74" <bkelly3@.gmail.com> wrote in message
news:1190238399.358816.128400@.k35g2000prh.googlegroups.com...
> Hi,
> Kind of a weird question. If I have a SQL job that runs for a long
> time and while it is running I realize I want to skip one of the steps
> which is still to come, can I update the job while it's running to
> make it's On Success action either be, Stop the Job Reporting Success
> or Go To Step X? Or does the job essentially get "loaded" when it
> starts and no changes will take effect until the next run?
> Thanks,
> Bill
>

Disable Job Steps

Hi
I have a job setup in SQL Server Agent (SQL 2005) that runs multiple
packages. Each package is run as a separate step in the job. I am busy
testing the job and want to skip some of the longer running packages for now.
Is there a way to disable a job step and then enable it again when I am
ready. Deleting the step and recreating it again is one option, but there
must be a better way
ThanksTake a look at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/e158802c-c347-4a5d-bf75-c03e5ae56e6b.htm
"Trevor Howe" <TrevorHowe@.discussions.microsoft.com> wrote in message
news:13A6603B-003D-4BD8-805F-F37C8AC23A6F@.microsoft.com...
> Hi
> I have a job setup in SQL Server Agent (SQL 2005) that runs multiple
> packages. Each package is run as a separate step in the job. I am busy
> testing the job and want to skip some of the longer running packages for
> now.
> Is there a way to disable a job step and then enable it again when I am
> ready. Deleting the step and recreating it again is one option, but there
> must be a better way
> Thanks|||Trevor Howe wrote:
> Hi
> I have a job setup in SQL Server Agent (SQL 2005) that runs multiple
> packages. Each package is run as a separate step in the job. I am busy
> testing the job and want to skip some of the longer running packages for now.
> Is there a way to disable a job step and then enable it again when I am
> ready. Deleting the step and recreating it again is one option, but there
> must be a better way
> Thanks
On each job step you have to option to decide what to do on "Success"
and on "Failure". Here you can choose to go to certain step in the job
on e.g. "Success".
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Thanks guys. That was fast!! I also found the solution about five minutes
after I sent out the original post. Would'nt it be nice if all responses were
as successful and quick as this one. Now for my next mind bender: What is the
first name of the founder of Microsoft - :0) - Jokes
""Steen Schlüter Persson (DK)"" wrote:
> Trevor Howe wrote:
> > Hi
> >
> > I have a job setup in SQL Server Agent (SQL 2005) that runs multiple
> > packages. Each package is run as a separate step in the job. I am busy
> > testing the job and want to skip some of the longer running packages for now.
> > Is there a way to disable a job step and then enable it again when I am
> > ready. Deleting the step and recreating it again is one option, but there
> > must be a better way
> >
> > Thanks
> On each job step you have to option to decide what to do on "Success"
> and on "Failure". Here you can choose to go to certain step in the job
> on e.g. "Success".
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator
>

Disable Job Steps

Hi
I have a job setup in SQL Server Agent (SQL 2005) that runs multiple
packages. Each package is run as a separate step in the job. I am busy
testing the job and want to skip some of the longer running packages for now
.
Is there a way to disable a job step and then enable it again when I am
ready. Deleting the step and recreating it again is one option, but there
must be a better way
ThanksTake a look at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/e158802c-c347-4a5d-bf75-
c03e5ae56e6b.htm
"Trevor Howe" <TrevorHowe@.discussions.microsoft.com> wrote in message
news:13A6603B-003D-4BD8-805F-F37C8AC23A6F@.microsoft.com...
> Hi
> I have a job setup in SQL Server Agent (SQL 2005) that runs multiple
> packages. Each package is run as a separate step in the job. I am busy
> testing the job and want to skip some of the longer running packages for
> now.
> Is there a way to disable a job step and then enable it again when I am
> ready. Deleting the step and recreating it again is one option, but there
> must be a better way
> Thanks|||Trevor Howe wrote:
> Hi
> I have a job setup in SQL Server Agent (SQL 2005) that runs multiple
> packages. Each package is run as a separate step in the job. I am busy
> testing the job and want to skip some of the longer running packages for n
ow.
> Is there a way to disable a job step and then enable it again when I am
> ready. Deleting the step and recreating it again is one option, but there
> must be a better way
> Thanks
On each job step you have to option to decide what to do on "Success"
and on "Failure". Here you can choose to go to certain step in the job
on e.g. "Success".
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Thanks guys. That was fast!! I also found the solution about five minutes
after I sent out the original post. Would'nt it be nice if all responses wer
e
as successful and quick as this one. Now for my next mind bender: What is th
e
first name of the founder of Microsoft - :0) - Jokes
""Steen Schlüter Persson (DK)"" wrote:

> Trevor Howe wrote:
> On each job step you have to option to decide what to do on "Success"
> and on "Failure". Here you can choose to go to certain step in the job
> on e.g. "Success".
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator
>