DB Backup Size Limit

[finestrella]

Hello,

It appears that there is a maximum database size for backups using Sql2008CreateBackup. Is that the case? We've increased our maximum DB size from 500 to 600 megs, and (maybe once we passed the 500MB??), we're getting an API Exception from our periodic backup job:

DiscountASP.net.UserErrorException: Database 'OURDBNAME' exceeds maximum backup size. Please contact support to request a backup.

There's enough storage space available to perform the backup, as it works OK when performing it "manually" via the Control Panel web interface.

Thanks!

[finestrella]

Went through support and they confirmed that this is in fact a limitation, and there are currently no plans to change it. SQL Server Databases larger than 500MB cannot be backed up via the API.

Oh well... guess we're stuck doing our backups manually then.

[wisemx]

...Isn't there a way you can create a SQL script that will run and pump data to a temp table that is used by the API for a backup?
I'm taking for granted of course that you don't need the entire DB backed-up at once.

[finestrella]

We are in fact performing a daily full backup. My understanding is that the API (SQL2008CreateBackup) cannot backup individual tables, only the complete DB.

Interesting idea, though; you mean create a different (schema mirror) Database, pump data there, and then back that up automatically? We would also need logic for restores, as these would be incremental.

[wisemx]

...Correct. I used to create worldwide backups for SIEMENS like this.
For example, PeopleSoft had huge DBes but we only needed a chunk.
So before the backup I ran a custom script that pulled what we needed into an empty temp DB, which was then backed-up.
Once the BU was verified the temp DB was cleared, or it was cleared before the start next time.

[bruce]

Note that you can still use the Control Panel to backup your database. The API uses a synchronize method to backup database which can have problem when database is too large.

The control panel, on the other hand, uses an async method to handle the task.

[AnEpic]

I am getting similar message - database is SMALLER than it was 2 months ago! (always been under 100mb)

Only getting issues through backing up through API. Backing through the control panel works.