I am working with SQL server 2000 and have a database that has multiple transaction log file.
I need to remove the extra transaction log files and keep only one. Attached is the code that I am planning to execute. I am NOT A DBA but have this responsibility to perform this task.
Attached are also screenshots of maintenance plan and transaction log properties.
Please advice if the steps I am about to take are correct or not and any other steps should I be taking or not. I have seen a similar question posted on EE, but I am just nervous since this is the production server and I can not afford to loose any data.
Please advise ASAP since my transaction log is filling up the drive and I must clean up ASAP.
Thank you in advance.