NuRoN Consulting, INC.

File Download
Donate for FREE Code
SQL Tools
- Databases
- Template Scripts

Blog > SQL Tools > Template Scripts > Restore Master Key > Restore Master Key

Template Script: Restore Master Key\Restore Master Key.sql

-- http://msdn.microsoft.com/en-us/library/ms186336.aspx

RESTORE MASTER KEY FROM FILE = 'path_to_file' -- path relative to SQL instance
DECRYPTION BY PASSWORD = 'm@5t3Rk3y'
ENCRYPTION BY PASSWORD = 'password'

Description for Template Script: Restore Master Key\Restore Master Key.sql

Todo