RATE THIS ANSWER
0
Click to Vote:
0
0
Your database is in the process of checking the database before bringing it online.
There's no way to stop it. It's going through the log committing completed transactions and rolling back aborted transactions.
You should NEVER detach the database and delete the log file. If you don't need point in time restores then change the database from FULL recovery to SIMPLE recovery.
You should also disable the auto-shrink feature. This is just messing up your performance by fragmenting your hard drives.
Last Answered:
Sep 29 2009 9:04 PM GMT by Mrdenny 
46735 pts.