How to fix "Error 9002 Cause Checkpoint"?

Question

Database administration

There is such situation:
1. A DB which DBCC SQLPERF(LOGSPACE);shows that Log Space Used exceeds 100%.
2. Because of this, I can neither detach the database, nor make a backup, nothing at all. Always throws error 9002 Checkpoint .
3. There is no backup.
Question: what can be done in this situation?

Answer 1

Increase the size of the database , if the edition allows.
Add data files or logs .
If it is not possible to correct the error according to the manual , it will remain to use strong means:
- attach a data file on another server without a log, it will be created empty and replaced with it on the main server;
- export everything to a new database.
Naturally, you need to take care of the new database: set it up, clean it in time and solve other problems.

can't detach db

Stop the server service and the files will be released.