• State Suggested Answer
  • Locked Locked
  • Replies 8 replies
  • Answers 2 answers
  • Subscribers 13 subscribers
  • Views 14963 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SQL backup failures to network share

MihirP1129
over 6 years ago

Hello,

We recently stood up a new backup enviornment using HP StoreOnce (Deduplication applicance) as the backup target. The issue we're currently running into is when we perform a SQL backup using LiteSpeed (not compressed) to the CIFS share (\\hpeso\SQLBackups) on HP StoreOnce we get the following error:

- test backing up a 14GB database

Msg 61700, Level 16, State 1, Line 46

Backup of database "TestDatabase" failed.

Error saving data to file. Thread: 0

BACKUP DATABASE is terminating abnormally.

A nonrecoverable I/O error occurred on file "VDI_730BE351-F308-4C41-8F

C7-B6434FD61EF6_0:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).

Write on "VDI_730BE351-F308-4C41-8FC7-B6434FD61EF6_0" failed: 4(The system cannot open the file.)

And when it's compressed by LiteSpeed we get a different error writing to the same backup target:

BackupIoRequest::ReportIoError: write failure on backup device 'VDI_9F406D37-986D-4A49-AA3C-844801FE9B6C_7'. Operating system error 4(The system cannot open the file.).

Is there anything I could do on the LiteSpeed configuration side in hopes to resolve this issue?

Any help in resolving this would be greatly appreciated!

Parents
  • 0 over 6 years ago
    Thanks for the response Alexander.

    The SQL server account already has access to the share. I went ahead and changed the permission on the share to allow everyone with full control (to rule out access issues) then ran the backup job again but it failed.

    CPU Seconds: 11.22
    Environment: Intel(R) Xeon(R) CPU E5620 @ 2.40GHz
    CPUs: 4 logical, 4 cores, 4 physical packages.

    Msg 60404, Level 16, State 1, Line 0
    Backup of database "VC" failed.
    Error saving data to file. Thread: 0

    BACKUP DATABASE is terminating abnormally.
    A nonrecoverable I/O error occurred on file "VDI_DF332AF0-703A-41E5-B04E-4C736EC52E4D_0:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
    Write on "VDI_DF332AF0-703A-41E5-B04E-4C736EC52E4D_0" failed: 4(The system cannot open the file.)

    Not a valid LiteSpeed™ for SQL Server® format file (Type is: 1).
    Select a valid LiteSpeed™ for SQL Server® file for this restore operation.

    However, if I do a SQL native backup by going to the database --> tasks --> backup and specify the location \\hpeso\SQLBackups\testdb-full.bak, it works just fine!
Reply
  • 0 over 6 years ago
    Thanks for the response Alexander.

    The SQL server account already has access to the share. I went ahead and changed the permission on the share to allow everyone with full control (to rule out access issues) then ran the backup job again but it failed.

    CPU Seconds: 11.22
    Environment: Intel(R) Xeon(R) CPU E5620 @ 2.40GHz
    CPUs: 4 logical, 4 cores, 4 physical packages.

    Msg 60404, Level 16, State 1, Line 0
    Backup of database "VC" failed.
    Error saving data to file. Thread: 0

    BACKUP DATABASE is terminating abnormally.
    A nonrecoverable I/O error occurred on file "VDI_DF332AF0-703A-41E5-B04E-4C736EC52E4D_0:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
    Write on "VDI_DF332AF0-703A-41E5-B04E-4C736EC52E4D_0" failed: 4(The system cannot open the file.)

    Not a valid LiteSpeed™ for SQL Server® format file (Type is: 1).
    Select a valid LiteSpeed™ for SQL Server® file for this restore operation.

    However, if I do a SQL native backup by going to the database --> tasks --> backup and specify the location \\hpeso\SQLBackups\testdb-full.bak, it works just fine!
Children
No Data