Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 unable to backup to tape

Author  Topic 

arunsqladmin
Yak Posting Veteran

74 Posts

Posted - 2008-11-18 : 22:22:20
i am trying to take a backup but fails with the following message, i tried to replace the tape with a new one,still no go , please help me

system.data.sqlclient.sqlerror: cannot open backup device 'tapedump1(\\.\tape0)'. operating system error2(the system cannot find the file specified.)(Microsoft.sqlserver.smo)

SimpleSQL
Yak Posting Veteran

85 Posts

Posted - 2008-11-19 : 21:35:50
Can you backup to disk? Also share your backup statement.
Go to Top of Page

arunsqladmin
Yak Posting Veteran

74 Posts

Posted - 2008-11-20 : 03:29:05
i am able to backup to disk, also i am able to take ntbackup at operating system level files to tape, to confirm abt the hardware drivers,

syntax:
backup database <name> to tape='\\.\tape0'

i am using a new tape, still no go
Go to Top of Page
   

- Advertisement -