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. >