Database FAQ
The following section lists some of the common questions asked by DBAs about SQL Server database management.
| Q1: | Can the transaction log be disabled? |
| A1: | No, you cannot disable the transaction log. This question is commonly asked when the log is not part of someone's backup strategy. Consequently, many people would rather not periodically backup the transaction log. Unfortunately, you can't avoid having transactions written to the log. But you can have the transaction log truncated automatically in SQL Server; set the database recovery model to Simple (see the section “Setting Database Options” earlier in this chapter for more information about Simple recovery). |
| Q2: | Can I read the transaction log or use the transaction log for auditing ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
