Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 160
  • Last Modified:

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?
0
Bransby-IT
Asked:
Bransby-IT
  • 2
  • 2
2 Solutions
 
jacrejiCommented:
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
 
Paul JacksonSoftware 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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now