Should anyone search and find this post.

I ran set encryption on about 10 times and the encryption state remained at 1. Fortunately just for heck of it I ran...

I had to remove the mirror first then change the paths as per the guide below, then put the mirror back. Fortunately, it all worked out ok.

I think I can follow this

https://www.sqlmatters.com/Articles/Moving%20database%20files%20to%20a%20different%20location.aspx

Hi There I've posted the query and the execution plan.

As always any help to be greatly appreciated.

declare @accountId0 bigint = 1719,
@status1 int = 11,
@senderDone2 bit = 0,
@PreviewMode3 bit = 0,
@OutsideRetention4 bit = 0;

declare @documents TABLE(
         ...

You can semi-ignore me in a way. It is a statistics issue in a way. The estimated Number of Rows was 211 , but the actual number of rows was...

Thank you so much !!!!!!!!!!!!!!!!!!!

I ran the create certificate command. Restarted sql server and the DB recovered and went back online. Northern Soul know that if you do...

or alternatively I want to remove TDE completely so I can have another try at configuring it. Could I remove what ever sql server is expecting.

My DB backup...

Hi Northern Soul.

USE master; 
GO 
-- drop certificate
DROP CERTIFICATE captaincaveman

I have the original Certificate and password.

I take it there is some...

I Did find this...

I deleting a Certificate yesterday. Basically yesterday I disable a mirror and tried clearing out all previous setup I'd done for TDE and I wanted...

Should I try the following and see the outcome ?

ALTER DATABASE 'DATBASE NAME' SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE 'DATBASE NAME' SET ONLINE WITH ROLLBACK IMMEDIATE

Thank you. I think I'll just leave the server list alone.

Forget what I said , I'm being a dope. there are more columns than my result set is displaying, that's why I'm seeing a comma at the end, because there...

Firstly thank you very much for your help,

However what's very interesting is that I still get a comma at the end of the string even with your script.

There must be something strange with the way the column names are stored or something , but cause this statement works for my colleague on a different DB when he...