• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1903
  • Last Modified:

Disable Transaction Logging

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,
2 Solutions
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.
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
DanimalAuthor Commented:
Thanks to both of you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now