Backup MASTER KEY Msg 15240 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

SQL Server Administration (2012)

Backup MASTER KEY Msg 15240

Author

Topic

JamesBird
Starting Member

2 Posts

Posted - 2014-01-21 : 19:23:15

USE SSISDB;
GO

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'OurPassword1';

BACKUP MASTER KEY TO FILE = 'G:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DBMasterkeyBackups'
ENCRYPTION BY PASSWORD = 'OurPassword1'
GO
Fails with...
Msg 15240, Level 16, State 4, Line 3
Cannot write into file 'G:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DBMasterkeyBackups'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist.

The SQL Server 2012 service account has full access to drive G:
My windows login has full access to drive G:
My windows account is a SYSADMIN.
NTFS permissions for both above accounts ok.

Has to be a bug!

James Bird
Email ; JAMES.BIRD@SA.GOV.AU

JamesBird
Starting Member

2 Posts

Posted - 2014-01-21 : 19:46:27

I found the answer in other forums...
The example on Microsoft's site only pointed to a folder location and thus I was not providing a file name. I provided a file name in the path and it created the backup to the file.

James Bird
Email ; JAMES.BIRD@SA.GOV.AU

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources