Re: begin and end transaction and transaction log
- From: Kruton <wmlyerly@xxxxxxxxx>
- Date: Thu, 13 Dec 2007 08:57:32 -0800 (PST)
Hi Erland,
This sounds like it could be it. I will give it a try. Thanks
On Dec 13, 12:21 am, Erland Sommarskog <esq...@xxxxxxxxxxxxx> wrote:
Kruton (wmlye...@xxxxxxxxx) writes:
This is part of a large OLAP process that runs many times a day. I do
not want to / need to restore to a particular time. I have a dba that
does full backups on a regular basis. I would agree with you to a
certain extent if this were OLTP but it is not.
Then you need simple recovery. What I failed to say is that with simple
recovery, SQL Server will regularly truncate the transaction log, and thus
keep it in check. The one thing to keep in mind is that truncation never
goes past the open transaction, so if you have a long-running transaction
the log can grow never the less.
--
Erland Sommarskog, SQL Server MVP, esq...@xxxxxxxxxxxxx
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- begin and end transaction and transaction log
- From: Kruton
- Re: begin and end transaction and transaction log
- From: Erland Sommarskog
- Re: begin and end transaction and transaction log
- From: Kruton
- Re: begin and end transaction and transaction log
- From: Erland Sommarskog
- begin and end transaction and transaction log
- Prev by Date: Re: Database/Table Design Question - Object/Event Model
- Next by Date: Re: Database/Table Design Question - Object/Event Model
- Previous by thread: Re: begin and end transaction and transaction log
- Next by thread: Help with SQL 2005 performance problems.
- Index(es):
Relevant Pages
|
