Restore encrypted SQL database on another server

Hi folks!

Recently we applied TDE (Transparent Data Encryption) on some of our SQL databases on an SQL server. Netbackup policies keep working troublefree both for Full and Incremental Backups.

Now, we need to perform a restore of one of these databases onto another SQL server where the TDE has been applied as well.

I try to make the restore but I got the error with status 2828. Can someone guide me on how to do the restore?

Thank you all in advance for the support.

Marianne
6 years ago
I believe this is a question for Microsoft.

Have a look at this doc (Move TDE protected database without NBU):

https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/move-a-tde-protected-database-to-another-sql-server?view=sql-server-2017

Then there is this blog regarding SQL backup and restore:

https://dataginger.com/2013/10/03/sql-server-restoring-a-tde-encrypted-database-to-a-different-server/

Restore after disabling TDE:

https://www.mssqltips.com/sqlservertip/5637/how-to-restore-a-sql-server-database-to-another-server-after-disabling-tde/

sri_vani
Level 6
6 years ago
Message: Restore failed because the MS-SQL-Server services are down
Explanation: The SQL Server services are down on the system where the NetBackup client and the NetBackup for SQL Server agent are running. So the NetBackup for SQL Server agent cannot connect to the SQL Server.
Recommended Action: Check that the SQL Server instance service is running and that NetBackup processes have permission to access the SQL Server instance service.
Please refer to Netbackup 8.x Microsoft SQL Adminstrative guide for the detailed restore procedure
NetBackup for Microsoft SQL Server Administrator's Guide
- Michal_Mikulik1
  Moderator
  6 years ago
  Hello,
  
  backup/restore database without NetBackup first, e.g. via SQL Management Studio to/from a disk. If it is ok, we can troubleshoot more on the Netbackup side. If it fails, there is some trouble on SQL side.
  
  Regards
  
  Michal
Marianne
Level 6
6 years ago
I believe this is a question for Microsoft.

Have a look at this doc (Move TDE protected database without NBU):

https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/move-a-tde-protected-database-to-another-sql-server?view=sql-server-2017

Then there is this blog regarding SQL backup and restore:

https://dataginger.com/2013/10/03/sql-server-restoring-a-tde-encrypted-database-to-a-different-server/

Restore after disabling TDE:

https://www.mssqltips.com/sqlservertip/5637/how-to-restore-a-sql-server-database-to-another-server-after-disabling-tde/

Forum Discussion

Restore encrypted SQL database on another server

Related Content

Restore previous database encryption key

BEMCLI restoring encrypted VM

Restoring encrypted backups

SQL Database Restore

Restoring encrypted tape at DR site