I have a server with 25GB of free space. The software stopped working because the transaction log is full. I noticed that the database has two logs files; one is 45Gb and the other is 65Gb.
I think the guy working here before me (he is not anymore) added a second log file so the software would continue working, however there is almost no space left on disk.
I tried using SQL Server Management Studio to take a full backup but I can't since the transaction log is full.
What are my options? I can shrink the logs but I don't have ANY backup and can't do any of them.
Should I change it to simple mode first? Can I script the whole database and save it as 'backup'?