Backup

Hi,
I've received this message when trying to backup the database to a tape.
'"he file on device '\\.\Tape0' is not a valid Microsoft Tape Format backup
set. BACKUP DATABASE is terminating adnormally."
What is the cause & how can it be solve? Please help. Thanks
SayAre you using the tapes for anything other than backing up
from SQL Server to tape? You can get this error when the
tapes have backups other than SQL Server backups on them.
If you are storing other windows backups on the tape, you
would need to do native SQL backups to disk and then backup
these backup files on disk to tape.
-Sue
On Mon, 18 Apr 2005 00:55:01 -0700, Say
<Say@.discussions.microsoft.com> wrote:

>Hi,
> I've received this message when trying to backup the database to a tape.
>'"he file on device '\\.\Tape0' is not a valid Microsoft Tape Format backup
>set. BACKUP DATABASE is terminating adnormally."
> What is the cause & how can it be solve? Please help. Thanks
>Say

Backup

Hi,
I've received this message when trying to backup the database to a tape.
'"he file on device '\\.\Tape0' is not a valid Microsoft Tape Format backup
set. BACKUP DATABASE is terminating adnormally."
What is the cause & how can it be solve? Please help. Thanks
Say
Are you using the tapes for anything other than backing up
from SQL Server to tape? You can get this error when the
tapes have backups other than SQL Server backups on them.
If you are storing other windows backups on the tape, you
would need to do native SQL backups to disk and then backup
these backup files on disk to tape.
-Sue
On Mon, 18 Apr 2005 00:55:01 -0700, Say
<Say@.discussions.microsoft.com> wrote:

>Hi,
> I've received this message when trying to backup the database to a tape.
>'"he file on device '\\.\Tape0' is not a valid Microsoft Tape Format backup
>set. BACKUP DATABASE is terminating adnormally."
> What is the cause & how can it be solve? Please help. Thanks
>Say

Backup

Hi,
I've received this message when trying to backup the database to a tape.
'"he file on device '\\.\Tape0' is not a valid Microsoft Tape Format backup
set. BACKUP DATABASE is terminating adnormally."
What is the cause & how can it be solve? Please help. Thanks
SayAre you using the tapes for anything other than backing up
from SQL Server to tape? You can get this error when the
tapes have backups other than SQL Server backups on them.
If you are storing other windows backups on the tape, you
would need to do native SQL backups to disk and then backup
these backup files on disk to tape.
-Sue
On Mon, 18 Apr 2005 00:55:01 -0700, Say
<Say@.discussions.microsoft.com> wrote:
>Hi,
> I've received this message when trying to backup the database to a tape.
>'"he file on device '\\.\Tape0' is not a valid Microsoft Tape Format backup
>set. BACKUP DATABASE is terminating adnormally."
> What is the cause & how can it be solve? Please help. Thanks
>Say

Backing up to mirror

I am looking at this syntax from Books-Online:
BACKUP DATABASE AdventureWorks
TO TAPE = '\\.\tape0'
MIRROR TO TAPE = '\\.\tape1'
MIRROR TO TAPE = '\\.\tape2'
MIRROR TO TAPE = '\\.\tape3'
WITH
FORMAT,
MEDIANAME = 'AdventureWorksSet0'
1. Am I right in thinking that this has nothing to do with database
mirroring? I've never done that either, but I've read that the mirror is
updated through transactions transferred from the database to the mirror, and
also that there can be only one mirror.
2. Can the MIRROR option be set up from the backup dialog screen, or only
through code like the above?> 1. Am I right in thinking that this has nothing to do with database
> mirroring?
Correct. The word mirror is overloaded and user in several independent contexts (just like
"snapshot", "schema" and "meta-data").
> 2. Can the MIRROR option be set up from the backup dialog screen, or only
> through code like the above?
I haven't found a way to do this through the GUI, so TSQL is the way to go.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:EFCC37AA-8F13-49D8-BB54-5C47E2DFA21F@.microsoft.com...
>I am looking at this syntax from Books-Online:
> BACKUP DATABASE AdventureWorks
> TO TAPE = '\\.\tape0'
> MIRROR TO TAPE = '\\.\tape1'
> MIRROR TO TAPE = '\\.\tape2'
> MIRROR TO TAPE = '\\.\tape3'
> WITH
> FORMAT,
> MEDIANAME = 'AdventureWorksSet0'
> 1. Am I right in thinking that this has nothing to do with database
> mirroring? I've never done that either, but I've read that the mirror is
> updated through transactions transferred from the database to the mirror, and
> also that there can be only one mirror.
> 2. Can the MIRROR option be set up from the backup dialog screen, or only
> through code like the above?