Changing log file size

[melbert2002]

Hello all,
I have a couple of quick questions. I have a production DB that is about 120GB while the log file is sitting at 30MB. We are thinking about changing the log size to 1GB, can we do this while the server is running? Also with the size of the DB at 120GB, what is the recomended size of the Log Files?

Thanks

Mel

 

[ptheriault]

yes you can do this without having to shutdown or restart SQL. However,
The size of your log file is directly relaited to how many transactions your database performs. Do you have your log set to autogrow? what is the recovery model of the database? If it is 'FULL' recovery are you backing up your log?

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[onpnt]

why do you want to change the tan log now? Does it commonly grow beyond the initial size? I would think as long at the log is set properly for growth there is no need to alter the initial size of it. To come up with recommendations on teh log file size would have to take into effect the amount of transactions that are going against the DB that are logged. Is this a rarely updated DB or does it get updated/deleted/added often?

you answer to changing it online is yes, you can change the log file size while the DB is online

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[onpnt]

Should have hit refresh before submitting mine. apologies for doubling up

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]