SQL Server Performance Forum – Threads Archive

Space available huge

Hi!
I have db 35 G
Space available 13,5 G
mdf=22000
ndf=2000
ndf=2000 Transaction log 9.8 g There is full backup at night and transaction log backup every 4 hours. I am thinking about impementing differentioal backups But shouldn’t i just create sp that will trancate transaction log and shrink db
before full backup?

First of all consider to shrink the Transaction log file and then implement differential backups which will take care of the size. If possible consider every 2 hour backup for Tlog.
Normally log truncation will occur on every execution of TRUNCATE or BACKUP LOG statement. BTW what is the current recovery model set?
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

recovery model is full

Then shrink the Tlog initially and then set the schedule of Backups as per the conveience. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>