How to delete Transaction Logs in SQL database

[Former Member]

Hi,

Can any one explain me the process how to delete the transcation logs in SQL database.

Thanks

Sunil

[Former Member]

Hi,

See below mentioned SAP note & link, it my help you.

Note 555223 - FAQ: Microsoft SQL Server

https://www.sdn.sap.com/irj/sdn/mss

Thanks,

Sushil

[Former Member]

Hi,

Thanks for the information but I am unable to find the information I needed.

My request is how can I delete the transaction logs ,if there is any procedure please let me know.

If I am taking any backup, do i need to turn off the SAP server that is running at the moment or can i take it online.

Thanks

Sunil

[Former Member]

Sunil,

Yes you can take online backup in MS SQL server.

The transaction log files contain information about all changes made to the database. The log files are necessary components of the database and may never be deleted. Why you want to delete it?

I am taking any backup, do i need to turn off the SAP server that is running at the moment or can i take it online

There are three main types of SQL Server Backup: Full Database Backup, Differential Database Backup and Transaction Log Backup. All these backups can be made when the database is online and do not require you to stop the SAP system.

Check below link for details

http://help.sap.com/erp2005_ehp_04/helpdata/EN/89/68807c8c984855a08b60f14b742ced/frameset.htm

Thanks

Sushil

[Former Member]

Hi,

The tansaction logs were shrinked has solved the issue.

Thanks

Sunil