Solved

Backup Problem

Posted on 2006-11-27
6
327 Views
Last Modified: 2012-05-05
Hello Experts,

I am trying to backup a db with enterprise manager. I select the destination as disk and 2 locations are shown. I remove one of the locations and run the backup. The following error is displayed:

Microsoft SQL-DMO (ODBC SQLState: 42000)
The media set for database 'pwin171' has 2 family members but only 1 are provided. All members must be provided. BACKUP DATABASE is terminating abnormally.

The location I removed is incorrect. How can this be corrected?

Thanks in advance.


0
Comment
Question by:GJDuquette
  • 2
  • 2
6 Comments
 
LVL 20

Expert Comment

by:Sirees
ID: 18019394
Run "restore filelistonly from <backup_device>" to see what is in the backup device.

0
 

Author Comment

by:GJDuquette
ID: 18019482
The restore from shows D:\dbBackup\pwin171Backup and D:\pwin171. How can I change the backup device?
0
 

Author Comment

by:GJDuquette
ID: 18019921
I found that I needed to "Initialize and label media" with my new location.  Then the backup worked fine.

Please close this issue.
0
 
LVL 20

Expert Comment

by:Sirees
ID: 18020345
Post a question in the Community Support topic and ask for refund.
 
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 18354634
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

746 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now