SharePoint Backup During Midnight is not Recommended

In this blog you will learn SharePoint Backup During Midnight is not Recommended.

SharePoint site collection backup or SQL database backup for SharePoint databases are not recommended to schedule at midnight as it causes skipping of database statistics update.

Microsoft SharePoint is scheduled to run database statistics update (proc_updatestatistics) for every database at midnight.

When we run database backup either full or incremental, it enables skipping for statistics update.
When you check with below query, it would give you the result as updating statistics but it would not actually do.

EXECUTE sp_msforeachdb
'USE [?];
IF DB_NAME() NOT IN(''master'',''msdb'',''tempdb'',''model'')
   begin
        SELECT  ''CHECKING STATS FOR '' + DB_NAME() AS ''DATABASE NAME''
        SELECT   OBJECT_NAME(A.OBJECT_ID) AS ''TABLE NAME''
               , A.NAME AS ''INDEX NAME''
               , STATS_DATE(A.OBJECT_ID,A.INDEX_ID) AS ''STATS LAST UPDATED''
          FROM   SYS.INDEXES A
          JOIN   SYS.OBJECTS B
            ON   B.OBJECT_ID = A.OBJECT_ID
         WHERE   B.IS_MS_SHIPPED = 0
         ORDER   BY OBJECT_NAME(A.OBJECT_ID),A.INDEX_ID
     end'

To overcome this issue, create a SQL agent job that runs at least daily and runs the following script.

EXECUTE sp_msforeachdb
'USE [?];
IF DB_NAME() NOT IN(''master'',''msdb'',''tempdb'',''model'')
     begin
          print ''updating statistics in database  ==> '' + db_name()
          if exists (select 1 from sys.objects where name = ''proc_updatestatistics'')
             begin
                  print ''updating statistics via proc_updatestatistics''
                  exec proc_updatestatistics
             end
         else
             begin
                  print ''updating statistics via sp_updatestats''
                  exec sp_updatestats
             end
    end'

To repair the same with out of box features at SharePoint Central Admin: 

1. Verify that the user account that is performing this procedure is a member of the Farm Administrators group.
   
   
2. On the Central Administration Home page, click Monitoring.
   
   
3. On the Monitoring page, in the Health Analyzer section, click Review rule definitions.
   
   
4. On the Health Analyzer Rule Definitions – All Rules page, in the Category: Performance section, click the name of the rule.
   
   
5. In the Health Analyzer Rule Definitions dialog box, click Edit Item.
   
   
6. Select the Repair Automatically check box, and then click Save.