I have a backup stored procedure gratiously provided by a member of this great establishment. It runs fine from the server but fails occasionally when run from my vb6 app. It doesn't timeout because it only runs about 20 seconds and the timeout is set for 60 seconds.
The error message simply says: 'Backup Failed'
Any ideas would be appreciated!!!