Skip to Content
0
Former Member
Nov 27, 2015 at 12:40 PM

How To Repair A IFSERV Database In MS SQL

291 Views

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.