Rollback data

Question

Post reply

Rollback data

Viewing 15 posts - 16 through 30 (of 58 total)

You must be logged in to reply to this topic. Login to reply

prashant-507002 SSC Eights! Points: 922 More actions · Answer 1

prashant-507002

SSC Eights!

Points: 922

December 9, 2011 at 6:50 am

#1419301

I have no idea about it

Can you help me out?

Devendrakumar Shirbad SSC-Forever Points: 42493 More actions · Answer 2

@prashant: I would suggest you not to panic & implement anything blindly. Accept the fact & buy some time from Management.

Meanwhile prepare yourself to restore the data on another server. Then SYNC up.

Mike John SSCertifiable Points: 7186 More actions · Answer 3

Its is not likely many people can help remotely, but give us some details to work with.

a) DO you have a backup?

b) Can you restore it to a clean db? - if not why not?

c) What recovery model is the original database in?

d) Do you have a budget for a log reader tool?

Mike

Edit - and I second what Dev just said. Take time, do not make it worse.

Devendrakumar Shirbad SSC-Forever Points: 42493 More actions · Answer 4

Dev (12/9/2011)
@prashant: I would suggest you not to panic & implement anything blindly. Accept the fact & buy some time from Management.
Meanwhile prepare yourself to restore the data on another server. Then SYNC up.

Also, if you are not confident to do so, ask for help from your team. Please don't mess-up with your PROD box anymore.

prashant-507002 SSC Eights! Points: 922 More actions · Answer 5

Restore database is one option but we have no rights for that and also it data centre server and they charge for space

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

prashant-507002 (12/9/2011)
Restore database is one option but we have no rights for that and also it data centre server and they charge for space

You can restore to your local machine or laptop and then re-import only the missing data.

Cadavre SSC-Forever Points: 41690 More actions · Answer 7

Ninja's_RGR'us (12/9/2011)
prashant-507002 (12/9/2011)
Restore database is one option but we have no rights for that and also it data centre server and they charge for space
You can restore to your local machine or laptop and then re-import only the missing data.

Agreed. The issue being that if your database is still running then any new transaction would show up as bad, depending on how you write your query so be careful.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 8

Mike John (12/9/2011)
Before you worry anout tools what recovery model is the db in?
Redgate do one - http://www.red-gate.com/products/dba/sql-log-rescue/
I have not used it personally but have heard good reports

SQL 2000 only. The SQL 2005/2008 one (from Apex) is around $1000.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 9

The only way you're going to get this data back (other than with expensive tools) is to restore the database somewhere else, restore it to just before the update was run and then sync the data back it.

There's no magic undo command, no secret way of undoing an update. Restore the backup, copy the data.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

prashant-507002 SSC Eights! Points: 922 More actions · Answer 10

I think i have to post support ticket to microsoft for the same.

Cadavre SSC-Forever Points: 41690 More actions · Answer 11

prashant-507002 (12/9/2011)
I think i have to post support ticket to microsoft for the same.

Who will tell you that you need to restore your database somewhere, then copy the data back into your production environment.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Devendrakumar Shirbad SSC-Forever Points: 42493 More actions · Answer 12

prashant-507002 (12/9/2011)
I think i have to post support ticket to microsoft for the same.

I am not sure on it. It's not a bug or product flaw. It also depends on your support agreement. Also, they can’t jump in immediately to rescue you. They will take their own time.

They will not do any magic except what we have already suggested to you.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 13

Cadavre (12/9/2011)
prashant-507002 (12/9/2011)
I think i have to post support ticket to microsoft for the same.
Who will tell you that you need to restore your database somewhere, then copy the data back into your production environment.

+1 000 000

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 14

Cadavre (12/9/2011)
prashant-507002 (12/9/2011)
I think i have to post support ticket to microsoft for the same.
Who will tell you that you need to restore your database somewhere, then copy the data back into your production environment.

Exactly what they will tell you, and they'll charge $200 or more for doing so.

No magic commands, no secret switches. Restore database, copy data over.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

prashant-507002 SSC Eights! Points: 922 More actions · Answer 15

I think there are some hidden command in sql server which Microsoft not make it public.

Can any body know the powershell command?