I would lean heavily towards a security issue. When you manually kick off a job it runs under the context of whatever you are logged in as. When...

To answer some of your questions:

1) Windows Clusters Needed or not ?

Yes it is required

2) All nodes (Primary and Replica's) need Hardware identical ?

Not at all, but the OS and...

Hard to say,

I would go over each table that contains those data types and ensure you've created a full-text index on EVERY one.

If you're missing even one, the replication is...

Your question is quite vague and kinda weird, but I think I get it..

1. The provider is telling the truth; Microsoft licensing allows you to maintain 1 primary server and...

You just need to build the full-text index. Assuming you've installed it anyway. This article is for SQL2008R2, but the process will be near identical for 2014.

Cheers!

Nailed it, thanks Gila.

Perfect article.

I see you have a perfectly valid solution, so I won't bother typing it all up unless you're interested.

There is a very elegant solution to this problem using the LAG...

Thanks Gila,

To be clear; I will not be backing up the transaction logs on the primary node.

A full or diff backup is not going to free up the...

Hi,

I use HA quite a bit; so hopefully I can lend some advice. First off, there are some great suggestions on here already, but there is something you're going...

Details of each edition can be seen here:

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

Cheers!

This will get you what you're after:

SELECT

cust_id

, budget

, LastYearBudget

FROM

(

SELECT

cust_id

, budget

, LAG(budget, 1, -1) OVER (PARTITION BY cust_id ORDER...

Exactly what you're asking wouldn't be possible. But to be fair; no one ACCIDENTALLY creates a schema...that's just not something that happens.

If these are developers, it's generally best to...

The name associated with the cluster will always log you into the active node; the server's dns name will always log you onto the server.

Assume you have 2 servers:

SERV-SQL01

SERV-SQL02

They are...

Yup, that's exactly what I was thinking in regards to pulling them from the secondary server. It also gets around the problem of having a second set of TL...

I'm running through it in a test environment now. I'll let you guys know how it goes.