This is using 2 MS SQL 2008 R2 servers. On DB server 1, there is a database that is encrypted. My boss wants us to move this DB to another server - DB server 2. I am clear about the migration - use export and import; but, the problem is since the db is encryption, what should I do to it ? Please show step-by-step.
Thanks in advance.