Microsoft SQL Server DBA Setup Checklist and Recommendations

Install SQL Server Service Packs and Cumulative updates recommended from http://sqlserverupdates.com http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-1-before-the-install/ http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-2-after-the-install/ Keep Long Term Backups at least 1 year (in case of uncaught database corruption) Make sure backups are stored in 3 different physical locations (at least 3 different…

%d bloggers like this: