|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Transaction Log nearest 3GI found the Transaction Log of DB in my SQL server nearest 3G
how can i keep the transaction logs around 1G only?? Currently, I set "automatically grow file by percent" and "Unrestricted file growth" Now, I have 3G Transaction Log, if I set to "restricted file growth to 1G", will the database corrupt?? Thanks in advanced. > Now, I have 3G Transaction Log, if I set to "restricted file growth to 1G", No. But of the log is full, all modifications will generate an error message (error number 9002).> will the database corrupt?? Are you doing regular transaction log backups? If no, set the recovery model of the database to simple. -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "beachboy" <steam***@hellokitty.com> wrote in message news:%23daBSCNHGHA.532@TK2MSFTNGP15.phx.gbl... >I found the Transaction Log of DB in my SQL server nearest 3G > how can i keep the transaction logs around 1G only?? > > Currently, I set "automatically grow file by percent" and "Unrestricted file > growth" > Now, I have 3G Transaction Log, if I set to "restricted file growth to 1G", > will the database corrupt?? > > Thanks in advanced. > > Hi!
Do please check this article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;272318. -- Show quoteHide quoteDejan Sarka, SQL Server MVP Mentor, www.SolidQualityLearning.com Anything written in this message represents solely the point of view of the sender. This message does not imply endorsement from Solid Quality Learning, and it does not represent the point of view of Solid Quality Learning or any other person, company or institution mentioned in this message "beachboy" <steam***@hellokitty.com> wrote in message news:%23daBSCNHGHA.532@TK2MSFTNGP15.phx.gbl... >I found the Transaction Log of DB in my SQL server nearest 3G > how can i keep the transaction logs around 1G only?? > > Currently, I set "automatically grow file by percent" and "Unrestricted > file > growth" > Now, I have 3G Transaction Log, if I set to "restricted file growth to > 1G", > will the database corrupt?? > > Thanks in advanced. > >  |
|||||||||||||||||||||||
Other interesting topics