25 October 2007

SQL Server 2005 and transaction log backups

As of SQL Server 2005 you can run transaction log backup while the online backup is running. During the database backup the transaction log backup won't truncate the logs, that will only be done after the online backup is finished, see the following MS article : http://technet.microsoft.com/en-us/library/ms345414.aspx