SQL Transaction Log Backup causing SQL timeout errors

[psperry2]

I work for a Non-Profit Association that sells products online. Our Web-Pages have been up and running using classic ASP with SQL server 2000 as the back end for a number of years. Recently we started receiving Sql Server Timeout errors via email from our web application that occur at times like 10:01am, 8:01.am, always 1 minute after the hour. This coincides with our transaction log backups which occur hourly. The timeout on the Web server is set to one full minute.

Has anyone got some ideas?

 

[mrdenny]

You'll need to take a look at the SQL Server while the backup is runing. You need to see if anything is causing blocking, or if the system is waiting on the disk because the backup is taking to much IO time. You may need to run your backup more often so that the backups are smaller, or redirect the log backups to another drive.

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)

My Blog

 

[psperry2]

I looked at the server logs and the application logs and can't find anything wrong. When I look at the SQL server, what should I look at? Task Manager?

 

[mrdenny]

That's not suprsing. You'll want to run the procedure sp_who2 and use SQL Profiler to see what's 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)

My Blog