服务器备份失败,媒体格式化为支持2个媒体系列错误

在SQL Server 2008 Express中进行备份时,任何机构都可以告诉我如何克服此错误吗？

Backup failed for Server '\SQLEXPRESS'.  (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

System.Data.SqlClient.SqlError: The media loaded on "D:\Project 2014\PayrollBackup" is formatted to support 2 media families, but 1 media families are expected according to the backup device specification. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&LinkId=20476

我只想对我的数据库进行一次备份.但总是我必须提供两个目的地,然后在恢复时我无法使用单个备份文件恢复数据库？在SSMS中有什么要配置的吗？如果有的话,请你清楚解释一下吗？

编辑:

BACKUP DATABASE [Payroll] TO  DISK = N'D:\Project 2014\PayrollBackup' WITH NOFORMAT, NOINIT,  NAME = N'Payroll-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

Dave Mason.. 16

备份语句正在使用该NOINIT子句.这会导致每个连续备份附加到现有备份文件.您正在尝试备份到一个媒体集(一个文件),但是您尝试附加的现有备份似乎包含两个媒体集(两个文件).

要快速周转,请指定新文件名: BACKUP DATABASE [Payroll] TO DISK = N'D:\Project 2014\' WITH ...