sandvine
asked on
MS SQL 2000 does a Roll Forward Recovery Everytime the Services are Stopped.
Hi,
Everytime I restart the SQL Server it insists upon going through a Rollforward recovery which disrupts the operation of the thing for hours. (We have a 60GB database on here) Is there some way to keep it from doing that? Doesn't it have a dirty flag to know when they're not shutdown properly so it only does the recovery then? If anyone out there can help me rid this server of this behaviour it would be greatly appreciated.
Thank you.
Everytime I restart the SQL Server it insists upon going through a Rollforward recovery which disrupts the operation of the thing for hours. (We have a 60GB database on here) Is there some way to keep it from doing that? Doesn't it have a dirty flag to know when they're not shutdown properly so it only does the recovery then? If anyone out there can help me rid this server of this behaviour it would be greatly appreciated.
Thank you.
and maybe look into Trunc Log on Checkpoint?
I am not sure if this can help you or not.
Go to SQL server Enterprise manager.
on the drop down list, go to management, then down down again to currenty activities. then go to process info.
From there you can see what process are being used or what process is sleeping.
Beryl
Go to SQL server Enterprise manager.
on the drop down list, go to management, then down down again to currenty activities. then go to process info.
From there you can see what process are being used or what process is sleeping.
Beryl
ASKER
My cache hit ratio is currently: 72.676%
As for the Trunc Log I frequently backup the transaction log and truncate it.
I attempted to look at what the processes were doing while this 'recovery' was happening and the Enterprise Manager just locks until the it is finished.
Is there any way to keep it from doing the rollforward recovery everytime the SQL service is restarted?
Thank you.
As for the Trunc Log I frequently backup the transaction log and truncate it.
I attempted to look at what the processes were doing while this 'recovery' was happening and the Enterprise Manager just locks until the it is finished.
Is there any way to keep it from doing the rollforward recovery everytime the SQL service is restarted?
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
just my 2 Cents