rkrpat (1/31/2015)
Hi All,I would like to know is it a good practice to have a SQL Server Agent Job for each database with below Steps
1. DBCC Checkdb
2. SP_Updatestats
3. Backup_Database_full
4. DBCC Shrink Database
5. Copy Backup to Other Server
Please advise if the sequence above creates any problem in longterm to DB.
This is a weekly job which occurs during non peak hours.
A) NEVER, EVER, EVER shrink a database (unless something EXCEPTIONAL happens, and even then you best do some other things or you are totally hosed by the fragmentation it creates)!!!!!
B) Do NOT use maintenance plans for SQL Server maintenance. Go to Ola.Hallengren.com and use his free, awesome, documented maintenance suite.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service