October 11, 2018 at 1:40 am
Hi,
Is it possible to reduce database log file (.ldb file) ?
Can you advise any method to reduce log file size.
Regards
Binu
October 11, 2018 at 1:47 am
First of all what size is the ldf file and also the mdf file?
What recovery model is your database using? If it's full, how often are you backing your log up?
Thanks
October 11, 2018 at 2:22 am
Hi,
database created 1 month back
file size
mdf - 2.81
ldf - 43 gb
Fullback is taken one month back and no log backup is not taken yet.
Regards
Binu
October 11, 2018 at 2:32 am
Take a log backup as soon as you can then schedule regular log backups. Or if log backups aren't needed put the database in simple recovery.
You should also take regular full backups.
Thanks
October 11, 2018 at 2:35 am
binutb - Thursday, October 11, 2018 2:22 AMHi,database created 1 month back
file size
mdf - 2.81
ldf - 43 gb
Fullback is taken one month back and no log backup is not taken yet.Regards
Binu
This is why. If you are going to leave your database in Full recovery model, you must take regular transaction log backups in order to curtail its growth. Alternatively since this isn't a business critical system by the look of it, you could just switch it to Simple recovery model (then do a one-off shrink of the log).
October 11, 2018 at 2:56 am
Is any way to reduce the current log backup size?
Regards
Binu
October 11, 2018 at 3:03 am
Run DBCC SQLPERF(LOGSPACE) It will show you how much of you log is actually free space. It's likely that most of it is unused so the backup size will be small.
Thanks
October 11, 2018 at 4:30 am
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 11, 2018 at 7:07 am
Here is how can you reduce database log file. Shrink the database log file according to the recovery model:
https://www.mssqltips.com/sqlservertutorial/3311/how-to-shrink-the-transaction-log/
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply