title: Backup failed for Server, The media is formatted to support 2 media families Error
body: <p>Can any body tel me how to overcome this error when taking a backup in SQL Server 2008 Express?</p>
  
  <pre><code>Backup failed for Server '\SQLEXPRESS'.  (Microsoft.SqlServer.SmoExtended)
  
  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&amp;EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&amp;EvtID=Backup+Server&amp;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&amp;ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&amp;LinkId=20476
  </code></pre>
  
  <p>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?</p>
  
  <p><strong>EDIT:</strong></p>
  
  <pre><code>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
  </code></pre>