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 |
|
wisertime
Starting Member
28 Posts |
 Posted - 2008-05-21 : 15:07:59
|
| I know I can't do this, but I hear of TRUNCATE LOG ON CHECKPOINT option. where do I find this to turn these off during large migration? thank you. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-21 : 15:12:45
|
| Just disable your transaction log backup job and switch your recovery model to SIMPLE. SQL Server will still use the transaction log. There is no way to avoid this. It just depends on what your recovery model is that will change if the transactions are stored after they have completed.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-21 : 15:15:37
|
| "where do I find this to turn these off during large migration?"What do you mean by large migration here? |
|
|
|
wisertime
Starting Member
28 Posts |
Posted - 2008-05-21 : 15:16:36
|
We are migrating large amounts of data that is filling up the logs. quote:
Originally posted by sodeep
"where do I find this to turn these off during large migration?"What do you mean by large migration here?
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-21 : 15:21:37
|
| Then do the migration in smaller batches so that there is minimal data in the transaction log.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
|
|
|
Turn off Transaction Logs