you are right, it's not possible also it is not key point for failover clustering

Don't worry about sp_prepare command. it doesn't affect your system.You can check from client statistics

create table testPre(a uniqueidentifier,b uniqueidentifier,c uniqueidentifier,d uniqueidentifier,e uniqueidentifier)

go

insert into testPre values(NEWID(),NEWID(),NEWID(),NEWID(),NEWID())

go 20000

--Press Shift+Alt+S to open...

Hi Rishabh ,

When you backup transaction log a database that is pricipal, transaction log doesn't decrease but precentage usage of transaction log decreases. Execute dbcc sqlperf(logspace) before...