Home » Blog » Reply » Reply To: Deleting a Transaction Log File in SQL Server

Reply To: Deleting a Transaction Log File in SQL Server

Andrew Jackson ~ Modified: July 6th, 2015 ~ ~ 1 Minute Reading

Home Forums Deleting a Transaction Log File in SQL Server Reply To: Deleting a Transaction Log File in SQL Server

#319 Score: 0
Andrew Jackson
Moderator
1 pt

In SQL Server, to DELETE a log file in SQL Server just click on OBJECT EXPLORER and connect to the SQL Server database engine then expand DATABASES and right click on the database to which log file you have to delete and then click on properties and select the file page.
NOW, In the DATABASE FILES grid, select the file to delete and then click on REMOVE then click OK.

PS: The file must be empty before it can be delete.