![]() listed below in additional restore steps section. If SSISDB is restored in a SQL Server instance that never had any SSIS catalog, follow steps 6.1. Restore SSISDB database using SQL Server Management Studio or RESTORE DATABASE statement in TSQL. If SSISDB database will be restored in a SQL Server instance that never had any SSIS catalog, follow preparatory steps 4.1. listed below in additional backup steps section. If SSISDB database will be restored in a SQL Server instance that never had SSIS catalog, follow steps 3.1. Backup SSISDB database using SQL Server Management Studio or BACKUP DATABASE statement in TSQL. USE SSISDB BACKUP MASTER KEY TO FILE = 'c:\DMK\SSISDB\key' ENCRYPTION BY PASSWORD = This step is not necessary every time you do backup unless you have lost the file or the password or if you have changed the master key of the SSISDB database. This is done using BACKUP MASTER KEY statement. Backup the master key used for encryption in SSISDB database and protect the backup file using a password.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |