Monday, March 19, 2012

Has anyone had timeout problems when backup up an Express database?

I was always able to backup until my data went over approximately 500 meg. Now when the backup is running it times out. I checked the Express settings and all timeout parameters are set at 60 seconds. But the backup times out at about 30 seconds.

The message is

TITLE: Microsoft SQL Server Management Studio Express

Backup failed for Server 'MYEXP\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476


ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476


Hey Expressman,

Since you're doing your backup using Management Studio Express, I'm going to move this thread over to the Tools forum where SSMSE questions are answered.

- Mike

No comments:

Post a Comment