Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SQL Table - No Logging

Posted on 2009-12-22
Medium Priority
Last Modified: 2012-05-08
How can I make my tables non logging.  The log files are enormous and since the tables are updated several times a day, I would like to make sure they don't create log files.
Question by:sproctor722
  • 3
  • 2
LVL 32

Accepted Solution

Brendt Hess earned 2000 total points
ID: 26107726
Your best option for not logging changes is to change the DB to Simple mode.  If this is an issue because some tables must be logged, then move the tables you do not want logged into a separate DB set to Simple mode.

Author Comment

ID: 26107753
How do I make this change?  I'm still a bit new to SQL

Author Comment

ID: 26107775
Nevermind, I found it.

Author Closing Comment

ID: 31669138
Excellent answer!
LVL 32

Expert Comment

by:Brendt Hess
ID: 26107784
Open up SSIS, and right-click on the DB in the tree on the left (the Object Explorer tree).  Select Properties

In the resulting box, select Options.

Near the top should be a dropdown box labeled "Recovery model".  Drop the dropdown, and select "Simple"

Apply your changes.

NOTE:  What you are giving up by doing this is the ability to restore activity that has happened since your last full backup. Consider this carefully before performing this action.  Your data will be less protected against disaster.


Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question