Backup Problem

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.

Who is Participating?
Computer101Connect With a Mentor Commented:
PAQed with points refunded (500)

EE Admin
Run "restore filelistonly from <backup_device>" to see what is in the backup device.

GJDuquetteAuthor Commented:
The restore from shows D:\dbBackup\pwin171Backup and D:\pwin171. How can I change the backup device?
GJDuquetteAuthor Commented:
I found that I needed to "Initialize and label media" with my new location.  Then the backup worked fine.

Please close this issue.
Post a question in the Community Support topic and ask for refund.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.