Very old post, but, I wanted to let Jeff know that I am in this exact situation.

We had a SQL server where it lost connection to the time server and...

I forgot to mention I did this two weeks ago and I have been on PTO since figuring the updates to the SPN and everything else should be propagated by now.

We have been a Cohesity customer now for 8 months.  It has issues and we are helping to teach the Cohesity engineers about SQL.  Not kidding.

Have you tried to migrate...

Sorry, whitedotqe, I don't know your particular situation.

What I don't understand is why anyone would want to leave them orphaned?  What is the use case?

If you have a legitimate business...

Enterprise edition.  I'm just going to do it the old fashioned way of adding the nodes to the cluster.

I am hoping to learn more about the Distributed Availability Groups.

Thanks for...

So, are you saying if they wanted one level of permissions, they use one login, but if they need another, they use a different login?  If so, then that login...

I guess my question would be, "Why do you want to keep them?".  Leaving any orphaned objects, whether it be users, views, sprocs ... can only add confusion and possible...

That was my first attempt.  I've set up several AGs without problem.  The cluster verification report is fine, yet I cannot add the secondary to the AG.

Can I add a...

Don't use pre-built AWS SQL AMIs.  They cost more (unnecessarily).  Just stand up an EC2 instance and you get to configure it exactly as needed.

Think about this.  You have multiple instances on a machine.  Let's say you need to do some sort of maintenance to one, but not all of the instances.  You can...

• This reply was modified 5 years, 2 months ago by  Davis H.

There are many, many articles addressing just this out there in the GoogleVerse.

SQL Calculate table row size

But you can do this by hand as well.  For...

On the "old" SSRS node, go into the SSRS Configuration Manager and make a backup of your Encryption Keys.  Copy these keys over to your "new" SSRS node.  Restore these...

So, if we are not going to a new underlying SQL Server node to support the SSRS node, there shouldn't be any restore of the ReportServer and ReportServerTempDB databases.  The...