turn off logging? 
Author Message
 turn off logging?
how do you turn off SQL's logging for a transaction, if , say I didn't want
that query to get inserted into the log file?

thanks

Paul



Wed, 02 Jun 2004 02:15:28 GMT
 turn off logging?

Don't think you can do that!

Why would you want to. Should you have to do a recovery that transaction
would not be there to recover.


Quote:
> how do you turn off SQL's logging for a transaction, if , say I didn't
want
> that query to get inserted into the log file?

> thanks

> Paul



Wed, 02 Jun 2004 02:43:58 GMT
 turn off logging?
I've actually been wondering the same thing. I'm working on an app that will
be deployed to a group of users that are not very computer literate. When
considering which database we should deploy the app on I recommended SQL
Server as it's much more robust and scalable than an Access database, which
is what other members of our team wanted to use. Clearly there is much more
maintenance to SQL Server that will fall on the backs of the clients that
purchase the app. One advantage to using an Access database is that there's
really not much in the way of maintenance that you need to concern yourself
with. If our clients don't take an active part in the regular maintenance of
the database they could easily end up with a transaction log size that's
huge in comparison to the data files. Had we chosen to deploy the app using
Access (which I don't condone) we would have no real maintenance concerns.

Ken


Quote:
> Don't think you can do that!

> Why would you want to. Should you have to do a recovery that transaction
> would not be there to recover.



> > how do you turn off SQL's logging for a transaction, if , say I didn't
> want
> > that query to get inserted into the log file?

> > thanks

> > Paul



Wed, 02 Jun 2004 20:16:12 GMT
 turn off logging?
Yes and no, you are just changing the nature of the problem by going to Jet instead of MSDE/SQL Server.  You can dodge the bullet of needing regular maintenance, but you pick up more work than you avoid when you consider the disaster recovery that is so common with Jet files.

SQL Server does require more thought in terms of "care and feeding" than Jet does, but nearly all of that "care and feeding" can be automated.  If you need completely reliable cleanups, then the cleanup of crashed .MDB files is a very labor intensive, manual process.

From any perspective I can imagine, I'd prefer to use MSDE/SQL Server over Jet for "mission critical" packages.  Jet is fine for small, single user databases, but if I had to "bet the farm" on anything, I'd prefer to bet on MSDE/SQL Server.

-PatP

========================================

Please post DDL at the very least, and DML when possible to make it easier for people to help you.

Please reply only via newsgroups, as I rarely reply to email.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Thu, 03 Jun 2004 01:38:42 GMT
 turn off logging?
Couldn't agree with you more Pat... actually, my biggest problem at this
point is that I'm still trying to learn how to automate the maintenance of
the SQL Server db so the clients won't have to concern themselves with the
issues.

Thanks much for your insight.

Ken


Yes and no, you are just changing the nature of the problem by going to Jet
instead of MSDE/SQL Server.  You can dodge the bullet of needing regular
maintenance, but you pick up more work than you avoid when you consider the
disaster recovery that is so common with Jet files.

SQL Server does require more thought in terms of "care and feeding" than Jet
does, but nearly all of that "care and feeding" can be automated.  If you
need completely reliable cleanups, then the cleanup of crashed .MDB files is
a very labor intensive, manual process.

From any perspective I can imagine, I'd prefer to use MSDE/SQL Server over
Jet for "mission critical" packages.  Jet is fine for small, single user
databases, but if I had to "bet the farm" on anything, I'd prefer to bet on
MSDE/SQL Server.

-PatP

========================================

Please post DDL at the very least, and DML when possible to make it easier
for people to help you.

Please reply only via newsgroups, as I rarely reply to email.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Thu, 03 Jun 2004 02:27:15 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Turn off logging

2. Turn off Logging of TEXT columns ?

3. Turn off logging?

4. Help! Turn Off Log

5. Turn Off Logging for Alter Table Statement

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