kcwallace Posted June 15, 2006 Posted June 15, 2006 I have a SQL Server 2000 database engine. I was curious what types of thing are added to the Transaction Log? I was prompted to ask this question after seeing the properties on a database and noticed the data file was ~500 MB while the Transaction Log was ~900 MB. Quote Go Beavs!!!
Administrators PlausiblyDamp Posted June 15, 2006 Administrators Posted June 15, 2006 The log contains a list of changes since the last backup, it is used by SQL to recover changes that may otherwise be lost due to system failures etc. The log can also give you flexability with your backup / restore strategies as it can be backed up frequently without imposing too much in th way of overheads on your system. If you really, really, really don't need it then you can set the DB to simple logging and it will not be used. However bear in mind you almost definately will regret this on a production server. The best way to mange it's size is to mke sure you are doing regular online SQL backups as the default is to clear the log on a succesful backup. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.