cancel
Showing results for 
Search instead for 
Did you mean: 

How To Repair A IFSERV Database In MS SQL

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Data from corrupt mdf file can be recovered by following methods:

Repair MDF file with DBCC CHECKDB: Microsoft offers a command that is known as DBCC CHECKDB, when you run this then it try to detect & fix all the possible error message. If it fails to fix error message then it suggest repair clause. Re-run the command with suggest repair clause. Your problem might be solved. But, you may loss some amount of data after this.

Former Member
0 Kudos

You should try any third party tool in order to repair a corrupt or damaged SQL MDF File, for more visit: http://sqlmdf.filerepairtool.net