SQL Backup Question

SQL 2008

I have set the backup of my SQL Database to do the following task

Check Database Integrity
Update Statistics
Clean Up History
Back Up Database (Full)

What does the "Update Ststistics" do? It take 40 Minuites of a 52 minuites task.

I do two backs one at 13:00 and one at 18:00 do I need to do this to the both of them?
LVL 3
Bransby-ITAsked:
Who is Participating?
 
Paul JacksonConnect With a Mentor Software EngineerCommented:
While it is better to keep statistics up to date, I suspect that your database will be set to update statistics automatically as this is the default setting, so you do not need to do it in the backup jobs if this is the case.
You certainly do not need to do it in both, and it would be better to set up a separate job to run in non peak time to update statistics if it is required.
0
 
jacrejiConnect With a Mentor Commented:
SQL Server tries to use statistics to “react intelligently” in its query optimization. For the most part it is better to keep the statistics up-to-date
0
 
Bransby-ITAuthor Commented:
How can I check if the database is already doing this as default.
My finding so far is that there is nothing documentated and may databases being backed up that went of line 4 years ago and any new ones not being backed up.
0
 
Paul JacksonSoftware EngineerCommented:
Right click database in SSMS and select properties, select the options page and you will see the options listed under the Automatic section in the right hand pane.
0
 
Bransby-ITAuthor Commented:
Thanks team
0
All Courses

From novice to tech pro — start learning today.