backup

Question

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..

 

Thanks

George

Answer 1

Can the OS see the tape device ok and is it added as a device to sql server?

---

Ted Krueger Blog on lessthandot.com @onpnt on twitter
Please click the Mark as Answer button if a post solves your problem!

Answer 2

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..

thanks

mohan

Answer 3

Hi Mohan,

Can you run a TSQL command to see if this works fine

BACKUP DATABASE db_name TO TAPE = '\\.\Tape_name' WITH FORMAT
GO

This will help us to narrow down the problem and see whether it relates to SQL server or SSMS tool's

---

Thanks, Leks

Answer 4

Hi

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.

 

Thanks

 

Answer 5

Hi 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.

---

Best Regards,
Stephanie Lv

Answer 6

Hi

 

I log in as administrator (full control) in windows authentication mode..

Thanks

 

Answer 7

It is not who you log in as that matters, it is the account for the SQL Server service.

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 8

Hi

 

Please tell me how to solve this...

Answer 9

Hello Anivava,

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.

Answer 10

 Hello   Sudeepta 
How to  Give Read & Write permission for SQL Server Service account on the tape drive ?

I have the same issue

thanks in advance

Answer 11

please let me know how to do this.