Viewing 15 posts - 1 through 15 (of 5,838 total)
Unsure if a distributed availability group works cross domains but would be a possibility.
Then destroy the DAG at migration time and then recreate the listener on the new side as...
May 14, 2022 at 7:39 am
Use DBATools and the Set-DbaAgentJob function.
You can easily read in the text file as an array of jobs to pass to the function to enable of disable en-mass
$JobsToChange = Get-Content...
May 14, 2022 at 7:28 am
Your applications need to have connection retry logic written into them.
When a failover happens it doesn’t transfer the active sessions so you need to ensure you reopen the session after...
May 12, 2022 at 6:25 pm
No far from it.
Even in Azure you need to think about your HADR options and that’s both at IaaS and PaaS offerings.
While Azure SQL Database (PaaS) will move around the...
April 22, 2022 at 2:45 pm
If it was me, I’d be looking at 2019 or even 2022 depending on what the timeline is for its release and your timeline for upgrade.
2019 has been around for...
April 21, 2022 at 10:59 am
Gail is around on Slack quite a bit now, if you want a joining link to the slack SQL community let me know.
I know she is busy as she (I...
April 14, 2022 at 4:46 pm
No, publisher must be the AOAG not an individual replica.
The log reader technology needs the active log and can only run from the primary replica, it cannot run from a...
March 31, 2022 at 7:08 am
So, you have 3 machines in the AOAG, Server 1, 2 & 3. Server 4 is completely stand alone, not in the AG or anything?
So the publication will be on...
March 30, 2022 at 2:48 pm
So I have noticed the”Ask SSC” link from the menu has been removed.
That a on purpose change, is the plan to wind down Ask or was it an “oooops” moment.
March 29, 2022 at 5:17 pm
Have you tested sending an email direct from sp_send_dbmail?
Have you restarted the SQL Agent after enabling mail?
Have you checked msdb.dbo.sysmail_allitems to see what the system thinks it has done with...
March 20, 2022 at 5:46 pm
In this day and age I wouldn't even consider writing my own routines for SQL in PowerShell, I'd just immediately go for DBATools instead, as there is no point re-inventing...
March 18, 2022 at 8:05 am
As you posted in 2014 forum, have you created the needed load balancer and configured this at the cluster level?
March 17, 2022 at 9:25 pm
What is being done to combat the massive influx of spam posts which are happening multiple times a day at the moment?
March 16, 2022 at 11:10 pm
Well that’s still a uninstall reinstall it just saves having to script everything from master/msdb and having to replay it once the reinstall has completed.
March 16, 2022 at 7:00 pm
There is no way to do a downgrade to standard, you would have to do a complete uninstall and reinstall I’m afraid.
You may only upgrade
Dev -> Web -> Std ->...
March 16, 2022 at 6:03 pm
Viewing 15 posts - 1 through 15 (of 5,838 total)