We have an existing SQL server maintenance plan that has 3 steps:
1) Full backup of database A
2) Full backup of database B
3) Full backup of databases C to J (total of 8 databases)
Each of these 3 steps have been changed to use Litespeed, the error occurred while backing up database H (the 6th on the list) on step 3, the error is -1073548784
The error message: Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
The output of the .bak files are pointed to a remote shared directory, with backup creates individual directory for each database.
There is an almost identical plan that has the output .bak files pointed to a local directory, which ran successfully yesterday.
The question is why the backup failed in the middle of the step, which is basically repeatable for each database on the list (of 8 databases) ?
Worst still, Litespeed shows that backup of database H was completed, but when I tried to recover one table from it, Litespeed failed and said the backup is not a full type !
I tried to recover from database G (the one before H), and it was OK.
Checking with our IT support team, there was no network issue at the time the backup failed.
Does anyone have similar issue before ? And how it can be resolved ?