Good morning. I am attempting to manage a remote MSSQL 2000 Server (via remote desktop) and am noticing that there is a 88 GB "transactions" file located in the root of my \BACKUP folder.
I've done some research on this, and all I seem to be able to find is information about how to shrink transaction log files. I'm uncertain as to whether these transaction log files (which have .TRN extensions) have anything at all to do with the file I'm referring to (called "transactions" with no file extension - and which is friggin' gigantic by comparison), and if the same tips/instructions apply.
Anways, I absolutely must find a way to reduce the size of this 88 GB "transactions" file somehow. Is that at all possible, and if so, .. how? Are there any possible negative consequences of doing this?