ms sql server recovery pending problem solved

ms sql server recovery pending problem solved

use master

ALTER DATABASE DATABASENAME SET SINGLE_USER

DBCC CHECKDB (DATABASENAME , REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE DATABASENAME SET MULTI_USER

ALTER DATABASE DATABASENAME  SET ONLINE