One day I noticed that my SQL Server and SQL Agent was automatically shut down. Doing a quick investigation, I believed that there was no user hand on it for that sin and checking the event viewer I got this error during that period of time when the sql was down.
SQL Server mush shut down in order to recover a database(database ID 2). The database is either a user database that could not be shut down or a system database. Restart SQL Server. If the database fails to recover after another startup, repair or restore the database
I saw a kinda error which was a bug in SQL Server Bug #518 but with the hotfix provided it seems it was already fixed but was only for 32 bit version and did not find any for 64 bit version.
The current version of My SQL Server is: "Microsoft SQL Server 2005 - 9.00.4285.00 (X64) Feb 8 2010 23:31:46 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) "
Any ideas would be appreciated.