Tag Info

New answers tagged

1

Thomas Stringer has answered a very similar question at: Transaction Log Maintanance While Using AlwaysOn Availability Group The answer is that the Availability Group replicas are aware of each other and when either the primary or secondary does a backup, both logs are able to free log space. The article you referenced also offers the explanation that Log ...


1

You can also use T-SQL use master; go alter availability group [ag_name] add database ReportServer backup database ReportServer to disk = N'\\some\shared\location\available\to\all\nodes\ReportServer_HADR.bak' WITH FORMAT, INIT, COMPRESSION, STATS; GO backup log ReportServer to disk = ...


1

While not real-time, Log Shipping can be performed at pretty frequent intervals. You can configure how often your Primary performs log backups and how far behind your Secondary should be (0 minutes, 30 minutes, 2 hours...). Brent Ozar makes the case you could even execute Log Shipping every minute if you wanted. It's certainly not for everyone, but helps ...


3

Well, you can keep using mirroring. "Deprecated" does not mean "doesn't work any more" - it just means that, at some point in the future, it won't be supported when you move to some version > 2012 (probably at least 3 versions later, maybe more given the backlash this announcement has caused). By then, I am sure they will have a replacement for mirroring ...


0

I used the following query that I got from EXCHANGE SPILL, but slightly modified it to convert time from UTC to local. DECLARE @FileName NVARCHAR(4000) SELECT @FileName = target_data.value('(EventFileTarget/File/@name)[1]', 'nvarchar(4000)') FROM ( SELECT CAST(target_data AS XML) target_data FROM sys.dm_xe_sessions s ...


4

Here's my go-to query to pull the events that Aaron mentioned (availability_replica_state_change). This script also takes the liberty of converting the UTC time to your local time: declare @xel_path varchar(1024); declare @utc_adjustment int = datediff(hour, getutcdate(), getdate()); ...


2

Look for availability_replica_state_change events in the AlwaysOn_health extended events session. If this session is not running: ALTER EVENT SESSION AlwaysOn_health ON SERVER WITH (STARTUP_STATE = ON); ALTER EVENT SESSION AlwaysOn_health ON SERVER STATE = START; More info: ...


1

If I understand your question you are wanting to break the cluster and always on and have 3 db's on each server? If so you plan sounds good but after you move the 3 db's to node B I would create DNS names that point to both node A/B as necessary before removing them from the AG and deleting off node A. That way anything using the DNS as a connection will ...



Top 50 recent answers are included