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.
> >>
> >>
> >>.
> >>
> >.
> >

Backup / restore question

I had a SQL server with some harddrive problems. So, a full backup was made
(manually using Enterprise Manager) and restored in a new machine
successfully using Enterprise Manager (the option Leave Database
Operational. No Additional Transaction Logs Can Be Restored was selected)
If the only backup available is the last Full backup, is it possible to ever
roll back some of the last changes made in the old machine before the Full
Backup ?
Thanks for your help.If all you have is the full backup and the old db is toast then no. You
might be able to do something with third party tool help such as Lumigent
Log Explorer depending on a few factors.
Ray Higdon MCSE, MCDBA, CCNA
--
<--> wrote in message news:%23xrmzy6AEHA.3788@.TK2MSFTNGP10.phx.gbl...
> I had a SQL server with some harddrive problems. So, a full backup was
made
> (manually using Enterprise Manager) and restored in a new machine
> successfully using Enterprise Manager (the option Leave Database
> Operational. No Additional Transaction Logs Can Be Restored was selected)
> If the only backup available is the last Full backup, is it possible to
ever
> roll back some of the last changes made in the old machine before the Full
> Backup ?
> Thanks for your help.
>|||Hi,
You can do this only if your OLD database is in "FULL" recovery model. Below
steps are under the assumption
that database was set to FULL recovery model and the existing database is
still up.
1. In the new server Load the full database backup with NORECOVERY
2. Perform a transaction log backup in Old Server.
3. Copy the TX log backup file to new server
4. Restore the Transaction log WITH RECOVERY , STOPAT='DATE/TIME (refer
Books online)
This will allow you to go back to old data based on the date and time.
Note:
If it is Simple or Bulk_logged recovery model you cant rollback.
POINT-IN-TIME recovery is not supposed in both.
Thanks
Hari
MCDBA
<--> wrote in message news:#xrmzy6AEHA.3788@.TK2MSFTNGP10.phx.gbl...
> I had a SQL server with some harddrive problems. So, a full backup was
made
> (manually using Enterprise Manager) and restored in a new machine
> successfully using Enterprise Manager (the option Leave Database
> Operational. No Additional Transaction Logs Can Be Restored was selected)
> If the only backup available is the last Full backup, is it possible to
ever
> roll back some of the last changes made in the old machine before the Full
> Backup ?
> Thanks for your help.
>|||Hi Hari,
Unfortunately, my old server's HD is no longer is functioning. And all I
have is the last Full Backup. Looks like I may not be able to rollback any
changes...
Can you confirm?
Thanks.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:u4QLTU$AEHA.1456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> You can do this only if your OLD database is in "FULL" recovery model.
Below
> steps are under the assumption
> that database was set to FULL recovery model and the existing database is
> still up.
> 1. In the new server Load the full database backup with NORECOVERY
> 2. Perform a transaction log backup in Old Server.
> 3. Copy the TX log backup file to new server
> 4. Restore the Transaction log WITH RECOVERY , STOPAT='DATE/TIME (refer
> Books online)
> This will allow you to go back to old data based on the date and time.
> Note:
> If it is Simple or Bulk_logged recovery model you cant rollback.
> POINT-IN-TIME recovery is not supposed in both.
> Thanks
> Hari
> MCDBA
>
>
>
> <--> wrote in message news:#xrmzy6AEHA.3788@.TK2MSFTNGP10.phx.gbl...
> made
selected)
> ever
Full
>|||You will not be able to rollback any changes, as Hari pointed out you can
only do point in time recovery by using the tran log
Ray Higdon MCSE, MCDBA, CCNA
--
<--> wrote in message news:O1pe8EFBEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi Hari,
> Unfortunately, my old server's HD is no longer is functioning. And all I
> have is the last Full Backup. Looks like I may not be able to rollback
any
> changes...
> Can you confirm?
> Thanks.
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:u4QLTU$AEHA.1456@.TK2MSFTNGP09.phx.gbl...
> Below
is
was
> selected)
to
> Full
>|||Hi,
If you dont have the old database active, Sorry, you will not be able to
rollback the transactions (POINT-IN-TIME).
Thanks
Hari
MCDBA
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> wrote in message
news:#vsd8lFBEHA.1600@.tk2msftngp13.phx.gbl...
> You will not be able to rollback any changes, as Hari pointed out you can
> only do point in time recovery by using the tran log
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> <--> wrote in message news:O1pe8EFBEHA.2600@.TK2MSFTNGP09.phx.gbl...
> any
> is
(refer
> was
> to
the
>