How do I truncate transaction logs of a MS SQL database?
MS SQL Database has a facility to store transaction logs. However, old transaction logs which maybe no longer required occupy space unnecessarily. WEBCOM INDIA.com Windows Hosting Control Panel allows you to truncate transaction logs so as to control unnecessary space utilization. Follow the process below to truncate transaction logs: • Login to the Web Hosting Management interface. Click here to read how >> • Go to Manage Website -> Database Manager -> List Databases. • Click the Database you wish to manage. • Click Truncate Transaction Log to complete the process. The Transaction logs are truncated to the maximum limit possible. If you wish to reduce the space allocated for logs, you should ideally truncate the logs first and then reduce the space allocated. You will be allowed to reduce the space allocated only upto the size of the actual truncated log file.
