Create Backup Device on SQL 2005

Any idea how to create a backup device on SQL 2005 so that all the backup will be stored on the tape ?

When I start the SQL Server Management Studio --> Server Objects --> Backup Devices, right click and select "New BackupDevice ..." . The otpion "Tape" is grayed. Is this the way that I create the backup device to the tape ??

Many thanks.
AXISHKAsked:
Who is Participating?
 
amritgillCommented:
You may want to check startup account of SQL instance has the proper
permission of the tape device. Please change the startup account to local
system to test the situation.
0
 
AXISHKAuthor Commented:
One more add to the question, I have HP LTO Ultirum 3 tape drive attached to the backup system.

Tks
0
 
amritgillCommented:
sp_addumpdevice [ @devtype = ] 'device_type'
        , [ @logicalname = ] 'logical_name'
        , [ @physicalname = ] 'physical_name'
      [ , { [ @cntrltype = ] controller_type |
          [ @devstatus = ] 'device_status' }
      ]

this a the syntax for adding a device to an instance in sql server..
u can also refere to the msdn lib on the following link
http://msdn.microsoft.com/en-us/library/ms188409.aspx
0
 
AXISHKAuthor Commented:
Thanks.

After create the device and access it through SQL Management Studio, it pop up with the following error :

System.Data.SqlClient.SqlError: Cannot open backup device 'sysname(\\.\Tape0)'. Operating system error 32 (The process cannot access the file because it is being used by another process).

Here is the SQL Statement :
sp_addumpdevice @devtype = 'tape', @logicalname='sysname', @physicalname ='\\.\TAPE0'

Any idea ??

Tks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.