SQL Databases are marked Suspect. The SQL error log contains "The log scan number () passed to log scan database is not valid"
Struxureware Power Monitoring
Power Monitoring Expert
SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016
This is generally caused by a corrupt LDF file.
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
To correct, the databases can be rebuilt using the following script replacing DBName with the database name.
ALTER DATABASE DBName SET EMERGENCY
ALTER DATABASE [DBName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKDB (DBName, REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS
EXEC sp_resetstatus DBName
** see attachment containing the SQL script text