I just completed a backup of our SQL server. The details are:
DB Name: JLRXAPP.mdf Size: 20GB
DB Log: JLRXAPP_Log.ldf Size: 45GB
The 45GB log file is still on the SQL Server. I thought it would be truncated after a full backup but it hasn't- why?
FYI, the backup was to the Backup Server's HDDs, and took 46 minutes.
SQL Server is V2000, BE V10.1 Rev 5629, Windows Server 2003 SP1