| M | My database log is full at once, what should I do?

shenmue024

1. Database-> Properties-> Options-> Failure Recovery Model changed to Simple
2. Database-> All Any-> Shrink Database-> File-> Select Log File-> OK

wetboy

1. Database-> Properties-> Options-> Failure Recovery Model changed to Simple
When I changed, there was a prompt saying that the database log or something, I did not see clearly
Then in the second step, the "shrink database" is grayed out.

wetboy

What is the use of that paragraph

I executed the database and it works, but the log has not become smaller.

rcloud

Back up the log.After the backup, you can clear the log.

darkash

How do I back up my logs? Let me compare.

wetboy

But my log hasn't become smaller.
Then in the second step, the "shrink database" is grayed out.

rcloud

Under program files\mssql\data are all data and log files. Each database has 2 files, one is a data file and the other is a log file. Just look at the extension and you can delete the log file.

wetboy

In other words, log files can be used now, right?

space_wsy

Learn

yfacmilan

Learn