sproctor722
asked on
SQL Table - No Logging
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Nevermind, I found it.
ASKER
Excellent answer!
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.
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.
ASKER