June 30th, 2004, 10:23 AM
|
|
Registered User
|
|
Join Date: Jun 2004
Posts: 8
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
MS SQL Transaction Log Problems
I have a Database with about 100-120 million records. On a daily basis I have to import and delete anywhere between 5-30 million records. As you can Imagine the transaction log is insane. Is there anyway for me to tell SQL to ignore making the transaction log on certain queries? Basicly the daily import and delete.
I can shrink the file with no problem after I run the delete statement but killing the disk space on the server.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
