Viewing 5 posts - 241 through 245 (of 245 total)
Can't believe no one has pointed out that is not a good idea to shrink Production DBs.
August 19, 2013 at 7:41 am
Your question is mis-leading BACKUP/RESTORE would indicate that a) you want to back it up and b) you would like to restore.
August 9, 2013 at 9:33 am
Backup as normal, after the cert has been backed up.
Restore using Cert and Private Key T-SQL
Something like this to BACKUP the CERT.
TEST first.
CREATE CERTIFICATE NorthwindCert
FROM FILE = 'C:\NorthwindCert_File.cer' ...
August 9, 2013 at 9:31 am
You need to read up on TDE.
The server A db needs to have the Certificate backed up.
Server B needs needs to be able to restore using the certificate. Copy the...
August 9, 2013 at 9:24 am
Viewing 5 posts - 241 through 245 (of 245 total)