SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Backup Times Abnormal
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pdset
Constraint Violating Yak Guru

296 Posts

Posted - 02/16/2014 :  18:14:35  Show Profile  Reply with Quote
We are running 2- instances where one being 2005 and other 2008 R2 and we run Full Backups every night and the time slot is recorded consistent.

But on otherday it has consumed more time around 30- 45 Minutes more and I have investigated through Errorlog but have no entry into that.

if the time has increased along with the DB size then it is normal, but only on particular days it is recorded with higher time being consumed for the overall backup.

There is no significant increase in the Data file size of any database picked up for the backup, but this is occurring with more time only on selected days where there is no other activity registered.

Is there any way that I can monitor (if not from TRACE)what could cause the Backup time being increased only for those days which are more (otherwise the following day the backup times would be normal recording).

Please advise and thanks.

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1908 Posts

Posted - 02/17/2014 :  01:49:51  Show Profile  Visit jackv's Homepage  Reply with Quote
Are you backing up to tape or disk?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

pdset
Constraint Violating Yak Guru

296 Posts

Posted - 02/17/2014 :  23:12:56  Show Profile  Reply with Quote
Disk Only not to Tape.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1908 Posts

Posted - 02/18/2014 :  01:47:03  Show Profile  Visit jackv's Homepage  Reply with Quote
Check the write diskIO of the target disk. Do you have any benchmarks which allows you to compare?
Another troubleshooting method is to use some trace flags that will give you a more granular read out of what's occuring. To enable specific traces read : http://www.sqlserver-dba.com/2011/05/slow-sql-server-backup-and-restore-with-dbcc-traceon-3004-3605-1.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000