You must perform a full database backup before you back up the transaction log for a database in SQL Server 2005 and in SQL Server 2000

Before you try to back up the transaction log for a database in Microsoft SQL Server 2005, you must perform a full database backup. Otherwise, you receive error messages that indicate that the BACKUP LOG statement stops abnormally. You must also perform a full database backup before you try to back

Read More - Register for Free Membership