ratheesh4sql (3/1/2013)
Hi All,Can u anyone suggest me for best practice maintenance task in sql server 2012.
I am planning to do the following in my Always on server- Production database.
1. Full Backup -- Every day
2. Diff Backup -- Every 4 Hourly
3. Log Backup-- Every One hour.
4.Check database integrity -- Every day
5. Reorganize and update statistics -- Weekly basis
6. Rebuild index -- Every two Weeks
7. sp_delete_backuphistory & sp_purge_jobhistory & Output File Cleanup every Week.
Thanks for you help in advance.
A. Personally I think you are wasting effort with a 4 hour diff. Just use tlog backups. There will only be a max of 23 of them per day and then you switch back to another FULL baseline.
B. Go immediately to Ola.Hallengren.com and get and learn to use his FREE, AWESOME, FULLY DOCUMENTED maintenance suite. Do NOT use maintenance plans for the stuff you mention above!!
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service