December 14, 2011 at 8:15 am
Don't screw up the data.
It's thumb rule.
I am assuming you are an accidental DBA so am recommending you following. It's a MUST know for a DBA.
Introduction to Backup and Restore Strategies in SQL Server
http://msdn.microsoft.com/en-us/library/ms191239(v=SQL.100).aspx
December 14, 2011 at 8:19 am
Dev (12/14/2011)
Don't screw up the data.
It's thumb rule.
I am assuming you are an accidental DBA so am recommending you following. It's a MUST know for a DBA.
Introduction to Backup and Restore Strategies in SQL Server
http://msdn.microsoft.com/en-us/library/ms191239(v=SQL.100).aspx
So in your schedule you have room planned for screw up this db and repair 1 day later?
DBAs are gardian of the data. There's no higher priority in your responsibilities' list.
December 14, 2011 at 8:22 am
If you are good DBA then why not provide me solution.
December 14, 2011 at 8:22 am
Ninja's_RGR'us (12/14/2011)
Dev (12/14/2011)
Don't screw up the data.
It's thumb rule.
I am assuming you are an accidental DBA so am recommending you following. It's a MUST know for a DBA.
Introduction to Backup and Restore Strategies in SQL Server
http://msdn.microsoft.com/en-us/library/ms191239(v=SQL.100).aspx
So in your schedule you have room planned for screw up this db and repair 1 day later?
DBAs are gardian of the data. There's no higher priority in your responsibilities' list.
I must have added the precaution there ‘NOT to try on PROD’. No... Never...
December 14, 2011 at 8:23 am
If you are good DBA then why not provide me solution.
It seems to me that solutions are being provided and you are failing to implement them. Why did you come here to ask a question if you are just going to argue with the experts?
Jared
Jared
CE - Microsoft
December 14, 2011 at 8:25 am
That what i did, but for overcome such a incident we have to share our knowldge here.
December 14, 2011 at 8:26 am
prashant-507002 (12/14/2011)
If you are good DBA then why not provide me solution.
I don't know for sure about dev but most of us are far beyond good & great.
1+1=2. There, the end. Nothing else to add or do. You lost data? Go to your backups of the data and fetch it.
It's THAT SIMPLE.
You want more help / training, you need a consult. Most of us are available remotely but it's not free. We can help you but we can't do your job for you over these forums.
December 14, 2011 at 8:27 am
p-nut (12/14/2011)
Dev (12/9/2011)
prashant-507002 (12/9/2011)
Actually this action was done by a developer.And i have find out the solution for. Server is live and i can not restore the backup.
I am sorry but both of you are in serious trouble... 🙁
Now Dev, don't go scaring people. We all make mistakes and the important thing is how we handle those mistakes and what we learn from them.
OP, as a previous response said... Restore a backup of this database to a new database that can be removed later. As long as you have a way to identify individual rows between the 2 different databases and the same table, you should be able to update from the restored backup and get the data back to its original state.
Jared
Agree but not in PROD. The owner of PROD box should understand his responsibilities. If it's scary, they shouldn't opt for it. (BTW I asked not to panic after that, if you miss that part :-P)
December 14, 2011 at 8:27 am
prashant-507002 (12/14/2011)
That what i did, but for overcome such a incident we have to share our knowldge here.
And we are happy to do so. But there's a limit to what we can do over forums. Especially when the poster seems not very cooperative (or maybe langage barrier).
December 14, 2011 at 8:29 am
Ninja's_RGR'us (12/14/2011)
prashant-507002 (12/14/2011)
If you are good DBA then why not provide me solution.I don't know for sure about dev but most of us are far beyond good & great.
1+1=2. There, the end. Nothing else to add or do. You lost data? Go to your backups of the data and fetch it.
It's THAT SIMPLE.
You want more help / training, you need a consult. Most of us are available remotely but it's not free. We can help you but we can't do your job for you over these forums.
Hehe... yes its early and I didn't see that this thread was 6 pages. Should have read everything first. 😛
Jared
Jared
CE - Microsoft
December 14, 2011 at 8:29 am
Actually i had already successfully restore the backup and put the database in the latest stage.
December 14, 2011 at 8:31 am
prashant-507002 (12/14/2011)
Actually i had already successfully restore the backup and put the database in the latest stage.
Awesome, thanks for the feedback.
December 14, 2011 at 8:31 am
p-nut (12/14/2011)
Ninja's_RGR'us (12/14/2011)
prashant-507002 (12/14/2011)
If you are good DBA then why not provide me solution.I don't know for sure about dev but most of us are far beyond good & great.
1+1=2. There, the end. Nothing else to add or do. You lost data? Go to your backups of the data and fetch it.
It's THAT SIMPLE.
You want more help / training, you need a consult. Most of us are available remotely but it's not free. We can help you but we can't do your job for you over these forums.
Hehe... yes its early and I didn't see that this thread was 6 pages. Should have read everything first. 😛
Jared
It's only 2 pages for me. Maybe it's a good idea for you ;-).
December 14, 2011 at 8:38 am
Last 2 comments on the thread.
I don't know for sure about dev but most of us are far beyond good & great.
Certainly, it's a long way to go & I just started on it. Even if I reach somewhat close to what I am planning for, I might not claim myself to be good & great.
If you are good DBA then why not provide me solution.
It's subject to situation and available resources. What all resources you had in place we suggested based on that.
Viewing 14 posts - 46 through 58 (of 58 total)
You must be logged in to reply to this topic. Login to reply