Don't suspend the replication - index rebuilds are logged events, so they will be replicated in an AG environment. Suspending the replication will merely store the transacions until you resume...

I've never really looked into precisely how these checks work and what they look at, but I'm wondering if the space check is looking at the default drives for databases...

One of the main reasons that I still work where I do now, is because of the genuine 'no-blame' culture that I experience here.

On the system that I'm involved with...

In case anybody has a similair situation in the future - firewall settings.

One of our many new firewalls wasn't configured correctly and was blocking the port that the listener was...

I've worked for companies that like to have public executions of those that have made mistakes (I exaggerate, but only slightly) and then announce to the world that all is...

Any newly-elected leader should have to watch the entire West Wing series. That was an amazing show.

That reminds me of a poster I saw last week.

"Kids are like farts - mine are amazing and yours disgust me".

In a two-node AG you should have Primary and a sync secondary. As you have said, failover is easy because the secondary is sync. When you failover, both nodes will...

Index usage can change within a database due to several factors, but part of it can be due to the data changing and the statistics no longer reflecting the true...

I'm with Grant on this. Certifications on their own aren't viewed well - experience is always the main focus. However, studying for the certificate will give you some direction and...

You're telling me that 'Error' isn't giving you enough information? I'm shocked.

I know you know your stuff, but just in case the obvious has passed you by (I'm an expert...

When my step-sons lived with us, I wouldn't go into their rooms without a full haz-mat suit and checking the Basalisk under the bed had been fed.

I'm in the strangely...

• This reply was modified 4 years, 3 months ago by  BrainDonor.
• This reply was modified 4 years, 3 months ago by  BrainDonor.

I've used the LinkedIn Premium, a long time ago and found it to be a bit of a waste.

It lets you send more messages and get better details of searches...

Extended Support of SQL 2012 expies in two years, so I don't see why it shouldn't be supported on Windows 2019.

Of course, the best option is to try this on...

For maintaining a copy that is allowed to be slightly behind the 'live' instance, I would go for transactional replication.

It can take a little practice to set up and maintain...