Viewing 11 posts - 1 through 11 (of 11 total)
Thank you both for your help.
February 21, 2020 at 7:24 am
As far as I know Index maintenance has not been undertaken at my workplace for a long period of time if at all and I would be setting it up...
February 20, 2020 at 9:40 am
I thought it may be permissions, but I gave the install domain account sysadmin over the SQL Server and admin on the server so it should be able to do...
December 5, 2019 at 8:46 am
Thanks, I am planning to keep the port number the same.
I ask because a certain team want the port changed to static to upgrade a programme that needs it to...
November 22, 2019 at 10:54 am
Yes its due to the change of IP address to the other box that SQL is failed over to. The IP address used in the Listener is the IP of...
July 29, 2019 at 8:36 pm
So I created a test setup - two VMs and a read scale Availability group between them, got an entry created in DNS for the Instance IP address and the...
July 29, 2019 at 2:35 pm
I understand a read scale AG to be a clusterless AG primarilly to provide ability to offload reads to a secondary replica. However I wanted to use it to provide...
July 26, 2019 at 7:09 pm
I have tried changing the SQL Server Agent account first through Configuration Manager. However after entering the new service account name and password and hitting the apply button I get...
June 13, 2019 at 11:25 am
No, there are no no-AG databases. Ok thanks for the reply seems simple enough - failover AGs to primary, change SQL Server/Agent accounts on secondary and then do the same...
June 12, 2019 at 2:46 pm
I have said Instance, thereby implying I am using FCI, I am using just Availability Groups. I need to change the SQL Server service and Agent account on both sql...
June 12, 2019 at 2:31 pm
On two Instances I have inherited there is just one tempDB file on both of a size of 8MB, the drive tempDB is on is 30GB and tempDB is the...
May 29, 2019 at 7:52 am