September 26, 2005 at 9:04 am
How do I reclaim allocated, backed up LOG space?
Every nite, I run a full DB backup at 1am. I then run HOURLY log backups from 8am - 12:05am using:
BACKUP LOG my_db_name TO DISK = @STR
Is there a subsequent command I should be issuing upon the completion of my LOG backup job?
September 26, 2005 at 9:22 am
You do not need to reclaim the space unless there is some kind of issue with disk space on your hard drive.
sql will reuse the space in the log. But if your having space issues you can perform
dbcc shrinkfile (Logfilename,100,truncate_only)
100 being the size in megs you want your file to be.
September 26, 2005 at 9:21 pm
Hi Ray,
Is it right to run DBCC Shrinkfile when we have tlog backup running.
do Microsoft support this.
AFAIK when we go for ful backup sql server shrink the logfile and the same with tlogbackup.
from
Killer
September 27, 2005 at 9:42 am
DBCC SHRINKFILE can be executed even while a database is in 'full recovery' mode. The command will only 'shrink' the inactive portion of the log file. However it might not shrink at all since the log is 'circular'. Search the site for shrink transaction log, there is lots of information on this subject. As for 'Is it right', well, every site and database server are different. This is a call that you have to make.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply