Avatar of Mortarello
Mortarello
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Backup Sqlserver 2008

Guys,

I have my log file size of 800 mb and i did a backup. The Backup is fine but my log file still the same size. because I thought after the backup, the log file size would be less.

Am i correct ?

Many Thanks
Microsoft SQL Server

Avatar of undefined
Last Comment
Mortarello

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Metehan Ozcullu

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Mortarello

ASKER
Tks, I did the backup 3 times and shrink.

Now file size is 15 mb. :)

Tks
Guy Hengel [angelIII / a3]

no, not correct.

the LOG BACKUP will NOT decrease the log file size .... just mark the space used internally as reusable.
the FULL BACKUP will not act on the log file at all in that regards.

note: you should, in regular operations, NOT try to regularly reduce the log file, as that will just require the db to increment the file size again ...
instead, make sure you just run LOG backups regularly enough.
Mortarello

ASKER

You mean that if I do regular log backup. The file is not going to grow because he is going to use the reusable area ?

Tks angelll.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Metehan Ozcullu

yes it will use the emptied log area. to get that area back to os you should shrink the file.
Mortarello

ASKER
Ok.

Thank you very much  mozcullu and angelIII