December 9, 2011 at 6:50 am
I have no idea about it
Can you help me out?
December 9, 2011 at 6:51 am
@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.
December 9, 2011 at 6:53 am
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.
December 9, 2011 at 6:54 am
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.
December 9, 2011 at 6:57 am
Restore database is one option but we have no rights for that and also it data centre server and they charge for space
December 9, 2011 at 6:58 am
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.
December 9, 2011 at 7:01 am
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 spaceYou 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.
December 9, 2011 at 7:08 am
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
December 9, 2011 at 7:11 am
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
December 9, 2011 at 7:18 am
I think i have to post support ticket to microsoft for the same.
December 9, 2011 at 7:22 am
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.
December 9, 2011 at 7:24 am
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.
December 9, 2011 at 7:24 am
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
December 9, 2011 at 7:28 am
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
December 9, 2011 at 7:30 am
I think there are some hidden command in sql server which Microsoft not make it public.
Can any body know the powershell command?
Viewing 15 posts - 16 through 30 (of 58 total)
You must be logged in to reply to this topic. Login to reply