[AccessD] SQL vs Access

Arthur Fuller fuller.artful at gmail.com
Sat Feb 2 10:45:18 CST 2008


One proviso on this backup discussion. You have two sorts of backups: normal
backups as performed by Windows itself or some replacement product, and
database backups. When setting up the former, you should take care to
exclude the directories housing your database data and log files. Standard
backup won't be able to back these files up while the database is running.
Therefore exclude these directories from standard processes and set up
separate backups from within SQL Server. You can schedule these at as fine a
granularity as you wish (often for critical databases, less often for
occasionally used databases).

And one final note. Backup your system databases frequently, too. They
contain all information about your databases, your jobs, etc. You don't need
to do this every day, but when you make significant changes to an important
database or add jobs, etc., you should backup the system databases when
you're done.

A.



More information about the AccessD mailing list