Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NgKH
Starting Member
15 Posts |
 Posted - 2003-03-06 : 10:53:20
|
| I have a database called it DB1 that is used to extract various tables and records from other databases and do transformation on various records and then load these tranformed records to another databaseKnowing this database does not require the use of any logging, since the main purpose is to do transformation on records, How am I to go about minimizing / disable writing to Transaction Log to get a performance increase? Or Any recommendations on having a performance boost in this case on DB1? |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-03-06 : 11:00:12
|
| Transaction log is used for recovery purpose.If you don't need to recovery to a point in time you can minimizing the use of t-log by setting the recovery model to simple if it's SQL 2K or set the option "truncate log on checkpoint" to true if it's SQL 7.0. |
 |
|
|
|
|
|
Minimize / disable writing to Transaction Log