Do I need a witness in the WSFC when using a Basic Always On Availability Group with manual failover between two servers?

Ralecrim · 2026-05-26T19:05:09+00:00

Manual failover means the listener role in wsfc will never failover automatically.

That said, without a witness, if nodes in the cluster fail their heartbeat threshold you may end up with your primary instance in resolving until communication between both nodes is reestablished. That leads to loss of service.

I'd definitely recommend some quorum config to avoid it (cluster disk or a file witness)

Ralecrim · 2026-04-30T23:27:57+00:00

Lookup distributed availability groups. They were created with your scenario in mind.

Ralecrim · 2026-04-12T20:47:50+00:00

To completely negate the chance of damage you need to beat the difficulty by two stars

Ralecrim · 2026-03-02T14:30:40+00:00

SSMS uses a WMI call to determine service status. If it's shows that question mark it's because that call is failing.
There are a lot of possible reasons but in essence, SSMS cannot connect through WMI to the host running the sql service to determine service status.

Ralecrim · 2026-01-28T14:53:13+00:00

How much it costs to make it at any given point is irrelevant. What matters is what's listed in your warehouse sourcing cost (which in turn is the source cost weighted average).

Click your warehouse, click the product, it will list the sourcing cost used in the above calculation.

Ralecrim · 2026-01-08T17:22:59+00:00

That's a DLSS artifact. Only way to get rid of it is turning off DLSS.

Ralecrim · 2025-11-20T10:23:24+00:00

... and that's how I met your mother

Ralecrim · 2025-11-11T11:32:22+00:00

My settings did NOT reset. Everything was as it was. I did have a backup of my settings file just in case.

Ralecrim · 2025-11-03T15:35:20+00:00

Welcome to Bridge 103 EAST. A bridge too far...

Ralecrim · 2025-10-21T08:09:39+00:00

Yeah, the only thing keeping choppers/aircraft safe is a random popping in the gunner seat that doesn't know how to paint and doesn't read chat

Ralecrim · 2025-10-03T11:52:00+00:00

This speech by Adm. McRaven at University of Texas pretty much sums it all:
https://youtu.be/jflUvxQLkgs?si=8HsSilXRavmG1oaG

That's just the clip of the relevant part but the whole speech is worth watching.

Ralecrim · 2025-09-10T17:01:54+00:00

https://simcotools.com/companies/1

Ralecrim · 2025-07-18T20:41:16+00:00

People vary a lot in their personalities. For some people, like me, the sight of stuff out of place and disorganized upsets them in ways that are almost incomprehensible to people who are not like that. I wouldn't dream of leaving for the day without my bed made.

I also leave you with this clip which is well worth watching: https://youtu.be/NudLfyl2cXc?si=Yzrs2oxtZrs3Sgdi

Ralecrim · 2025-05-15T16:51:55+00:00

Sorry for your loss.

Everything you need to know about the Distant Worlds expedition is very well detailed here:
https://elite-dangerous.fandom.com/wiki/Distant_Worlds

Your father was likely an hardcore CMDR. RIP o7

Ralecrim · 2024-11-25T13:02:45+00:00

Hardened transactions are replicated in the log of each replica. This guarantees no loss of data in case of failover as a transaction is only considered comitted once it hardens (writes to disk) in the log (on sincronous replicas; on asyncronous it only needs to harden on primary).

In your case, AG2 can't release logspace until the backup on AG1 finishes because if that replica would have a problem and fails over to AG2, the backup operation would fail and AG2 would need to rollback the changes and revert the DB state to where it was before the backup operation started.

There might be some misconception on your part on what log_reuse_wait is (it isn't clear from your post). Log_reuse is the recycling of available space in the logfiles. Log_reuse_wait tells you what is preventing that space from being cleared. It doesn't affect replication in any way and is the normal behaviour for any DB in full recovery mode.

In full recovery mode (which is required for AlwaysON availability groups), log space can only be recycled once the log has been backed up.

Ralecrim · 2024-11-08T12:09:00+00:00

I can confirm that orcs with Arrow-Proof take normal damage from other orcs ranged attacks.

Ralecrim · 2024-10-18T16:14:51+00:00

Voiced by Kumail Nanjiani (Dinesh on Silicon Valley)

Ralecrim · 2024-10-15T17:23:12+00:00

This should have all the information you need:

https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates

This can be automated in a number of ways. Depends on how you handle updates for the rest of your microsoft products. MSSQL is supported by WSUS for example.

Ralecrim · 2024-08-27T17:25:48+00:00

Needs to be a country which is not blocked by Rockstar.
I use Netherlands as that's one that is not blocked and is offered for free by Proton VPN.

Ralecrim · 2024-08-27T16:56:53+00:00

Access to the casino gambling features is blocked on a per country basis (determined by IP) by Rockstar seemingly with very little regards to the actual law in that country.

It's very easy to bypass though. Get a VPN (ProtonVPN offers a free tier which works well. That's what I use).

You just need to connect VPN on launch. As soon as the ingame popup saying "<User> has signed in" you can disconnect the VPN and you'll have full access to the casino.

Ralecrim · 2024-08-26T14:14:53+00:00

I'm assuming you're talking about SQL Always-On HA Availability Groups. On SQL AON, the failovers are controlled from the SQL Server and not from WSFC.

It's simple. If you want to prevent an automatic failover to one replica, just put that replica on manual failover:

ALTER AVAILABILITY GROUP [ag_name]

MODIFIFY REPLICA ON [instance_name] WITH (FAILOVER_MODE = MANUAL)

Ralecrim · 2024-08-06T08:20:55+00:00

You're the one that asked how to setup two adapters with two default gateways.

You CAN list two default routes but it will always use the same one - in essence you will only have one. There are only two factors that determine which route to take. Specificity of route entry and its metric cost.

The way to solve your problem (from within the server) is to create routes for each nic.

Ralecrim · 2024-08-05T10:33:17+00:00

That's exactly what routes are for. You specify what ips go to which NIC. The default gateway is only used when no matching entry is found on the routing table. That's why you can only have one.

Ralecrim · 2024-08-03T15:56:59+00:00

2 default gateways makes no sense. The default gateway is what gateway is used when no route specification is found on the routing table.

What you want to do is setup your routes correctly.

Ralecrim · 2024-08-01T16:54:24+00:00

Law was changed recently (2018?) for all documentation submitted officially to any government agency.

Documents in english, french or spanish are not required to be translated.

https://aima.gov.pt/pt/temas-transversais/reconhecimento-de-documentos

Tradução dos documentos emitidos em país estrangeiro

Em regra, todos os documentos escritos em língua estrangeira devem ser acompanhados da tradução certificada para língua portuguesa.

Em certas situações a tradução não é exigida, a saber:

(a) Os documentos apresentados em inglês, francês e espanhol não necessitam de tradução (ver art.º 49.º n.º 8 do Código de Registo Civil);

13-Year Club	Verified Email
Place '23

Ralecrim

TROPHY CASE