Tuesday, April 12, 2011 4:39 PM
the server is installed with windows 2008 R2 standard 64bit on the c drive and the 'd' drive is software raid to raid5 and the sql server is installed on to the 'D' drive. when i try to backup the database to tape (that is connected to the server (SCSI connection)). the tape option is greyed out. could you please advice..
Tuesday, April 12, 2011 4:47 PMModerator
Tuesday, April 12, 2011 5:17 PM
Yes...in the device manager i could see the tape device and it shows the device is running properly..but when i try to add to add the tape through server objects-->backup device through sql the tape option is greyed out..
Tuesday, April 12, 2011 11:26 PM
Can you run a TSQL command to see if this works fine
BACKUP DATABASE db_name TO TAPE = '\\.\Tape_name' WITH FORMAT
This will help us to narrow down the problem and see whether it relates to SQL server or SSMS tool's
Wednesday, April 13, 2011 1:55 PM
The problem is i cannot add the tape to the sql backup device...and when i run the query i get the following error message:
Msg 3201, Level 16, State 5, Line 1
Cannot open backup device '\\.\Tape0'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Thursday, April 14, 2011 6:37 AMModeratorHi Anivava,
It seems that the service account for SQL Server doesn’t have permissions on where you try to produce the backup file. Grant permissions for the current account to control the drive or folder on its Security Properties.
• For Windows Authentication, add the current windows account and assigning full control.
• For SQL Server Authentication, add the SQLServerMSSQLUser$machine_name$MSSQLSERVER user group and assigning full control.
Thursday, April 14, 2011 7:02 PM
I log in as administrator (full control) in windows authentication mode..
Friday, April 15, 2011 6:47 AMModerator
Monday, April 18, 2011 1:14 PM
Please tell me how to solve this...
Monday, April 18, 2011 2:23 PM
The SQL Server Database Engine Service Account (Service account for MSSQLServer) should have read and write permission on the folder, where you are trying to create the Backup, in your case, the tape drive. Give Read & Write permission for SQL Server Service account on the tape drive.
Hope, this may help.
SKG: Please Marked as Answered, if it resolves your issue.
Wednesday, January 18, 2012 12:15 PM
How to Give Read & Write permission for SQL Server Service account on the tape drive ?
I have the same issue
thanks in advance
- Edited by MohamedAnis Wednesday, January 18, 2012 12:15 PM
Wednesday, February 01, 2012 2:43 PMplease let me know how to do this.