This project has moved and is read-only. For the latest updates, please go here.

Previous Configure Errorlog Retention Manual Configuration Configure Database Mail Next

Backup Service Master Key

FineBuild can backup the Service Master Key so that a secure copy is maintained.

The Service Master Key is the root of the SQL Encryption hierarchy. It is important that you keep a backup copy of this key or you may be unable to decrypt SQL encrypted objects in the event of corruption of the master database.

Further information about the Service Master Key is at http://technet.microsoft.com/en-us/library/ms189060.aspx.

FineBuild Backup Service Master Key

The Backup Service Master Key processing relates to Process Id 5BA and is controlled by the parameters below:

Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014 SQL2016 SQL2017
SetupSQLServer FULL Yes Yes Yes Yes Yes Yes Yes
SetupSQLServer WORKSTATION Yes Yes Yes Yes Yes Yes Yes
SetupSQLServer CLIENT N/A N/A N/A N/A N/A N/A N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter ConfigSQLServer can also be used.

FineBuild will use the same password as specified for the sa account via the /SAPWD: parameter. The password should be recorded in the DBA Password Store.
Top

Manual Backup Service Master Key

The following steps show what you would have to do for manual backup Service Master Key processing. FineBuild does all of this work for you automatically.

1) Using SQL Server Management Studio, run the following query to back up the Service Master Key, using the backup location specified for your server:
BACKUP SERVICE MASTER KEY TO 
FILE='I:\SQLFiles\MSSQL.MSSQLSERVER.BACKUP\SystemDB Copy\PDGB01SQLC07\ServiceMasterKey.snk' ENCRYPTION BY PASSWORD='password'

Copyright FineBuild Team © 2012 - 2017. License and Acknowledgements
Previous Configure Errorlog Retention Top Configure Database Mail Next

Last edited Jan 6 at 4:01 PM by EdVassie, version 5