Viewing 15 posts - 1 through 15 (of 42 total)
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...
July 24, 2020 at 2:24 pm
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...
July 10, 2020 at 6:26 pm
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...
July 2, 2020 at 9:48 pm
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...
July 2, 2020 at 8:41 pm
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...
July 1, 2020 at 9:05 pm
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.
September 19, 2019 at 11:00 pm
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...
September 18, 2019 at 6:36 pm
February 19, 2019 at 1:05 pm
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...
February 19, 2019 at 11:58 am
February 13, 2019 at 9:52 am
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...
February 12, 2019 at 2:23 pm
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...
February 12, 2019 at 12:28 pm
So, what about starting over from scratch? I have done this numerous times going from one server to the next (all same versions-OS/SQL) as well as upgrading from different versions...
February 12, 2019 at 11:56 am
have you run a "sp_configure" against both machines (with advanced options, of course) and compared?
ensure everything makes sense
February 6, 2019 at 5:37 pm
Sorry if I missed it in the previous posts, but did you go into SSRS Config Manager and change the database connection to point to your new server?
I...
February 6, 2019 at 5:34 pm
Viewing 15 posts - 1 through 15 (of 42 total)