| Author |
Topic |
|
Liew2020
Starting Member
26 Posts |
 Posted - 2008-01-20 : 20:28:33
|
| hi,I'm a DBA, recently encounter one weird case.I received an alert on distribution log file running out of space. Everytime, i increase the log file size, it reset back to in original one after several hours. Does anyone know what is going on?Apprecaited if anyone can answer this.Thank You.Regards,Jimmy Liew |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2008-01-20 : 21:11:49
|
| are u taking log backups of dist db? what is recovery model? may need to increase frequency of log bkp |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-20 : 21:23:12
|
| Is db option 'auto shrink' set? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2008-01-20 : 21:32:27
|
ahh good call rmiao.... by the way Liew, auto shrink is almost always a bad idea. |
|
|
|
Liew2020
Starting Member
26 Posts |
Posted - 2008-01-21 : 01:16:15
|
| Thanks rmiao and russell :)I can't find any log backup job for distribution.Other reason why the log being reset to orign size?Regards,Jimmy Liew |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 01:20:17
|
| Did you check recovery mode and db options? Can find them in db properties -> option tab. |
|
|
|
Liew2020
Starting Member
26 Posts |
Posted - 2008-01-21 : 01:34:43
|
| The Recovery mode "Page Verify = TORN_PAGE_DETECTION" and "Auto Shrink = False"any idea?Regards,Jimmy Liew |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2008-01-21 : 09:53:30
|
| when u say the file resets size to original, do u mean what sysfiles SSMS is showing you, or the physical size on disk? how often are u backing up distribution db? is it in simple or full recovery mode? |
|
|
|
Liew2020
Starting Member
26 Posts |
Posted - 2008-01-21 : 20:53:32
|
| russell,I checked it by executing "DBCC SQLPERF(LOGSPACE)" command.I found no backup job running on distribution database.Regards,Jimmy Liew |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2008-01-21 : 22:23:47
|
| What is recover model? it is one of full, bulk-logged, simple.Maybe u have a maint plan backing up all dbs?how r u increasing size? |
|
|
|
|
distribution reset automatically?