Turn off logging? 
Author Message
 Turn off logging?

Is there any way to turn off transaction logging entirely?  We have
the "Truncate Log on Checkpoint" option selected and we periodically
checkpoint to get rid of the log, but since we don't use rollback at
all it seems like we'd get better performance with it turned off
entirely.

//sa



Sat, 26 Feb 2000 03:00:00 GMT
 Turn off logging?

You may not use logging, but SQL Server most certainly does.

To discover the benefits of automatic recovery, switch the server off in
mid-transaction!!! Upon startup SQL Server recovers to the last checkpoint,
using the uncommitted transactions in the log to roll back.

Without this feature your database would require restoring from the last
good backup.

For this reason logging cannot be disabled, and a good thing too....
--
John Thorpe
SQL Server DBA

Remove "_killspam" to reply


Quote:
> Is there any way to turn off transaction logging entirely?  We have
> the "Truncate Log on Checkpoint" option selected and we periodically
> checkpoint to get rid of the log, but since we don't use rollback at
> all it seems like we'd get better performance with it turned off
> entirely.

> //sa



Sun, 27 Feb 2000 03:00:00 GMT
 Turn off logging?

Turning off logging would be a very big mistake!  the only way you may not
want to use logging is in a development environment.  In a production
setting you should always be logging.

Jeff Klein




Quote:

> You may not use logging, but SQL Server most certainly does.

> To discover the benefits of automatic recovery, switch the server off in
> mid-transaction!!! Upon startup SQL Server recovers to the last
checkpoint,
> using the uncommitted transactions in the log to roll back.

> Without this feature your database would require restoring from the last
> good backup.

> For this reason logging cannot be disabled, and a good thing too....
> --
> John Thorpe
> SQL Server DBA

> Remove "_killspam" to reply


> > Is there any way to turn off transaction logging entirely?  We have
> > the "Truncate Log on Checkpoint" option selected and we periodically
> > checkpoint to get rid of the log, but since we don't use rollback at
> > all it seems like we'd get better performance with it turned off
> > entirely.

> > //sa



Tue, 29 Feb 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Turn off logging

2. Turn off Logging of TEXT columns ?

3. Help! Turn Off Log

4. Turn Off Logging for Alter Table Statement

5. turn off logging?

6. Turning off logging

7. Turning Off Logging

8. Turn off logging in SQL Server

9. Turn off logging

10. Turn off logging for a transaction

11. turn off LOGGING?

12. How can I explicitly turn off logging (to tempdb) inside a stored proc


 
Powered by phpBB® Forum Software