SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Backup MASTER KEY Msg 15240
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

JamesBird
Starting Member

Australia
2 Posts

Posted - 01/21/2014 :  19:23:15  Show Profile  Reply with Quote
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

Australia
2 Posts

Posted - 01/21/2014 :  19:46:27  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000