Solved

Create Backup Device on SQL 2005

Posted on 2008-06-16
4
2,487 Views
Last Modified: 2008-06-18
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.
0
Comment
Question by:AXISHK
  • 2
  • 2
4 Comments
 

Author Comment

by:AXISHK
ID: 21799322
One more add to the question, I have HP LTO Ultirum 3 tape drive attached to the backup system.

Tks
0
 
LVL 3

Expert Comment

by:amritgill
ID: 21799722
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
 

Author Comment

by:AXISHK
ID: 21799995
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
 
LVL 3

Accepted Solution

by:
amritgill earned 500 total points
ID: 21800048
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

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to check data in sql table 11 47
format nvarchar field as mm/dd/yyyy 4 68
Query to Add Late Tolerance 10 67
View SQL 2005 Job package 16 40
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now