ALTER DATABASE YourDatabaseName SET EMERGENCY; DBCC CHECKDB ('YourDatabaseName') WITH NO_INFOMSGS; -- If repair is needed: ALTER DATABASE YourDatabaseName SET SINGLE_USER; DBCC CHECKDB ('YourDatabaseName', REPAIR_ALLOW_DATA_LOSS); ALTER DATABASE YourDatabaseName SET MULTI_USER; If none of the above works, restore the last full backup followed by all transaction log backups:
ALTER DATABASE YourDatabaseName SET EMERGENCY; Then rebuild the log: sql database pending recovery
ALTER DATABASE YourDatabaseName REBUILD LOG ON (NAME=YourDatabaseName_log, FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\YourDatabaseName_log.ldf'); Finally, take the database online: ALTER DATABASE YourDatabaseName SET EMERGENCY