April 2, 2003 at 10:10 am
We are starting a new e-commerce web site. The site would accept paypal payments interactively. We are hosting this web site with a hosting company. Not sure about RAID configuration.
I have been asked to formulate a plan for backup /Restore which would have up to the minute transaction details in case of a crash.
Appreciate all the help that you could offer in formulating this plan.
April 2, 2003 at 10:50 am
That will depend of many things like the expected size of the database, the number of transactiions, etc.
If you think you will have a big db, then you could use a full database backup on weekends for example, differential backups during the week, and log backup every 30 minutes. This is only an example. To design a good backup strategy you must know many things too.
But one thing is for sure, if you want to have the data up to the minute you must use log backups.
Is also a good practice to design a backup strategy and then make some test and be familiar with the restore process, to avoid problems when is needed to execute it without any delays or problems.
April 2, 2003 at 12:04 pm
Thanks for the info. The size of the db will be around 2Gig +/- 10%. Additionally each month I expect around 10% increae in size.
quote:
That will depend of many things like the expected size of the database, the number of transactiions, etc.If you think you will have a big db, then you could use a full database backup on weekends for example, differential backups during the week, and log backup every 30 minutes. This is only an example. To design a good backup strategy you must know many things too.
But one thing is for sure, if you want to have the data up to the minute you must use log backups.
Is also a good practice to design a backup strategy and then make some test and be familiar with the restore process, to avoid problems when is needed to execute it without any delays or problems.
April 2, 2003 at 12:26 pm
Well you should test the time that it takes to execute a full backup, and maybe you could execute one in the middle of the week, or even at night all days. If then the db becomes too big, then you should use differentials backups too, always with the log backups.
It is faster to backup to disk and then save the backup in a tape device.
April 3, 2003 at 7:19 am
Also make sure those backups, full/diff/logs get moved OFF that server ASAP.
I would also look at designing the DB with replication in mind, maybe you won't use it initially, but it could provide very close to up to the minute data. Also a trick we've been experimenting with. Replicate to another server, and back it up there.
KlK, MCSE
KlK
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply