BOL - Back Up the Service Master Key by Phil Brammer

Closed

as Fixed

Type:	Bug
ID:	766349
Opened:	10/5/2012 12:59:59 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

The BOL page for SQL 2012 - "Back Up the Service Master Key" has incorrect example code.

http://msdn.microsoft.com/en-us/library/aa337561(v=sql.110).aspx

The example code backs up a database master key, not the service master key.

See previous version BOL pages for correct code: http://msdn.microsoft.com/en-us/library/aa337561(v=sql.105).aspx

Details (expand)

English

SQL Server 2012 - Enterprise Edition

Documentation

Not Applicable

View the BOL page: http://msdn.microsoft.com/en-us/library/aa337561(v=sql.110).aspx

Observe the code is incorrect.

-- Creates a backup of the "AdventureWorks2012" master key.
-- Because this master key is not encrypted by the service master key, a password must be specified when it is opened.
USE AdventureWorks2012;
GO
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'sfj5300osdVdgwdfkli7';
BACKUP MASTER KEY TO FILE = 'c:\temp\exportedmasterkey'
ENCRYPTION BY PASSWORD = 'sd092735kjn$&adsg';
GO

BACKUP SERVICE MASTER KEY TO FILE = '<complete path and filename>' ENCRYPTION BY PASSWORD = '<password>' ; GO

0 attachments

Posted by Microsoft on 10/10/2012 at 8:24 AM

It looks like an editor tried to help but copied in code from the wrong location. I have corrected the example. Thank you for reporting this. This will show up online in a couple of weeks. Rick Byham.

Microsoft