Monday, March 19, 2012

Back up database

Hi everyone,

I am working in a company where data is changed daily (IT department of a shopping center) where item prices change everyday, the quantity available in stock vary daily,...
What is the scenarios available for the back up on SQL Server 2000 (I am a developer not a database administrator, but I have a task to do which is to make a back up for the critical data) .

could u help me with some links or idea.
I was thinking of doing a full back up one time everyweek and daily I will do a differential backup?
is that the best solution?
Thanks.

The Backup and Restore Wizard is one of the best things in the product, create job schedules for your backups and it will run. I have covered most of your questions in this thread below. If you have more questions post again. Hope this helps.
http://forums.asp.net/1050678/showpost.aspx

No comments:

Post a Comment