I have installed 3 new instances of SQL Server 2012 on a stand alone server. SQL Service is set to automatic on all of them. Yet, suddenly, all the instances have shut down abruptly throwing the following errors.
Need some advice around this issue?
SQL Server must 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.
During undoing of a logged operation in database 'tempdb', an error occurred at log record ID (438:376:163). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.