Thanks (again).

I'll give it a try over the weekend and see how that goes.

Have a good weekend.

Nic

Hi,

Thanks for the extra information. Your correct my connection was not encrypted. I did as you said in the connection properties and it connects but I still had...

Hi,

Thanks for getting back to me on this, seems there a few limitations/consideration on this feature. I made he changes you mentioned but I'm still getting an error this...

Hi,

Thom, thanks for the samples, makes thing clearer in my mind.

Eirikur, I believe that there will only be one session element.

Thanks to all those...

Hi,

I've attached a sample file, the actual XML is large and sensitive in nature but using the sample if I can get the following then I should be...

Hi,

Thanks for getting back to me on this and confirming that for me.

Nic

Hi,

Thanks for getting back to me, very useful, I didn't think of XQuery, I could built that up dynamically. Worth a look at before the SSIS approach.

Thanks for the replies.

As for the font - I thought I'd Jazz it up a bit. 🙂

So I tried it out in a test environment.
Its not supported by Microsoft, the installer checks it all and then errors and says it is unable to continue.
I therefore...

Hi,
I suspect you may need to what I would do is leave it running, do the SP install and then if it needs a restart of the service it will tell...

Thanks for the reply. Your right we need a bit more logging in there. As the conversion is important to the business I'll run it sections and then come back...

I'd agree, given that mainstream support ends for 2012 its wise to get off that. This is exactly what we are doing, as has been said Vnext has no date so...

Hi,

This should help you out;

https://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases

To do Diff backups you'll first need a full backup, so you can just modify the sample to do...

Seems to be working as planned and the secondary is shrinking automatically.