Re: Recovery log size
2005-12-15 13:34:01
you can look back in the recovery log and see that the log filled at the point
it abandoned the task.
Nothing to be done except to increase the log size.
>>> mbarreto AT DEDICADO DOT COM 12/15/2005 1:30:03 PM >>>
Hi,
I´ve 42 clients configured and in one of them I´ve a missed status when i
try to backup because of the following error:
12/09/2005 08:22:22 ANS1228E Sending of object
'\\server01\c$\WINDOWS\msagent\agentctl.dll' failed
12/09/2005 08:22:22 ANS1316E The server does not have enough recovery log space
to
continue the current operation
if I execute the commando q log f=d I get:
Available Space (MB): 600
Assigned Capacity (MB): 600
Maximum Extension (MB): 0
Maximum Reduction (MB): 588
Page Size (bytes): 4,096
Total Usable Pages: 153,088
Used Pages: 1,900
Pct Util: 1.2
Max. Pct Util: 99.9
Physical Volumes: 4
Log Pool Pages: 128
Log Pool Pct. Util: 5.49
Log Pool Pct. Wait: 0.00
Cumulative Consumption (MB): 218,945.84
Consumption Reset Date/Time: 02/27/04 12:00:06 PM
pct util is very low, how could I resolve the problem?
thanks in advance.
Marcelo
|
|
|