[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 716
  • Last Modified:

turn off logging in mssql 2005

I want to turn off or turn off as much logging as possible for one of my db's running in 2005.
what commands should I run?  
0
gotaquestion
Asked:
gotaquestion
  • 2
1 Solution
 
MikeWalshCommented:
Assuming you mean transaction logging you can set your database to simple recovery mode.
0
 
MikeWalshCommented:
In SSMS, right click on your database go to properties and change your recovery model to "SIMPLE"... this means that you will NOT be able to recover to a specific point of time.. So if you do a nightly Full Database backup at 11:59pm and something happens to your server at 3:30PM causing catastrophic failure you will only be able to recover your database to the state the night before.

If this is acceptable, then you can do that..

The questions I have are:

1.) What do you mean by logging? If it is transaction logging than do above.. (You will still be logging activity to a transaction log but it will be truncated on regular intervals.. This is the way SQL works to protect you in the event of a suddent stop your server or a desire to rollback a transaction... you can't stop that but you can stop how long it is kept and to what degree it is logged by changing to SIMPLE recovery mode)

2.) What is the reason? If it is performance, you need to look at a bigger picture to improve this.
0
 
gotaquestionAuthor Commented:
i have a giant 300GB db that grows 2 gigs a day from iis logs.  if it crashes I can just re import the iis log itself.  So I don't need the extra transactional logging - should lower my i/o's
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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