Backup log with truncate_only

Hello Experts

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

Many thanks
equentinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> I've run the command and it executed successfully  However the transaction log file is exactly the same size.

Truncating the backup log will not shrink the log file..
However it would free up portions in the log file thereby reusing the log file..

>>  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.

Seems like you or someone have created the log file using that name or during some other time..
Doing truncate_only will not shrink the log file and if you want to do so, then use

DBCC SHRINKFILE ( ur_db_name_log, 1000);

where 1000 represents the size of your log file.

PS: Its not recommended to shrink the file to a very lower file size because its going to grow anyhow..
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dervishiCommented:
You can shrink the file.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.