The download document below serves as a guide to some of the most common SQL Maintenance tasks required to ensure that SQL databases are adequately protected from data loss and that databases perform as expected. This document draws mainly from Microsoft recommendations but also from leaders in the SQL Database Administration field.
This document contains links to Microsoft’s MSDN and Technet libraries as well as other websites. These links may refer to a version of SQL Server that is different from your version. The information contained in these links is relevant across all versions of SQL Server.
Access APS cannot guarantee the continued availability of these web pages.
The implementation and maintenance of SQL Maintenance Tasks is the responsibility of the client and not the Access Group.
Microsoft SQL Server 2008 R2 was used in creating the instructions and screenshots in this document. A different version of SQL Server may mean the instructions and screens may vary slightly. If this is the case, consult Microsoft Books Online for the help files for the specific version of Microsoft SQL Server.
Download and review the SQL Maintenance Tasks and Backups document to set up automated tasks to prevent data loss.
Practice Management: SQL Maintenance Tasks and Backups
The implementation and maintenance of SQL Maintenance Tasks is the responsibility of the client and not the Access Group.
Updated over a month ago