Here's the create index statement which the developers run.

Create NONCLUSTERED INDEX [IX_TileID_Include] ON [DB01].[dbo].[table1] ([Tile_ID]) INCLUDE ([Die_ID],[GGI_ID],[GGI_X],[GGI_Y],[DS1_ID],[DS1_X],[DS1_Y]) with (DATA_COMPRESSION = PAGE, ONLINE=ON)

As for the server spec, it's a VM server...

Hi Jeff & Alejandro,

Thanks so much for the insights and feedbacks. I've just join this new organization less than a month only so I'm still learning some of the process...

Noted Grant! Thanks for the explanation. You're are absolutely correct that nothing can be missing from SQL BACKUPs, I did argue with the developers on this as well. However with...

Thanks all for the replies!

Unfortunately I don't have much info which I could share. The database itself doesn't have any tracing or monitoring turned on plus this issue happens on...

I notice you say this is a SQL Server 2008 R2 cluster.  I want to get clarification on what you are saying.  Are you saying when Node2 is the...

Thanks all for the reply.

I'm not well verse in using powershell, still rather new in managing a SQL server, so dbatools will gonna be challenging.

As for the versioning, my company...

Thanks all for the input.
So from what I understand, there's no need to always perform any shrinking of the .ldf file correct?
I should only increase the frequency...