I'm guessing your account has the necessary share and ntfs permissions on the remote fileshare, thats why it works through VS.

Setting up an agent proxy would be the best idea...

the status of 2 for each row returned indicates that VLF is in use, (you get 1 row for each VLF in the log file) that's why you cannot shrink...

• This reply was modified 4 years, 4 months ago by Perry Whittle.
• This reply was modified 4 years, 4 months ago by Perry Whittle.

Which version of sql server are you using as there are now a set of DMV’s that expose this info, a lot easier!

under windows 2016 CIFS shares have changed quite a bit, you now need to setup a new file server role and then provision a redundant fileshare from there.

• This reply was modified 5 years, 3 months ago by Perry Whittle.

You’re missing the point, likely no one will be installing sql 2008 so the post here is irrelevant.

the latest installer clearly picks but then offers the choice to pick an...

The installer has changed drastically since 2008 so the post here, could be argued, is now irrelevant

As I said this thread is 10 years old

most people, whether ignorant or lazy, seem to rely on the installer choosing the correct collation.

it is important to set the regional...

This thread is 10 years old

Thanks for the notes. I've never seen the certificate protected by password in TDE, just the DMK. I assume doing so would ensure that the whenever the instance started...

It’s a good article but needs the following pointers

In the hierarchy section you stated that the DMK protects the certificate stored in the master database, this is not completely correct.The...

What is the windows OS version and edition you are using for these cluster nodes?

look after your stats is probably the best effort

I would say it's likely easier to deploy a new system in AWS and then migrate the database(s) to the new system, is this not an option for you?

What is it you are attempting to do exactly