SQL Server Large Database Backup Error
I have a large MS SQL Server 2000 database which its size is about 300MB.
I have written a C# .NET 2005 code for creating a backup of it, but I receive a "Timeout expired" exception.
I change the Connection Timeout property of the SqlConnection object, but I still receive the same error.
It takes a long time and Hard Disk activity , but no file is created.
But, when I use Microsoft Query Analyzer to execute the BACKUP DATABASE SQL Command, it works with no error(s).
aslan maloom nist che margeshe, Timeout am ke ziad mikoni baz engar na engar !
akhe masalan 3-4 minute am tool mikeshe, hard gher gher mikone, vali filesh create nemishe !
Any solution ?