http://www.sqlservercentral.com/Content tagged Backup and Recovery, Performance Tuning and Scaling, SQL Server 7, 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/This article by new contributing member Bob Musser shows you how to reduce the amount of scans that SQL Server Agent does against databases. Not for the faint of heart. http://www.sqlservercentral.com/articles/Administering/squeezingwastedfullscansoutofsqlserveragent/914/2003/02/13http://www.sqlservercentral.com/articles/Administering/squeezingwastedfullscansoutofsqlserveragent/914/This book from Microsoft Press has a lot of good information that will help you do capacity planning and performance tuning. Is it worth buying though? Andy just finishing reading it and writing the review, see what he thinks! http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/reviewofsqlserver2000performancetuning/673/2002/05/03http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/reviewofsqlserver2000performancetuning/673/Differential backups are a new feature in SQL 7 that can speed up your recovery times when restoring from database and transaction log backups. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/dbbackup/192/2001/06/05http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/dbbackup/192/