Search code examples
sql-servertransaction-log

SQL Server Clear transaction log

I have a database that is in Full Recovery Mode that I restored from a backup file

Now I want to clear/truncate the transaction log file. How I can do this.

Step 1 I tried to backup the transaction log using

BACKUP LOG [test] TO  DISK

but I get error:

BACKUP LOG cannot be performed because there is no current database backup.

So what I should do to clear the transition log if I want to keep the database in Full Recovery Mode

Solution

  • This:

    BACKUP LOG cannot be performed because there is no current database backup.

    Means your database is in "pseudo-full" recovery, and until someone takes a full backup there's no way or need to take log backups, and the log will be still be truncated after each checkpoint, just like in the SIMPLE recovery model.