Solved

SQL Backup Question

Posted on 2013-01-10
5
155 Views
Last Modified: 2013-01-16
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
Comment
Question by:Bransby-IT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 1

Assisted Solution

by:jacreji
jacreji earned 100 total points
ID: 38763842
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
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 400 total points
ID: 38763877
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
 
LVL 3

Author Comment

by:Bransby-IT
ID: 38764039
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
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 38764348
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
 
LVL 3

Author Closing Comment

by:Bransby-IT
ID: 38783574
Thanks team
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question