[AccessD] SQL vs Access

Tina Norris Fields tinanfields at torchlake.com
Sat Feb 2 11:26:30 CST 2008


Thank you to both John and Arthur for these explanations.  I learned 
something useful today.
Tina

Arthur Fuller wrote:
> 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