I have a big SQL Server database (~1.5 TB) and i didn't take log backup of that database for last two weeks for some reason. Today i found that the .ldf file of that database became huge around 1.5 TB. So i took the transaction log backup and then shrinked the .ldf file to fix the space issue. I used the sql job(from maintenance plan) for taking transaction log backup and the transaction log backup taken after two weeks came up to 2TB. Now that the space issue is solved,i tried to delete the log backup(~2TB) but it says that i dont have permission to delete. I took another log backup which is like 200MB and i am able to delete those. But the first huge log backup i am not able to delete. I checked the permission,and the domain account using which i logged into the server belongs to admin group.
I even used the sql job to scrub old backup,but even that fails.
Only this huge log backup has the security part as shown in the screenshot.
Any idea what is going on.?
If i stop the sql service/sql agent service ,then can i delete this .trn file? I wanna try that sometime when no one is using the database.
I was able to delete the 2TB log backup file after i restart the server. Not sure why such a lock happened.