Publisher's Synopsis
Answers the first question in detail, with the expectation that this will prevent the second question from being asked. SQL Server consultant Jeffrey Garbus focuses on designing and implementing a preventive maintenance regimen in order to ensure ongoing reliability and performance of your SQL Server. The book begins by introducing basic concepts, then progresses to advanced topics such as configuring SQL Server for optimum performance, monitoring activity on the server, and formulating a disaster recovery plan. Topics covered in the appendixes include troubleshooting tips, using wizards to automate tasks, and replicating data.