Backup/Restore failures in SQL 2014 failover cluster

NCstyleNCstyle Posts: 9
edited January 22, 2016 4:54AM in SQL Backup Previous Versions
This is an FYI for those using SQL Backup and implementing SQL 2014 Failover Clusters. If you use the new Cluster Shared Volumes feature in Windows 2012 R2 for your storage instead of the old-style clustered disks, you will receive permission errors when trying to use SQL Backup or the native SQL Server backup/restore. Messages in SQL Backup will look like this:

Error 890: RESTORE DATABASE permission denied for database: (DBNameHere)
SQL error 15404: Could not obtain information about Windows NT group/user 'domainuser', error code 0x5.

The solution is to apply SQL 2014 SP1 CU4 or later. Here is all the version info:

SQL Backup: 7.7.0.18
SQL Server: 2014 SP1
OS: Windows 2012 R2
Configuration: SQL Failover Cluster using Cluster Shared Volumes (CSV) instead of clustered disks
Fix: Apply SQL 2014 SP1 CU4 or later

Comments

  • Hi NCstyle,

    Thanks for posting in the Redgate forums.

    Hopefully other customers in the same situation find this useful.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.