Gail - CHECKDB found 0 allocation errors and 0 consistency errors.
Brad - The database isn't restored to another environment, but I also heard this could cause it to go into single-user mode.
It could be that the server needs more RAM. How can I confirm this?