jschaddock
Programmer
I have a number of databases contained on the SQL server that I administer.Looking at the properties of some of the databases they have huge amounts of unused space on their transaction logs which I would like to free up to the system whilst leaving the space that is used by the transaction log alone.I have tried using the dbcc shrinkfile command but can't seem to get it to work.
Could someone please let me know how I can free up the unused space on the transaction log whilst leaving the used space alone?
Thanks
jschaddock
Could someone please let me know how I can free up the unused space on the transaction log whilst leaving the used space alone?
Thanks
jschaddock