Advertisements

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

BackupDevice_SQLServer

Advertisements

About Sunil Padmanabhan

An Indian based out of Dubai who started traveling from 2011 and pretty much caught the travel bug. Every year presents itself as an opportunity to visit and explore a new place.

Posted on September 17, 2015, in DB, SQL, SQL Server and tagged . Bookmark the permalink. Leave a comment.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: