Skip to Content
avatar image
Former Member

Unable to take Backup to tape MS-SQL

Hi Experts,

We are trying to take our production server backup to tape but getting some errors. I checked with our Hardware team they were telling that the tape drive is ok and it compatible with the Hardware and Operating System. We are facing this issue after migration(HW change G8 Server) and upgrade of SAP System to EHP7. So they are suspecting that the issue is with the SQL Server or with the SAP.

OS : Windows Server 2012

DB : SQL Server 2008 R2

SAP : EHP 7 SPS 5(BASIS 741 07)

We have attached the error logs generated while taking the backup through DBACOCKPIT. Executed as user: prd. Write on "\\.\tape0" failed: 1117(The request could not be performed because of an I/O device error.)

Please help us to solve the issue. Do we need any other configuration for tape backups?

Thanks,

Krishna G.

Error.txt.zip (1.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 29, 2015 at 03:56 PM

    Hello,

    Have you tried to create a new backup device in you SQLServer instance pointing to this tape device ( ie not using the default R3DUMPx devices provided afetr installation ) ?

    You can do it using the SQLServer management studio.

    And then try to take the backup from here.

    Best regards,

    Steve.

    Add comment
    10|10000 characters needed characters exceeded