PRINT is buffered, you can use instead:

RAISERROR ('Message', 1, 1) WITH NOWAIT

You can encrypt

@cleartext

A variable of type nvarchar, char, varchar, binary, varbinary, or nchar containing the cleartext.

Maximum size is 8,000 bytes.

ENCRYPTBYPASSPHRASE return varbinary value

And what are in the first line of Summary.txt file?

Should be:

Overall summary:

Final result: ....

winmansoft (3/14/2013)

---

I wanted to know some details about sql server encryption

a) What is the exact difference between encryptbypassphrase and encrypting using symmetric key which is protected by a password(while...

You can protect keys by using a password.

Check this "SQL Server Encryption To Block DBAs Data Access" http://www.mssqltips.com/sqlservertip/2840/sql-server-encryption-to-block-dbas-data-access/

Maybee, before calling MS look at logs from update? Post logs, maybe someone then will be able to help.

You can start from here http://download.microsoft.com/download/5/B/D/5BD13FFA-5E34-4AE1-9AA0-C6E6951B8FC8/SQL%20Server%202008%20R2%20High%20Availability%20Architecture%20White%20Paper.docx

Like george sibbald said, you have a space in the DB name, options are:

- change the db name

- don't make a subdirectory for this db in maintance plan

Yes, as long as the DB is online, you have enough rights, the certificate is protected by DMK not by a password (which you don't know) you can backup it...

Move a TDE Protected Database to Another SQL Server http://technet.microsoft.com/en-us/library/ff773063%28v=sql.105%29.aspx

And don't forget to check if the DB don't have an enterprise features before downgrade http://www.sqlskills.com/blogs/paul/sql-server-2008-does-my-database-contain-enterprise-only-features/

But if you have it online, you as a sysadmin still can backup the SMK and DMK and provide new password without knowing the old one to protect the backups...

"Access is denied" check if account, on which running sql server have sufficient rights

Restore from another backup file.

Do you have enough space for this db? If yes try this, maybe the backup is damaged.

RESTORE VERIFYONLY FROM DISK= N'd:\test\test.bak'