Home Forums SQL Server 7,2000 Backups shrink trans log RE: shrink trans log

  • 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

    Shas3