Hi,
Due to power failure, SAP Sudden down unfortunately. After Re started server SAP Can not able to login, unfortunately SAP Foreclosure Automatically.
I tried to repair IFSERV Can not able to repair. Can you please guide me any possibilities.
Note : In SQL Server, IFSERV (Emergency) like that showing.
Trying to use this query & Repair
XEC sp_resetstatus [CSS_DB];
ALTER DATABASE [CSS_DB] SET EMERGENCY
DBCC checkdb([CSS_DB])
ALTER DATABASE [CSS_DB] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([CSS_DB], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [CSS_DB] SET MULTI_USER
Not Possible to recover back.