Do a BCP import without growing the T-Log???
Posted on 2003-11-01
We do a BCP import into our database ever morning which causes a 250MB spike in our T-Logs. The data that is getting imported is static, read-only data that is maintained on a separate server.
Is there any way to prevent BCP from logging all of that traffic every morning so I won't have to back it up? There is still other data hitting the database that is worth holding on to the T-logs, so I can't just turn T-logging off, or just delete the logs.