T
Tim Greenwood
We just discovered that the "temp' database ASPState is in full recovery
mode. Is this necessary? Seems ridiculously overkill seeing that when we
reboot the sql server machine we really don't need asp state to remain
persistent. Also causes our tlog to be unnecessarily large.....
Is it safe to change this to Simple ????
Thanks for any input.....inquiring minds are waiting for me to answer
mode. Is this necessary? Seems ridiculously overkill seeing that when we
reboot the sql server machine we really don't need asp state to remain
persistent. Also causes our tlog to be unnecessarily large.....
Is it safe to change this to Simple ????
Thanks for any input.....inquiring minds are waiting for me to answer