Backup failed for Server, The media is formatted to support 2 media families Error

If you have overcome the subject error when setting up a backup on Microsoft SQL Server Management Studio; below is a series of steps which will provide you the solution

  • Under Object Explorer, expand the Server Objects tree
  • Under Server Objects; expand Backup Devices
  • If there is backup object list, delete it
  • Create New by right-clicking on Backup Devices
  • In the resulting Window, provide the Device Name and file name as illustrated
  • Create the backup and select the Backup Device as the destination


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s