question

suesh avatar image
suesh asked

what is the database status if log file is 100% full?

If database log file is completely full then database goes to which state? Still online state or any other state?
log-file-size
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
The database will be online. SELECT queries will still clear, but nothing that requires a transaction will complete. You'll see lots of errors, all related to the log being full.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.