Disable Transaction Logging

Posted on 2005-04-13
Last Modified: 2012-08-13
Is there a way to build a new database with no transaction log file at all?  Or if there is a log file, it is not filled with anything ever?

I want to kill that overhead.  Nightly backups is fine for my application.

As always, any information helping out will be much appreciated.

Thanks in advance,
Question by:Danimal
    LVL 28

    Accepted Solution

    There is no way of creating a database without a log file.  As for not filling it, the closest way to do it is to set the Recovery Mode of the database to Simple.
    LVL 27

    Assisted Solution

    rafrancisco is right - you must have a log file in SQL Server. You can set it to Recovery Mode: Simple (as he says) but that is it. If you import large amounts of data you will see a large log file when you are finished. You can use DBCC SHRINKFILE (2, 10) to shrink the file to a smaller size (here 10MB).

    Bon chance
    LVL 1

    Author Comment

    Thanks to both of you.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    779 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

    11 Experts available now in Live!

    Get 1:1 Help Now