Ошибка backup failed for server

Can any body tel me how to overcome this error when taking a backup in 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 2014PayrollBackup" 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

I just want to take a single backup of my database. But always I have to give two destinations and then when restoring I cant restore the database using a single backup file? Is there anything to configure in SSMS? If any, could you please clearly explain?

EDIT:

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

asked Aug 1, 2014 at 17:58

The backup statement is using the NOINIT clause. This causes each successive backup to append to the existing backup file. You are attempting to backup to one media set (one file), but it appears the existing backup you are attempting to append to consisted of two media sets (two files).

For a quick turnaround, specify a new filename:
BACKUP DATABASE [Payroll] TO DISK = N'D:Project 2014<insert new filename>' WITH ...

answered Aug 1, 2014 at 18:27

I also received the error. In my case, I wanted to specify a different location to which the file should be backed up to. But what it was trying to do, was to now split the backup to both files in both locations — thus the part of the error:

is formatted to support 1 media families, but 2 media families are expected according to the backup device specification. (Microsoft.SqlServer.Smo)

So, remove one of the destinations specified in the ‘Destination’ section of the Back Up Database wizard. It should only have one destination if it only backed up to one file previously.

I got the same error with my project, so I did a couple of simple things:

1. Copied my old MyDB.bak file from the default backup path, say C:Program FilesMicrosoft SQL ServerMSSQL14.SQLEXPRESSMSSQLBackup
2. Removed it from there
3. Backed up new version of DB to the same path. (It now succeeded)
4. Copied the newly created backup to desired place.

I received this message when I was adding a database to Always On Group and log backup failed with this message:

‘The Backup cannot be performed because the existing media set is formatted with an incompatible version’

Problem: I was using the same backup shared folder as I was using two servers with multiple instances. Database was promoted from SQL Server 2008 R2 to SQL Server 2016. I did not delete the old 2008 R2 backups from that shared folder.

Solution: Try and clear out the old version backups and try again. It worked for me.

answered Jan 12, 2018 at 10:26

I’m trying to do a simple backup to an external disk and getting this error:

Backup failed for Server ‘Server-name’

Additional information:

System.Data.SqlClient.SqlError: The media loaded on «C:Program FilesMicrosoft SQL..» is formatted to tsupport 1 media families, but 2 media families are expected according to the backup device specification.
(Microsoft.SqlServer.Smo)`

Backup type: Full

Why am I getting this error and why is the message pointing to C:Program Files.. if the destination file is an external device?