a couple of specific questions:

- is there any way to see how many transactions have to be rolled back/forward during the restore?

- any way to check the startup procedure to see where the time is being used?

- i noticed that the time taken for recovery is less than the time shown in the log:

ie:

10:43:01 - starting up database

10:43:44 - recovery writing checkpoint

10:43:47 - recovery complete in 25 seconds (analysis 8367ms, redo 0ms, undo 9508ms)

this seems inaccurate and the actual log restores only takes 0.05 seconds at most!!

thanks again