Also how do I check if the table has had any options set for SP_TABLEOPTIONS such as 'LARGE VALUE TYPES OUT OF ROW'. I doubt this would be the cause...

I checked and the increase is strangely in the LOB data. Why would the LOB data increase?

Thanks Both.

Cheera, that goes against everything I have read.

Thanks,

2 node FCI 1 active one Passive.

1 Secondary replica for DR

1 secondary for reporting

Enterprise edition SQL 2017.

Also I used to use SSIS to keep master and msdb in sync. This...

As advised you will need to restore to another server.

There are 3 methods if I remember but I only remember this one.

If this doesn't work google it.

EXEC sp_attach_single_file_db @dbname='MyDatabase',

@physname='E:\Database\MyDatabase.mdf'

Total Server Memory = ??

How Many SQL instances on the server??

How much Mem reserved to the O/S.

Windows will require 4gb of mem or 10% of the total memory which ever...

HI,

The script restores all logs after the FULL backup. How do you determine at which point in the last log file you need to restore to and what is the...

Thanks Michael, I was under the impression that running CHECKDB could be considered Production work which will then mean the server will require a license.

SQL licensing feels like a religion...

-- Added in Line --and is_copy_only =0

Use msdb

go

DECLARE @databaseName sysname

DECLARE @backupStartDate datetime

DECLARE @backup_set_id_start INT

DECLARE @backup_set_id_end INT

Declare @BackupSetID int

Set @databasename =' ' --set databasename here#

Set @BackupSetID = (select top 1 bs.backup_set_ID...

--This will get the latest backup file and all the log files to the latest one.

--It creates code so you can determine where the restore point ends.

Use msdb

go

DECLARE @databaseName sysname

DECLARE...

I had this problem a while back and it was down to a badly written Service Broker.

Which was setup as a fire and forget. The initiator hangs up before the...

Googled it.
https://searchenterprisedesktop.techtarget.com/definition/Microsoft-Windows-Defender-Credential-Guard

Never heard of it. But know about it now.
Every day is a school day.

'Windows Defender Credential Guard' Noted.

I believe you load it on the laptop not the SQL Server