I am truncating some logs on SQL Server 2005 using the BACKUP LOG command. The exact command I am running is:
BACKUP LOG [<databasename>] WITH TRUNCATE_ONLY
I've run the command and it executed successfully However the transaction log file is exactly the same size. I have noticed however that the log file does not have the same name as the database, ie the database is called <databasename>, but the log file is called <databasename>_1.ldf.
Is this the reason the file is still the same size? Can I run the following command?
BACKUP LOG [<databasename>_1] WITH TRUNCATE_ONLY