Yesterday, I made a small change to the backup on two databases. It was decided that now that they are being more heavily used we should be running differential log backups throughout the day in addition to the nightly ones.
As you can probably guess by now one database backup works fine and the other does not!
The SQL for both database backups is the same:
MAIN BACKUP - each weekday at 10pm
BACKUP DATABASE [TheDatabase] TO [TheDatabaseBACKUP] WITH INIT ,
NOUNLOAD , NAME = N'TheDatabase backup', NOSKIP,
STATS = 10, NOFORMAT
BACKUP log [TheDatabase] TO [TheDatabaseLOGBACKUP] WITH INIT
DIFFERENTIAL BACKUP - every hour between 7am and 9pm
BACKUP log [TheDatabase] TO [TheDatabaseLOGBACKUP] WITH NOINIT
The error I get is:
Executed as user: SERVER\******. The media set for database 'TheDatabase' has 3 family members but only 1 are provided. All members must be provided. [SQLSTATE 42000] (Error 3132) BACKUP LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.