The main objective is to get a backup made consistently....

Red Gate's SQL Virtual Restore[/url] is another option you could consider. It allows you to mount a database from a backup file, without needing to actually perform a restore,...

I would guess that you have a flaky connection to your remote share, hence why SQL Server was unable to write the backup data successfully.

Using SQL Virtual Restore[/url] may be another option if space is limited. Basically, you can mount live databases from backup sets without actually having to restore the original data...

I believe the OP knew that he would need to provide a network share path in order to save the backups to the remote share. In his original post,...

You can back up to network shares, but the SQL Server service startup account needs to have read/write rights to that network share.

You could set up a Profiler trace and filter on all commands containing the BACKUP command. ...

What's the value of the 'log_reuse_wait_desc' column in the sys.databases table for that database?

Thanks.

With regards to SQL Server 2008 Express, see here.

There is no explicit limitation on the no. of simultaneous users, but you would need to work within the limitations of 1...

Ok, you're obviously not using SQL Backup[/url], but the native SQL Server BACKUP command.

It looks like there are multiple instances of the job all trying to back up the database...

Could you please post the contents of the SQL Backup log for that backup process? The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red...

When you say 'SQL Backup', do you mean the product by Red Gate Software, or SQL Server backups in general?

Thanks.

Here's an interesting article[/url] on predicting the size of a differential backup.

Try some of the timing suggestions in this link: Speeding up backups. Should tell you if the problem lies with reading or writing the backup data (or both).

Grant Fritchey (12/30/2010)

---

Just so I can learn better, do you have any white papers or deeper documentation into precisely that issue available? I've got a little best-practice article I want...