SQL Table - No Logging

Posted on 2009-12-22
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
    LVL 32

    Accepted Solution

    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

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

    Author Comment

    Nevermind, I found it.

    Author Closing Comment

    Excellent answer!
    LVL 32

    Expert Comment

    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

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now