I am right in thinking that the instance root directory (instance configuration screen) is for the binaries and the data root directory (data directories) is where I can point...

Great picture!

It was fantastic meeting you guys!

BTW, Wayne is as tall as me, so he's the giant 🙂

How many instances are running on that cluster?

Mixing service pack levels is supported.

You can have different instances with different service pack levels.

What is not supported is having the same...

Then don't use a production database. Making changes to a test database would have less dire consequences.

Moreover, if...

SQL Server logs are simple text files. By default, you will find them in the data root, under the Log folder. File names...

The page you linked describes how to change the server collation. It should work and if it doesn't check the setup logs for errors.

However I'm under the impression that you...

BallaKet (9/9/2015)

I followed the instructions you gave me (I hope I followed your instructions correctly) and here are the error messages;

Instruction (part 1):

Don't bother changing the parameters of the service,...

You're not alone. Bad move from MS in my opinion.

Don't bother changing the parameters of the service, jut run it manually.

Stop the service, open the service properties and copy the executable location. Paste it to a new command prompt...

AlwaysOn Failover Clustered Instances is available in Standard edition, limited to 2 physical nodes.

"AlwaysOn" is a marketing name and it does not correspond directly to a single feature. Stop using...

MAX columns accept data up to 2GB of text.

If the text is truncated, it may be due to some function you're applying to the data before inserting. For instance, REPLICATE...

Oh, I see. Bad day...

You should be fine restoring your master database. What error are you getting?

You have everything you need in the script I linked in my previous reply.

If I understand correctly, you are moving your default and sharepoint instances from a previous server.

I have no direct experience with moving sharepoint databases, but I suspect that restoring...

There's an undocumented function that could help you here. It's called fn_replgetparsedddlcmd and is used by replication. Basically, it parses the DDL commands and strips away the CREATE part, that...