Re: Cannot backup to tape

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 08:14:03 -0400

Does the SQL NT login have read/write permissions on the TAPE drive... And
the tape drive must be local ( which appears is the case based on your
reference to it.) 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nag" <anonymous@discussions.microsoft.com> wrote in message
news:6d0f01c475cc$d90f1900$a601280a@phx.gbl...
> Hello all,
> Can some one please help me with this backup error.
> We are runng SQL2000 sp3a.
> We copied our database to a new server (windows 2000
> server to windows server 2003). Everything was ok. No
> errors.
> On the new server when i try to backup to a tape i got
> this error message.
> Microsoft SQL-DMO(ODBC SQLState:42000)
> Cannot open backup device '\\.\Tape0'. Device error or
> device off-line. See the SQL server log for more details.
> BACKUP DATABASE is terminating abnormally.
>
> We tested tape, no problem. In fact we are able use other
> programs to backup to tape. Only SQL server giving error.
> Can someone help me.
> Thanks
> Nag

Relevant Pages

  • Re: Cannot backup to tape
    ... >I support the Professional Association of SQL Server ... >> Can some one please help me with this backup error. ... >> On the new server when i try to backup to a tape i got ...
    (microsoft.public.sqlserver.server)
  • Re: Tape Backup Slows Clustered SQL Server
    ... never back up directly to a tape device. ... tlog) to a disk device and then to a tape. ... I overwrite the full backup files ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: database failure to restore from NT backup
    ... This scenario is a typical case why you should do backup using SQL Server BACKUP command instead of just ... > It seems that they had disk problems, then wanted to restore the database from a backup. ... just to shutting down the services & doing a cold NT backup to tape. ...
    (microsoft.public.sqlserver.server)
  • database failure to restore from NT backup
    ... >One of our customers had a problem with SQL Server 7. ... restore the database from a backup. ... doing a cold NT backup to tape. ... The database was in suspect mode. ...
    (microsoft.public.sqlserver.server)
  • Re: Cannot backup to tape
    ... Windows loginand SQL service startup ... account both have full access to Tape drive. ... >I support the Professional Association of SQL Server ... >> Can some one please help me with this backup error. ...
    (microsoft.public.sqlserver.server)