Tag Info

New answers tagged

4

You will need to create a master key on the new server - if it does not exit already. USE MASTER; GO if not exists (select 1 from sys.symmetric_keys where name = '##MS_DatabaseMasterKey##') CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Strong_Password'; Then you have to restore your certificate: CREATE CERTIFICATE serverCert FROM FILE = ...


1

1) If we can set up the transactional replication between server A of version 2014 and server B of version 2012. Tried to Google out but could not find the exact documents because may be am looking somewhere wrong. Please suggest if it can be set up? For your replication to work, the PUBLISHER and DISTRIBUTOR should be on same version. The subscriber ...



Top 50 recent answers are included