Do not perform a Tail log backup if you just need a transaction log backup !!

A tail-log backups only purpose is that you can restore the original database as it...

Did you actually prefix the correct master database ?

In that case you might as well perform a "union all"

/* contained AG master db */
SELECT 'AG1_master' SourceMaster, *...

So you connect to one of the nodes of the Windows cluster hosting the Contained AG ?

( I don't know if access to master db is blocked when connecting to...

• This reply was modified 1 years, 3 months ago by Johan Bijnens.

Enable "auto close" for that database and monitor the sql server errorlog to see when it is being brought online.

ALTER DATABASE [Yourdb] SET AUTO_CLOSE ON WITH NO_WAIT...

I first prepared both stand alone instances.

Then I restored the needed db on one instance, configured the needed sql accounts ( using dbatools Copy-DbaUser ) and sqlagent jobs (...

1. Your database needs to reside in a non-simple recovery model. ( preferable full recovery model )

   You need at least create one FULL backup ( to actually activate the log...

did you try casting "value" to a numerical data type ?

e.g.

...
SUM(CASE WHEN [Metric] IN (...)
THEN cast([Value] as decimal(18,2)) END) AS [...],
...

Launch a profiler trace to see what is going on

FWIW :

Scientists are currently busy recreating tissues or animals that have been extinct for millions of years.

Perhaps that will be the fate for relational DBA and this phase will occur...

We're not dinosaurs!  I saw a Star Trek movie (from the 23rd century mind you) where Spock said that a SQL injection attack was used to do nefarious stuff. ...

FWIW

This is the sql script I always use to detangle my wait resource:

(as the script serves me for ages by now, the originatin utl's no longer work )

            
October 17, 2024 at 9:33 am
            
#4469497

            
            
                                                
        

waitresource="PAGE: 14:1:5803256 "

Blocking spid="298"

Blocked spid="93"

use SP_WHO2 to figure out these connections

Actually, if you restore the backup to an instance as a new database, there is no need for a tail-log backup at all !

( this is a flaw in the...

You've messed up the xml to much !

It doesn't produce a garph anymore !

Use dummy names ( T123 / t124 / ... ) instead of "<table name>" as < and...

can you share the xml?