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

A

Alexander Zharov2017-06-27 21:20:28

SQL

Alexander Zharov, 2017-06-27 21:20:28

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.

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

S

splxgf, 2017-06-28
@splxgf

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.

N

n-fom, 2017-06-28
@n-fom

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

O

Olgeir, 2017-06-28
@Olgeir

see point 1

K

Konstantin Tsvetkov, 2017-06-28
@tsklab

toster.com

BACKUP LOG [General] WITH NO_LOG
GO