CODEWITHSUNDEEP
sqlsql-server-2005
koumides
koumides

Reputation: 2504

Transaction Log SQL Server

All,

We often delete many rows from a table and even though we are using set rowcount 10000 most of the times we fill up the Transaction Log. Is there something to do to avoid this problem happening?

Thanks,

M

Upvotes: 1

Views: 313

Answers (2)

marc_s
marc_s

Reputation: 754230

Two things you can do:

  • you can set your database's recovery model to SIMPLE - this will limit the amount of data being logged - that's only part of a fix, however

  • you need to establish frequent transaction log backups - especially just before and just after batch deletes.

This is really more of a sysadmin/DBA question, and thus you'll probably get more and more useful answers on http://serverfault.com.

Upvotes: 1

Burcin
Burcin

Reputation: 985

before and after deleting data; you can run this query to empty transaction log:

dump tran SAMPLE_DB with truncate_only
go

Upvotes: 0

Related Questions