transaction log 1

[aviv]

I have 3 questions
1. I want to restrict the size of the transaction log
how can i avoid a the problem of transaction failure as result of transaction log full?
2. Is there any way that I can decrease the size of transaction log file when manual truncate doesn't do it?
3. I have create 2nd transaction log file how can I drop the first transaction log?
regards
aviv

 

[Giantkiller]

I have a suggestion.. I dont know if this will work in SQL 6 But in Version 7 it seems to work for me..

just right click on your target database, then properties limit the transaction log to whatever megabyte you think should be enough, then on the options tab, set the truncate log on checkpoint to true, i think this should do the trick for you.

then on your third question, try browsing on the stored procedures on the master database, there you will find the stored procedure that can delete the log file that you want.. so i hope this helps.... [sig][/sig]

 

[jnicho02]

Just a quick question...are you guys running Production/live systems out there? If so, can your business cope with losing a whole days work?

The transaction log is there so that in the event of a disaster you can restore you database to virtually the point where it went wrong. If you have no transaction log then you must go back to your last (successful) backup. I say 'successful', because how many of us actually verify that the backup worked by restoring on another machine - this is what you should do if you are really serious.

Only set 'truncate log on checkpoint' to true if this is a development system, a snapshot of a database for reporting purposes, or you don't mind losing loads of work.

Otherwise, the answer to the question is to set the transaction log backups to a higher frequency.

Also, when a transaction log overflows it can cause page count errors. This will make it appear to be full after you have manually truncated it. Always run a dbcc on the database after manually truncating logs. [sig]<p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/jnicho02/>my

home</a><br> [/sig]

 

[opo]

Log Question?
Not sure if this is. I am a VB programmer and I need to know when our DBMA has change the structure of a table,deleted some information, or made ran some update queries. Is there a log that will show what he has done and when or is there a way to notifiy me when it occurs?

 

[tlbroadbent]

opo,

Please post your question in a new thread. This thread is nearly 1.5 years old. Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com