MS SQL Server - how can I do a rollback to monday night or friday from last week?

Author

how can I do a rollback to monday night or friday from last week?

pheonix1t

2005-07-21, 8:23 pm

hello,
I'm not on sql too much so please forgive me for my ignorance!

On tuesday, a user tried to add a field to a table via the application
and messed up the database. Ever since then, when you run a query for
the total amount of clients, only about 900 show up - it has over 3000.

So, I was wondering of what the easiest way to fix this would be.

For some reason, the backups of the server weren't being done. My first
idea was to restore a database from a previous day, but now this isn't
possible. I know this is insane, but that's what they were doing!

my next idea was to do a rollback. How can I do a rollback on the
database that would bring the whole thing back to Monday of this week or
Friday of last week?

Thank you,
Dave

Tom Moreau

2005-07-21, 8:23 pm

Without backups, you're pretty much hosed. You can't rollback.

Can you find out the exact query and troubleshoot what the underlying
problem is?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"pheonix1t" <nothing@nothing.gone> wrote in message
news:ufU4MVkjFHA.1204@TK2MSFTNGP12.phx.gbl...
hello,
I'm not on sql too much so please forgive me for my ignorance!

On tuesday, a user tried to add a field to a table via the application
and messed up the database. Ever since then, when you run a query for
the total amount of clients, only about 900 show up - it has over 3000.

So, I was wondering of what the easiest way to fix this would be.

For some reason, the backups of the server weren't being done. My first
idea was to restore a database from a previous day, but now this isn't
possible. I know this is insane, but that's what they were doing!

my next idea was to do a rollback. How can I do a rollback on the
database that would bring the whole thing back to Monday of this week or
Friday of last week?

Thank you,
Dave

pheonix1t

2005-07-21, 8:23 pm

Tom Moreau wrote:
> Without backups, you're pretty much hosed. You can't rollback.
>
> Can you find out the exact query and troubleshoot what the underlying
> problem is?
>
I found out the field they tried to add. They also tried to delete that
field but it's still not working.

I'm not there anymore to today, so I'll login tomorrow and see what's
happening. I don't know how well a job they did of removing the field.
The field was added via an application.

One guy was asking me if it's possible to get a table from a backup
(backup done about 1 year ago! However, this table's data doesn't
change very much) done a year ago and put that table into current database.

I told him I'd get back to him on that...

dave

Tom Moreau

2005-07-22, 3:23 am

If you could script out the table and show us the query, that would be a
good start.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"pheonix1t" <nothing@nothing.gone> wrote in message
news:%23fckhWljFHA.2472@TK2MSFTNGP15.phx.gbl...
Tom Moreau wrote:
> Without backups, you're pretty much hosed. You can't rollback.
>
> Can you find out the exact query and troubleshoot what the underlying
> problem is?
>
I found out the field they tried to add. They also tried to delete that
field but it's still not working.

I'm not there anymore to today, so I'll login tomorrow and see what's
happening. I don't know how well a job they did of removing the field.
The field was added via an application.

One guy was asking me if it's possible to get a table from a backup
(backup done about 1 year ago! However, this table's data doesn't
change very much) done a year ago and put that table into current database.

I told him I'd get back to him on that...

dave

Sponsored Links