System.Data.SqlClient.SqlException: Timeout Expired.

Hi there,



I am not sure it is the right forum. The Exception is thrown in C# app while saving a few databases. Small databases are being saved OK but this one has 12,934,142KB after the last backup. I am not even sure what the words "last backup" mean in this case. It is possible that is the size of the database from two months ago when first the problem appeared. Since then I've neglected backup being preoccupied with other problems although the database grew.



The backup is executed by this store procedure:

USE [hist_OHLC]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[backUphist_OHLC]
AS
BEGIN
SET NOCOUNT ON;
ALTER DATABASE hist_OHLC SET RECOVERY FULL
BACKUP DATABASE hist_OHLC TO DISK = 'L:SQLServerBackupshist_OHLChist_OHLCFullRM.bak'
BACKUP LOG hist_OHLC TO DISK = 'L:SQLServerBackupshist_OHLChist_OHLCFullRM.log';
END


What can I do about it? What is the rational way of backing up databases of this size?



What is the rational way of maintaining databases of this size in SQLEXPRESS? Shall I perhaps break this database down into fragments?



The tables contain daily records, about 500 per day. I can conceivably create another database every month or so but it will be a hassle.



How can I increase the timeout?



I just repeated the backup. All databases have been saved except this last one--Imoved that backup operation down the chain to be the last one. One database with about 1.5GBytes was saved fine.



I checked the timeout it is 15 sec. One has not control over it in C#. It does not have a Set option.



15

MyHandler caught : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

The backup or restore was aborted.



Thanks.