on 11-27-2015 12:40 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.