Solved

SQL Server backup failed - 2 media families expected

Posted on 2012-03-23
3
3,222 Views
Last Modified: 2012-04-14
Our automated backup is failing. When I try to create a backup manually I get the error message below which refers to media families. The SQL server is 2008 standard (version 10.0.2714.0 according to the properites window). It is running in a virtual environment. Automated backup was crteated using the maintenance plan wizard. By manually I mean from the Tasks | Backup option in Management Studio.

This is the message:
 
Sysentem.Data.SqlClient.SqlError: The media loaded on "F:\Backup\Links of London\Links of London_backup_2012_03_23_060000_8777321.trn" is formatted to support 1 media families, but 2 media families are expected according to the backup device specification. (Microsoft.SqlServer.Smo)
0
Comment
Question by:Blim2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

by:Blim2
ID: 37756318
I'd like to update my [problem. I am now getting this error message:

System.Data.SqlClient.SqlError: A nonrecoverable I/O error occurred on file "F:\Backup\Links of London\Links of London_backup_2012_03_23_080000_7357745.trn:" 112(failed to retrieve text for this error. Reason: 15105). (Microsoft.SqlServer.Smo)

I think the previous error may have been due to having two backup file names in the Backup To window. Sorry for the confusion.
0
 

Author Comment

by:Blim2
ID: 37756364
I may have solved this myself. I think the problem was that I did not delete an existing file name from the Backup To window. When I added another of my own I got the 1/2 media families supported error. When I left the filename that was already there, presumably created by the maintenance plan automated backup, I got the I/O error. When I deleted the file name that was already there and added a single, new, name, the backup started and is now still running.

I'm guessing the filename that was already there was for an existing backup file and the I/O error meant that the system could not overwrite this file. Possibly a more meaningful error message would have helped here!

How do I end this Experts-Exchange question. I don't think I should give the points to myself - doesn't seem fair?
0
 

Accepted Solution

by:
EE_AutoDeleter earned 0 total points
ID: 37847191
Because this question has no expert participation and is over 21 days old, it would have been deleted automatically, but you have posted information yourself making this PAQ-worthy.

EE_AutoDeleter
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question