To solve MSSQL Recovery Pending problem follow the steps
- Stop SQL
- Remove transaction log on this database
- Change database mode to emergency mode and restart database
- After restart run this commands for your database
ALTER DATABASE [DB_Name] SET EMERGENCY;
DBCC checkdb ([DB_Name], REPAIR_ALLOW_DATA_LOSS )
ALTER DATABASE [DB_Name] SET online;
ALTER DATABASE [DB_Name] SET Multi_USER WITH NO_WAIT