Prev: SQL Server 2008 Extended Events
Next: SQL Server 2005 - Can Not See Server/Service Status in SSMS
From: mirthcyy on 1 Apr 2010 11:49
Hi guys,

I have a sql server 2005 production db server. Before the full backup
job using maintenance plan is only taking around 16 minutes but
recently it's taking around an hour. I'm not sure what's causing the
problem. The databases just get a little bigger so it shouldn't be the
problem. The only thing I can think of is that I set up replication to
another server around that time so I'm wondering if the replication's
causing this problem. Do you have the same problem before? If the
replication is causing it, is there any way to fix the issue? Thanks.


Maintenance plan Log on 2/20:

NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.4035
Report was generated on "XXXX".
Maintenance Plan: Full Backups
Duration: 00:16:04
Status: Succeeded.
Details:
Back Up Database Task (XXXXX)
Backup Database on Local server connection
Databases that have a compatibility level of 70 (SQL Server version
7.0) will be skipped.
Databases: All databases
Type: Full
Append existing
Task start: 2010-02-20T00:00:05.
Task end: 2010-02-20T00:16:06.
Success


Maintenance plan Log on 2/21:

NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.4035
Report was generated on "XXXX".
Maintenance Plan: Full Backups
Duration: 00:52:52
Status: Succeeded.
Details:
Back Up Database Task (XXXXXX)
Backup Database on Local server connection
Databases that have a compatibility level of 70 (SQL Server version
7.0) will be skipped.
Databases: All databases
Type: Full
Append existing
Task start: 2010-02-21T00:00:04.
Task end: 2010-02-21T00:52:54.
Success
From: TheSQLGuru on 2 Apr 2010 11:51
There are many things that could be at play here. Replication is one,
although I don't think it will DIRECTLY affect your backup time.

What WILL affect it is what else is running on the server or backup storage
drives at the same time, or other things that may have been done that will
affect IO throughput on both the sql server and the backup storage location.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"mirthcyy" <mirthcyy(a)gmail.com> wrote in message
news:da36ae36-2fc3-46a1-92a6-1c6108e01cea(a)u22g2000yqf.googlegroups.com...
> Hi guys,
>
> I have a sql server 2005 production db server. Before the full backup
> job using maintenance plan is only taking around 16 minutes but
> recently it's taking around an hour. I'm not sure what's causing the
> problem. The databases just get a little bigger so it shouldn't be the
> problem. The only thing I can think of is that I set up replication to
> another server around that time so I'm wondering if the replication's
> causing this problem. Do you have the same problem before? If the
> replication is causing it, is there any way to fix the issue? Thanks.
>
>
> Maintenance plan Log on 2/20:
>
> NEW COMPONENT OUTPUT
> Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.4035
> Report was generated on "XXXX".
> Maintenance Plan: Full Backups
> Duration: 00:16:04
> Status: Succeeded.
> Details:
> Back Up Database Task (XXXXX)
> Backup Database on Local server connection
> Databases that have a compatibility level of 70 (SQL Server version
> 7.0) will be skipped.
> Databases: All databases
> Type: Full
> Append existing
> Task start: 2010-02-20T00:00:05.
> Task end: 2010-02-20T00:16:06.
> Success
>
>
> Maintenance plan Log on 2/21:
>
> NEW COMPONENT OUTPUT
> Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.4035
> Report was generated on "XXXX".
> Maintenance Plan: Full Backups
> Duration: 00:52:52
> Status: Succeeded.
> Details:
> Back Up Database Task (XXXXXX)
> Backup Database on Local server connection
> Databases that have a compatibility level of 70 (SQL Server version
> 7.0) will be skipped.
> Databases: All databases
> Type: Full
> Append existing
> Task start: 2010-02-21T00:00:04.
> Task end: 2010-02-21T00:52:54.
> Success


 | 
Pages: 1
Prev: SQL Server 2008 Extended Events
Next: SQL Server 2005 - Can Not See Server/Service Status in SSMS