Backup/Restore failures in SQL 2014 failover cluster

NCstyle

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

Dan B

Hi NCstyle,

Thanks for posting in the Redgate forums.

Hopefully other customers in the same situation find this useful.