Backups taking long time

[zircon06]

Our database is roughtly 75 gb which to take backups in 1 hr 20 m but now it taking roughtly 3 hrs to complete it . Any thoughts how to check bottoleneck what is going wrong?

Thanks in advance

 

[SQLBill]

You aren't giving enough information for us to help.

How are you doing your backups (maintenance plan, scripted job, or vendor product)?

Where are you backing up the database(s) to (drive on the server, network drive, tape, CD, something else)?

Are you running anti-virus?

What is the true size of the database? How much space is used and how much is free/unused space? Has that changed recently?

Are you doing anything else at the same time?

Have you checked the error logs (SQL Server Error logs/Windows Event Viewer logs) for any possible related messages?

-SQLBill



The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[mrdenny]

To follow on Bills questions...

Have you checked perfmon to see what's going on with with the drives?

What else is happening within the database while the backup is running?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com