If you are relying on transaction log backups, however, you will need to change the recovery model for that database to "Full" or "Bulk-Logged" in SQL Server 2000 or in SQL Server 2005.
In SQL Enterprise Manager, right-click the database and click Properties. Click the Options tab and select either Bulk-Logged or Full for the recovery model.
For a description of the three recovery models and their differences, see "Selecting a Recovery Model" in SQL Server Books Online.
In SQL Server 7.0, a job created by the Database Maintenance Plan Wizard to perform a transaction log backup would not fail even if the database was set to "truncate log on checkpoint". This was due to a bug in SQL Server 7.0; for additional information, see the following article in the Microsoft Knowledge Base:
The master database should also be left in the "Simple" recovery model; for more information, see the following article:
ID do Artigo: 303229 - Última Revisão: 10 de jul de 2008 - Revisão: 1