Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Recovery


Recovery

Author
Message
dougjjj
dougjjj
Mr or Mrs. 500
Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)Mr or Mrs. 500 (509 reputation)

Group: General Forum Members
Points: 509 Visits: 644
Last time I tested the Litespeed object level restore it took about the same amount of time as a full restore so i haven't bother with it since, anyone used it recently and can comment about object restore times compared to full database restores on medium/larger databases (50gb-100gb+)?

Cheers



Anipaul
Anipaul
SSCertifiable
SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)

Group: General Forum Members
Points: 6555 Visits: 1407
Good article. It was so nice that freshers will understand it very easily. Great effort. Smile



MudLuck
MudLuck
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 519
Not to be well mean. But building a restore next to a prod DB and comparing data should be what we always do. I'm mean your just sewing together something that is missing. You can't very well roll back a DB to yesterday just because 16 rows where dumped. That would be well foolish.

I will say that I have had to do something similar to what your outlining about 5 times this year alone. One mistake by an analyst or developer can have you up all night. Should we lock them out of PROD, yes of course we do, but what I see in these events is someone drops code that deletes more then it should and once given the right well it can be misused. This can be very painful especially as I have one DB at 2 TB, and it's always an emergency to find a server admin to give me 2 TB of "temp" space as we are running out seems everyday.

the real problem though is people think you can just grab one table from a backup and don't understand you backup the whole data file not objects in DB's. They assume it's 5 minutes when it can take days to bring back and of course they have a deadline that they will now not meet. Ah the glamours life of a DBA.

As for Red gate they own this site so I won't suck up to much (free shwag? just ask for my address) but there backup program is awesome. You can restore just a table out of I think the professional one, but the cost has my management running for the hills. We tried the 14 day eval and it worked wonderfully. I hope they will drop the price a little in the future. I will also add that it isn't all that faster especially if it's a huge table spread across multiple datafiles, but from a not having to call a server admin for space standpoint I find it to be very useful.

Enjoy...



Wayne West
Wayne West
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1734 Visits: 3694
I had to do this with an Access database not long ago. A person was given a copy of the database to do a special study and deleted all of the records that they didn't need for their whatever. Unfortunately they were given a copy of the front-end that connected to the live database, so records went bye-bye.

Fortunately we have pretty good backups and recovery, though a bit of work, wasn't too bad. According to my notes, the user wiped 12,000 records from one table, 20,000 from another.

Such fun! I love what I do for a living!

-----
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson
Misha_SQL
Misha_SQL
Right there with Babe
Right there with Babe (742 reputation)Right there with Babe (742 reputation)Right there with Babe (742 reputation)Right there with Babe (742 reputation)Right there with Babe (742 reputation)Right there with Babe (742 reputation)Right there with Babe (742 reputation)Right there with Babe (742 reputation)

Group: General Forum Members
Points: 742 Visits: 995
I liked this simple technique and can certainly be helpful in cases when the database being restored is relatively small (I live in a data warehousing world, so 16GB is really small to me). Thank you for the article!



David Lu
David Lu
SSC Veteran
SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)

Group: General Forum Members
Points: 202 Visits: 135
Very useful discussion on this partial data recovery.
question:

1. Is there any method in recovering partial, ex 2 tables out of 400 tables 20 gb db?
I still miss the old SQL6.5. I don't think it is available in SQL2000 and SQL2005. how about SQL2008?

2. SQL Data Compare Pro is definitely a good tool in helping the recovery.
I also use SQL Compare Pro. it is a good tool in catching the difference.
But it is very poor in export, ex. to xls with details. I could view them when drilling down on one item, but not export them, any idea?

thanks
-D



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search