Viewing 15 posts - 1 through 15 (of 125 total)
Great, thanks! That does the trick perfectly.
July 8, 2022 at 12:56 pm
Not to worry, I'm interested in the answer but I guess I can do this with charindex ... I'll give it a go.
July 8, 2022 at 8:44 am
Fair question. Good point made. Thanks
November 24, 2021 at 11:20 am
So I have an AOAG set up. I'm not keen to go for it. Duplication isn't really an issue - (don't ask! there are lots of constraints here).
I'm presuming it's...
November 24, 2021 at 9:28 am
Oosh, my mistake. It was a SQL cluster with a virtual SQL server name. I'll leave it here in case there are any other stressed out dummies. Thanks for answering...
October 21, 2021 at 3:13 pm
April 28, 2021 at 2:53 pm
Duh, of course. Thanks Jeff! Appreciate you taking the time to reply. I work alone and every now and again, just get stuck on something and it REALLY helps to...
April 14, 2021 at 9:07 am
Thanks Brian. Appreciate the response. Some good ideas I'll have a deeper look into. I especially like the pushing to both systems - sorting it out at source but if...
March 14, 2021 at 4:56 pm
Thanks for taking the time to answer. You raise some really good points. I guess I was thinking from my side as the DBA that I suspect there's a...
October 9, 2020 at 4:16 pm
Duh. So it WAS me being a div. I hadn't clocked that Alejandro. Many thanks.
September 9, 2020 at 1:22 pm
Just a quick note to say that it seems you can failover an AlwaysOnAG role via the FCM if it is set to synchronous with auto failover. You can't...
June 25, 2020 at 2:38 pm
Hey Jeffrey, thanks for the reply.
So I've just checked on my estate & I am able to failover the AlwaysOnAG via the FCM for the other clusters. Right click, move...
June 25, 2020 at 7:48 am
I should probably mention that this client has the most ridiculous lockdown policy so it could easily be GPO, permissions, firewall ... but my server admins are completely unhelpful until...
June 24, 2020 at 6:05 pm
Update - restarted the SQL server on the mirror & the issue resolved itself. Meta data was amended & I was able to drop the databases. Not ideal & unsure...
May 5, 2020 at 1:02 pm
I hadn't at all considered the licence issue. I suspect we have unlimited virtualisation rights but I'll check.
That issue aside, the reports won't create too much overhead - they...
January 23, 2020 at 1:25 pm