Viewing 5 posts - 1 through 6 (of 6 total)
I don't want my server certificates on the other instance that I am trying to restore to. I am trying to ensure that a 3rd party can do a...
March 2, 2009 at 12:07 pm
I verified that I can read text strings within the backup file. When I then try to restore the bak file to another SQL Server instance I get the...
March 2, 2009 at 12:05 pm
Yes. I ran the following and waited until I received 'Unencrypted' in the encryption_state_desc and then ran the backup:
SELECT DB_NAME(e.database_id) DatabaseName,
e.database_id,
e.encryption_state,
CASE e.encryption_state
WHEN 0 THEN 'No database encryption...
March 2, 2009 at 8:12 am
But if data encryption is then turned off and a backup made, the database still cannot be restored. Can a database that has ever been encrypted and is not...
March 2, 2009 at 7:24 am
Viewing 5 posts - 1 through 6 (of 6 total)