Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2012-01-02 : 23:45:52
|
| Hi,how do i check size of sharepoint database log file and how do i reduce / shrink log file size.thx |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-01-03 : 15:10:58
|
| Why do you think you need to do this? The log file should be maintained at a steady size - as long as you are backing up the transaction log frequently (e.g. every 15 minutes). If your database is in simple recovery model, the transaction log can't be backed up - and it will grow out to the size it needs to be for daily operations. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
check and reduce size of log file