Home Forums SQL Server 7,2000 Backups shrink trans log RE: shrink trans log
Shas3
Hall of Fame
Points: 3671
More actions
July 24, 2003 at 1:35 pm
#466929
Create a test table in your database and do some dummy transactions in a loop. Then either shrink your log file or take a log backup with NO_LOG and take a full backup