02-18-2019 06:58 AM
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.
Solved! Go to Solution.
02-19-2019 12:18 AM
I believe this is a question for Microsoft.
Have a look at this doc (Move TDE protected database without NBU):
Then there is this blog regarding SQL backup and restore:
Restore after disabling TDE:
02-18-2019 09:01 AM
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
02-19-2019 12:04 AM
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
02-19-2019 12:18 AM
I believe this is a question for Microsoft.
Have a look at this doc (Move TDE protected database without NBU):
Then there is this blog regarding SQL backup and restore:
Restore after disabling TDE: