var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Truncate Log
Does anyone know how to truncate log without grow up space used?
BACKUP LOG database_name WITH TRUNCATE_ONLY
Originally Posted by sbahri
Pinoy ako, pinoy tayo! Ipagmalaki mo...
Use SIMPLE recovery model and set an optimum value to Transacation log file, otherwise the bulk load and database maintenace jobs will increase the size of Tlog.
thanks for your help.
Originally Posted by trojanz
btw,I have 5GB current size on log and space used is 26MB.
How to change 5GB current size into 500MB...?