Can you explain how is the figure showing in cardinality is worked out?

Thanks

Carolyn

Second link is no longer available.

https://www.mssqltips.com/sqlservertip/1476/reading-the-sql-server-log-files-using-tsql/%5B/url%5D

Gives a good explanation of the undocumented proc sp_readerrorlog and the parameters:-

CREATE PROC [sys].[sp_readerrorlog](

@p1 INT = 0,

...

Lock Partitioning is a feature in SQL Server that is automatically enabled for machines with more than 16 logical processors – aimed at reducing lock contention and cannot be disabled...

Just checking you ran the stored procs that populate the table you are querying?

I've tried updating the procedure to read

CREATE PROCEDURE [dbo].[usp_RefreshDeadockVictim]

AS

TRUNCATE TABLE [dbo].[DeadlockVictim]

INSERT INTO [dbo].[DeadlockVictim]

([LogDate]

...

Do you get anything returned when you just query the log ie:-

EXEC master.dbo.xp_readerrorlog 0, 1, 'deadlock victim=process', NULL, NULL, NULL, N'desc'

obviously I'm not sure which log it would ...

OK Thanks will sort

?There is no BEGIN so therefor no END needed or am I missing something?

We are fortunate enough to have a well over-specked server in a non 24/7 operation so I don't have to worry about running jobs like this out of hours but...

I think you already know the answer to this, to restore logs you must first restore the full backup with NORECOVERY you are trying to do something that is incorrect...

The fix for mirror backup works as expected, I tested it out on a few servers. Thanks for the great script.

Thanks I'll give it a try

That would be great thanks.

Great script the only change I needed was to put an addition to the where clauses to ensure I did not have a problem with the script when I have...