Solved

SQL Backup Question

Posted on 2013-01-10
5
154 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Webservices in T-SQL 3 41
Linked Server Issue with SQL2012 3 33
SQL parsing XML works but want to do it another way 4 19
denied execute as 13 26
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
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.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

756 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