The only one I can really give you recommendations on, but probably the most
important, is the SQL stuff. To create a backup strategy for this you need
to think about how important the databases are, and how often they get
updated. Your system DB's, i.e. temp, model, msdb, probably only need to be
backed up once, then whenever you make changes to them, which is probably
not that often. Your master DB you should probably back up daily. As far
as your other databases go, if they are used often, and data is added and
deleted regularly, i.e. several times per hour/minute, then you should think
about doing a full or differential nightly backup, and then hourly
transaction log backups. The choice between the full or differential
nightly depends on how quick you need to restore in the event of a DB
failure, and the size of your DB. If you need to get back up and running
VERY quickly and your DB is not that large, then you should do a full, if
you have a couple of hours or your DB is very large, then you could think
about doing a differential. If you data is only changed a couple of times a
day or less, then just think about doing a full/differential nightly, again
depending on the recovery time allowed/size of DB.
HTH,
Thomas.
-----Original Message-----
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 3:20 AM
To: CF-Server
Subject: backup stratergies..
Hi does any one have a good strategy or can recommend some tools/resources
on backing up:
The backing up system here is really sloppy and we'd like to formulate some
system of backing up all of the following:
win2k configuration,
IIS 5 settings,
SQL server database and data,
coldfusion administrator settings,
I realise this is a potentially broad topic but any pointers, tips etc would
be greatly appreciated - thanks.
(sorry about the cross post)
Kola Oyedeji
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
