Listing 1: Script to Move Active Portion of Log Away from End of the Log File

-- You must manually stop this script!
USE test_this
GO
CREATE TABLE virtual_log_file_wrapper (char1 char(4000))
GO
DECLARE @i INT
SELECT @i = 0
WHILE (1 = 1)
BEGIN
 WHILE (@i < 100)
 BEGIN
  INSERT virtual_log_file_wrapper VALUES ('a')
  SELECT @i = @i +1
 END
 TRUNCATE TABLE virtual_log_file_wrapper
 BACKUP LOG 'test_this' WITH TRUNCATE_ONLY
END
-- Manually stop this script.
-- Run sp_helpdb to verify the file shrunk.
-- Perform a full database backup so that transaction log backups can occur.