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.