Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  backups started failing recently

Author  Topic  bdutton Starting Member 2 Posts Posted - 2004-06-02 : 09:52:40 I have the following script running in the job scheduler: backup database PLAID to disk= 'G:\MSSQL\BACKUP\PLAID-DAL002_01.BAK', disk= 'G:\MSSQL\BACKUP\PLAID-DAL002_02.BAK', disk= 'G:\MSSQL\BACKUP\PLAID-DAL002_03.BAK', disk= 'G:\MSSQL\BACKUP\PLAID-DAL002_04.BAK', disk= 'G:\MSSQL\BACKUP\PLAID-DAL002_05.BAK' This script has been runnign successfully for many weeks on 4 different servers yet recently they started failign with the following error message: The media set for database 'PLAID' has 5 family members but only 1 are provided. All members must be provided. [SQLSTATE 42000] (Error 3132) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed. EDIT: If I change the G: to F: it works. EDIT2: I found my problem. There was a file from a previous backup still there. My process deletes then kicks off the backup. Somehow, the 5th file was missed in the delete.