Backup Plan

[sujosh]

Could some one tell where I can find a good backup process that I can implement for a 300 gb db? I have a Database maintenenace plan setup but would like to hear your thoughts as to what I should or should not do.

Also how big is a VLDB? When can you call a DB a VLDB?

Thanks

 

[nigelrivett]

>> I have a Database maintenenace plan setup
That's one thing you shouldn't do - better to code the sql yourself so you know what is happening.

Decide on the recovery model which will depend on the business requirements. Use simple unless there is a very good reason not to.

Then just add full and diff backups as the requiements dictate and log backups if not simple. model

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[sujosh]

Thanks Nigel! DO you have any links to your articles where you have already discussed how to use T-SQL in a back up stratergy?

Thanks in advance