How to clean up the database log using Microsoft SQL Server Management Studio?

Question

SQL

SQL Server 2008 R2 is installed on the Win server, it runs out of space and it crashes, I found what's wrong, in the MSQL installation folder in the data folder there is a file name_log.LDF with a size of 350 gigs. I can't make a correct request to clear this log file through SQL Management Studio. Please help.

Answer 1

Make a backup of the database, and then transfer the database to the Simple recovery mode since you don’t know how to prepare logs.

Answer 2

https://msdn.microsoft.com/en-us/library/ms190488(...

Answer 3

see point 1

Answer 4

toster.com

BACKUP LOG [General] WITH NO_LOG
GO