Viewing 15 posts - 151 through 165 (of 7,499 total)
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...
November 3, 2024 at 4:13 pm
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, *...
October 31, 2024 at 2:58 pm
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...
October 31, 2024 at 12:34 pm
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...
October 31, 2024 at 12:24 pm
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 (...
October 28, 2024 at 2:34 pm
You need at least create one FULL backup ( to actually activate the log...
October 23, 2024 at 6:43 am
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 [...],
...
October 22, 2024 at 6:07 am
Launch a profiler trace to see what is going on
October 21, 2024 at 11:41 am
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...
October 21, 2024 at 8:59 am
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. ...
October 21, 2024 at 8:55 am
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
waitresource="PAGE: 14:1:5803256 "
Blocking spid="298"
Blocked spid="93"
use SP_WHO2 to figure out these connections
October 16, 2024 at 1:32 pm
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...
October 16, 2024 at 6:58 am
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...
October 15, 2024 at 1:22 pm
can you share the xml?
October 15, 2024 at 11:28 am
Viewing 15 posts - 151 through 165 (of 7,499 total)