Backup Problem for Large Database.

[VikashGohil]

Hello, I am Vikash. I have a large database at a clients place. My Software has a Facility of taking Backups from the software. I am taking Backups programmatically. I use the query, Backup Database <DBName> to Disk=<FilePath>. But due to Large Database Size, it gives a Time-Out error on executing the Query. Can anyone suggest how to take backup of Large Databases Programmatically. Avaiting a reply, Thanks in Advance.

[Lost User]

VikashGohil wrote:

But due to Large Database Size, it gives a Time-Out error on executing the Query.

What about a larger value for the Time-Out[^]?

I are Troll :)

[Jorgen Andersson]

Most larger databases have backup functionality builtin. What database are you using?

[nhzanne]

You should probably check with your dba :). One possibility could be the logs are full, another may be that you are waiting on a lock... Which DBMS are you using? Which version, and what is the SQL error number you are getting?