Backup Error Message

I have SQL Server 2000. I am trying to manually backup a
database but I'm getting an error message.
Here is what I'm trying to do:
1. In the Backup dialogue box I click Add to select the
backup location.
2. The default backup location is already selected. I want
to save the backup to a different location (local hard
disk) so I select the location and enter a file name.
3. When I try to run the backup I get an error message:
Microsoft SQL DMO (ODBC SQLState: 42000) "The volume in
device <filepath> is not part of a multi family media set.
Backup with format can be used to form a new media set.
Backup database is terminating abnormally."
4. The backup fails to run. However, if I select the
default location (which is not what I want) the backup
will run.
How do I backup a database to a location other than the
default?
Thanks in advance.This is not a location issue. You are using a backup file
that was part of striped backup media set. If that backup
file is no longer useful, you can delete that file and the
backup would work.
For backup/restore, personally I would never use the EM
GUI, and I'll use BACKUP/RESTORE statements instead. You
get much better control of what you want to do without any
GUI-related peculiarities getting in the way.
Linchi
>--Original Message--
>I have SQL Server 2000. I am trying to manually backup a
>database but I'm getting an error message.
>Here is what I'm trying to do:
>1. In the Backup dialogue box I click Add to select the
>backup location.
>2. The default backup location is already selected. I
want
>to save the backup to a different location (local hard
>disk) so I select the location and enter a file name.
>3. When I try to run the backup I get an error message:
>Microsoft SQL DMO (ODBC SQLState: 42000) "The volume in
>device <filepath> is not part of a multi family media
set.
>Backup with format can be used to form a new media set.
>Backup database is terminating abnormally."
>4. The backup fails to run. However, if I select the
>default location (which is not what I want) the backup
>will run.
>How do I backup a database to a location other than the
>default?
>Thanks in advance.
>
>.
>|||There is a backup of the database in the default location
but not in the new location. The new backup location is an
empty folder.
>--Original Message--
>This is not a location issue. You are using a backup file
>that was part of striped backup media set. If that backup
>file is no longer useful, you can delete that file and
the
>backup would work.
>For backup/restore, personally I would never use the EM
>GUI, and I'll use BACKUP/RESTORE statements instead. You
>get much better control of what you want to do without
any
>GUI-related peculiarities getting in the way.
>Linchi
>>--Original Message--
>>I have SQL Server 2000. I am trying to manually backup a
>>database but I'm getting an error message.
>>Here is what I'm trying to do:
>>1. In the Backup dialogue box I click Add to select the
>>backup location.
>>2. The default backup location is already selected. I
>want
>>to save the backup to a different location (local hard
>>disk) so I select the location and enter a file name.
>>3. When I try to run the backup I get an error message:
>>Microsoft SQL DMO (ODBC SQLState: 42000) "The volume in
>>device <filepath> is not part of a multi family media
>set.
>>Backup with format can be used to form a new media set.
>>Backup database is terminating abnormally."
>>4. The backup fails to run. However, if I select the
>>default location (which is not what I want) the backup
>>will run.
>>How do I backup a database to a location other than the
>>default?
>>Thanks in advance.
>>
>>.
>.
>|||Really? Then, I'd try the BACKUP DATABASE statement and backup the database
to the exact backup file in the new location as you did with the EM. If the
folder is empty, I doubt you'd get the that error.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Evan" <anonymous@.discussions.microsoft.com> wrote in message
news:037901c39e6e$b0d89140$a501280a@.phx.gbl...
> There is a backup of the database in the default location
> but not in the new location. The new backup location is an
> empty folder.
> >--Original Message--
> >This is not a location issue. You are using a backup file
> >that was part of striped backup media set. If that backup
> >file is no longer useful, you can delete that file and
> the
> >backup would work.
> >
> >For backup/restore, personally I would never use the EM
> >GUI, and I'll use BACKUP/RESTORE statements instead. You
> >get much better control of what you want to do without
> any
> >GUI-related peculiarities getting in the way.
> >
> >Linchi
> >
> >>--Original Message--
> >>I have SQL Server 2000. I am trying to manually backup a
> >>database but I'm getting an error message.
> >>
> >>Here is what I'm trying to do:
> >>1. In the Backup dialogue box I click Add to select the
> >>backup location.
> >>2. The default backup location is already selected. I
> >want
> >>to save the backup to a different location (local hard
> >>disk) so I select the location and enter a file name.
> >>3. When I try to run the backup I get an error message:
> >>Microsoft SQL DMO (ODBC SQLState: 42000) "The volume in
> >>device <filepath> is not part of a multi family media
> >set.
> >>Backup with format can be used to form a new media set.
> >>Backup database is terminating abnormally."
> >>4. The backup fails to run. However, if I select the
> >>default location (which is not what I want) the backup
> >>will run.
> >>
> >>How do I backup a database to a location other than the
> >>default?
> >>
> >>Thanks in advance.
> >>
> >>
> >>.
> >>
> >.
> >