Right click the SSMS icon - properties - under compatability check the "Run this program as an administrator" box

You can back up and Truncate your transaction log. https://technet.microsoft.com/en-us/library/ms189085%28v=sql.105%29.aspx

So I would say it this way 2 - processors each with 10 - physical cores each - hyper threaded for a total of 20 logical processors each.

I would also...

First thing to understand is that "Always On" is a marketing term. Based on what you stated in the original post and what you described as "Instance-level High Availability...

I thought we determined that you don't need to set up an availability group. You should be done at this point. Fail Over Clusters and Availability groups are...

https://msdn.microsoft.com/en-us/library/hh270278.aspx

Again Books online the one I use is titled High Availability Solutions - SQL Server 2012 Books Online. Try to search for that.

Given your statement what you are referring to is Always on Fail over Clustering. There is a difference between this and Always on Availability Groups. And yes, Failover...

There are a lot of what if's here like SLA's and RPO/RTO. The simple answer is no, you don't need to store it twice on the SAN. I...

My experience with Oracle support is that it is much better than Microsoft when you have to call, though you absolutely pay for it. Microsoft problems 99 times out...

Also you can open services.msc through computer management, administrative tools etc. and choose Action --> Connect to another computer

So I restored to a test enterprise instance and I cannot drop either because they are dependent on a table. THe table does not seem to have partitioning enabled...

That is a nice DMV I had not idea that existed. Forgive my ignorance, partitioning is a mystery to me. Is there any other way besides dependencies that...

That is what I was thinking, it seems easy enough. But is there any other reason why removing the function and Scheme would cause problems. This database was...

That didn't seem to be my problem, I can't find any denies on anything.

Thanks for the flame, now I know why they call you evil:-D Yes you need to start with an understanding of the application. In my experience, all questions must...