<div>
300MB it's a small database. <br />
What's the connection timeout value? You can set it to 0 (zero) so you won't be disconnected by timeout.
</div>


300MB it's a small database.
What's the connection timeout value? You can set it to 0 (zero) so you won't be disconnected by timeout.

<div>
ConnectionTimeout is the to time to wait while trying to establish a connection. &nbsp;You're not having trouble with that, you're problem is the command takes a long time to complete.<br />
<br />

</div>


ConnectionTimeout is the to time to wait while trying to establish a connection.  You're not having trouble with that, you're problem is the command takes a long time to complete.



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

</div>
</div>


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 ? 
Thank you,


SQL Server Large Database Backup Error

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).