We recently had an incident with a giant sql server log file (transaction log).

From the documentation, the default in sql server is recovery mode full that keeps all transactions in the .ldf until the next backup, so that you can rebuild you .mdf file incrementally from a backup by "redoing" all past transactions.

I'm not really sure this is useful : in your experience what is the use of keeping track of all past transactions? The ability to go back to a given point in time, by rolling back all transaction made after that time?

Apart from this point, do you think there are other downsides with recovery mode simple?

asked Dec 08 '10 at 10:22

olorin's gravatar image

olorin
358848792

edited Jan 04 '11 at 16:00

Sergey's gravatar image

Sergey
123339

I'm not sure if such problem has something to do with DataObjects.Net, but i think no. Are you tried to ask this on stackoverflow.com ?

(Dec 08 '10 at 15:24) Peter Šulek Peter%20%C5%A0ulek's gravatar image

Yes you're right : you can read http://stackoverflow.com/questions/302310/microsoft-sql-server-what-does-it-mean-that-a-transaction-log-is-full for instance. I'm just asking for an advice here because I think Do.net team has a very good knowledge of SQL server. This is absolutely not an high priority support request ;)

(Dec 09 '10 at 07:16) olorin olorin's gravatar image

Ok then, i just respond to your question if you mistakenly place question in wrong forum. And your right DO team has good knowledge of SQL server and they can help you if they found time to answer.

(Dec 09 '10 at 07:32) Peter Šulek Peter%20%C5%A0ulek's gravatar image
Be the first one to answer this question!
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!
toggle preview

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

×573
×9
×1

Asked: Dec 08 '10 at 10:22

Seen: 2,092 times

Last updated: Jan 04 '11 at 16:00

powered by OSQA