Viewing 15 posts - 31 through 45 (of 1,318 total)
Were your t-log backups on the primary or the secondary? I'm guessing secondary?
October 16, 2019 at 12:52 pm
Best thing to do is test it in your Dev or sandbox environment.
October 14, 2019 at 10:39 am
I set sa as the database owner but I always disable the sa account so there are no problems with security.
Thanks
Same: I also rename the sa account.
October 9, 2019 at 8:39 am
Sorry, I was tired when I posted earlier; I see you've already said that in your first post. Is your AG in synchronous or asynchronous mode? When you check the...
October 9, 2019 at 8:38 am
Run this:
select name, log_reuse_wait_desc from sys.databases, and tell us what the output is for that database.
October 9, 2019 at 7:25 am
Are both sides running the same edition (i.e. Standard/Enterprise/etc.)? If not, they do need to be.
October 7, 2019 at 10:42 am
We do broadly the same as Frederico. Servers which are clustered together for AGs share gMSAs but otherwise they are unique.
I would not use one account across the entire estate.
September 30, 2019 at 12:23 pm
Do you have a question?
September 30, 2019 at 7:59 am
Both of the replies above are absolutely right, but just to add that if you want to try to prevent the log files from growing too big in the first...
September 25, 2019 at 2:53 pm
That's just how the releases are referred to: https://en.wikipedia.org/wiki/List_of_Microsoft_Windows_versions
I find it a bit unhelpful myself.
September 25, 2019 at 12:23 pm
I think it's the second tab in the restore GUI- there's a box you can tick.
September 20, 2019 at 2:08 pm
This is Windows Server 2016, is it? I think that was dynamic quorum at play. Because you lost the FSW you had a cluster with an even number of votes,...
September 20, 2019 at 1:42 pm
Ok, sorry, I see what you're saying there (Friday afternoon syndrome). The Current Host Server is not the primary for the AGs, it's just the node that hosts the cluster...
September 20, 2019 at 1:14 pm
Thanks for humouring me and sorry for all of the questions, but where are you seeing a primary and secondary cluster node there? (It's so much easier when you can...
September 20, 2019 at 12:52 pm
Viewing 15 posts - 31 through 45 (of 1,318 total)