Perry Whittle (11/2/2012)
OK, you're joking right??Firstly, TRUNCATEONLY does not apply to T-log files!
A wholesale shrink of all log files on the instance, and you believe this will be beneficial?
What do you do for an encore, shrink the data files then rebuild the indexes?
Incidentally, Do you carry out index maintenance on your SQL Server instance?
Hi Perry,
Of course it is not for production. I needed it on test and development envs and just made a search and didn't find something useful and did it myself, so I'm just sharing it and appointing that this is recommended only on testing and dev instances.
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com