InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 10:36:02 GMT20http://www.sqlservercentral.com/Forums/Topic1369619-1550-1.aspxFirst, before I do anything on a new server I stand up a pre-determined utility database for DBA related activities. Maintenance jobs that I run but not limiting to are:Clearing out aged backupsCreating backups for new databases that get dropped onto my server ( in my case all DB's are mission critical )Cycle SQL Server Error LogsIndex DefragSmart Re-IndexingAlerting on Extended BlockingAgain, these are my main chunks for maintenance but definitely not limiting what I have listed. You could have more, 50GB is not really that big. Should be able to get a good grasp on it.Thanks,ChrisMon, 08 Oct 2012 12:48:18 GMTCYateshttp://www.sqlservercentral.com/Forums/Topic1369619-1550-1.aspxWith what error? Just saying it's failing isn't much use.Maintenance:Backups, full maybe diff, probably log depending on RPO and RTO requirementsIndex maintenanceIntegrity checksPossible additional statistics maintenanceTest restores to ensure your backups are useful.Alerts configured to tell you before things breakMon, 08 Oct 2012 05:17:27 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1369619-1550-1.aspxThanks for the replyI added Integrity check before backup task in the Maintenance planBut Job/MP is failing as per the scheduledMon, 08 Oct 2012 04:34:26 GMTjamessdbahttp://www.sqlservercentral.com/Forums/Topic1369619-1550-1.aspx50GB is not large. You should be able to handle it just like any other smaller DB.Integrity check is a must for all DBs whether small or large.Mon, 08 Oct 2012 03:45:05 GMTSuresh B.http://www.sqlservercentral.com/Forums/Topic1369619-1550-1.aspxCheck the following factors are considered or not?1.Database size and growth should be mentioned initially.2.Check the unused index and drop the unused index.Then set up your maintenance plan for backup,dbcc reindex,etcMon, 08 Oct 2012 02:32:09 GMTKumarSQLDBAhttp://www.sqlservercentral.com/Forums/Topic1369619-1550-1.aspxHi,My production DB size is now 50Gb its increasing (sqlserver 2008 R2 Enterprice edition) Let me know the DBA task to be done for large database like Integrity check ,fragementation free & performance point .Thanks in advanceSun, 07 Oct 2012 23:28:22 GMTjamessdba