?
Solved

SQL Backup Question

Posted on 2013-01-10
5
Medium Priority
?
157 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 400 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 1600 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

765 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