Backup Strategy

Question

Backup Strategy

hhh-469634

SSC Enthusiast

Points: 142
More actions
September 21, 2007 at 9:37 pm

#70118

Hi Gurus, I have to develop a backup strategy for my company, Can you guys please help me what would be the best one.I understand that it all depends on our company requirement but I was confused whether to used differential backup or not
Any help will be highly appreciated.

Viewing 3 posts - 1 through 2 (of 2 total)

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

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

As you said yourself, it depends on the requirements. How big is your database, how many transactions happen every day, what amount of dataloss is acceptable, how long is your backup window, etc.

I must say I hardly ever use diferential backup, usually a daily full backup with log backups inbetween works fine. But if you have a very lage database or huge transaction rates then diff backup can be interesting. But in these cases it might also be worth looking into filegroup backups.

I don't have any link at hand right now, but if you search on this site or at http://www.databasejournal.com you should find some articles on this topic.

Markus

[font="Verdana"]Markus Bohse[/font]

Lowell SSC Guru Points: 323518 More actions · Answer 2

sometimes it's easier to change something that exists, than to create something from scratch.

I would suggest just creating a default maintenance plan using Enterprise Manager to make a backup plan and a maintenance plan is really easy to do...the typical 5 "next" buttons. do that immediately.(enterprose library..wizard button on toolbar, find bot "Backup Wizard" and "Database Maintenance Plan Wizard"

do it for all databases, including master(it might save you some day)

Once that is in place, at least you have a plan, and can then consider making adjustments.

full backups once a day every day would at least be a solid foundation. add in a maintenance plan for reindexing and such, and you've got a resonable foundation to go forward from.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!