September 19, 2011 at 3:07 am
Hi all,
By mistake one of my colleague deleted all record from a table, he forgot to put where condition in delete statement 😛 how can i get all those records.
any help will be highly appreciated.
September 19, 2011 at 3:11 am
Best by far is restore from one of your backups.
Do you have any?
Mike
September 19, 2011 at 3:32 am
Is there any way to do it from sql server logs.
no i don't have any, its a development database so we don't take backup at regular basis.
September 19, 2011 at 3:50 am
If the database is in full recovery, you can buy Apex SQL Log (~ $1000). If the DB is in simple recovery, the log records may have been overwritten already.
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
September 21, 2011 at 9:06 am
If it's a development database, can you simply replace the data using the same table in production? This may not include data modified during development, though if you saved your dev scripts you can try to get back into the same state.
I apologize for pointing out something so obvious, but I figured we should cover all the options.
September 21, 2011 at 9:16 am
ghanshyam.kundu (9/19/2011)
Is there any way to do it from sql server logs.no i don't have any, its a development database so we don't take backup at regular basis.
Don't have any, or only an old one?
If you're in full and have an old backup you can recover from this.
Take tail log backup. Restore full + log to point in time and you should be good to go.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply