July 12, 2011 at 8:57 am
Is Microsoft have any tool to recovery from corrupted MDF file?
I search the internet and i can saw the demo version.
Is any way using Microsoft sql server commands, we can recover from corrupted MDF file.
Following sql statement not works on my scanerio.
alter database test
set emergency
go
alter database test
set single_user
go
dbcc checkdb (test, repair_allow_data_loss)
alter database test
set multi_user
go
Is any free tool or Microsoft tool to solve the issue of MDF file.
July 12, 2011 at 9:29 am
This will not work in all circumstances.
Microsoft provide the BACKUP and RESTORE facility as a minimum method of recovering a corrupt database. There is of course the other high availability technologies such as mirroring, clustering, log shipping and replication.
July 12, 2011 at 2:24 pm
What errors are you getting? What's the current status of the DB?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 13, 2011 at 4:30 am
This was removed by the editor as SPAM
July 13, 2011 at 8:17 am
Hi,
Storage is formated and it have the .mdf file and .bkp file.
We recovered the files with some undeleted command. But these files are not working for restore the DB or attach the file to DB.
while use the command:
RESTORE DATABASE TEST FROM DISK='C:\DBrecovery\DBBACKUP\CP.BAK'
WITH REPLACE, CONTINUE_AFTER_ERROR;
Following error message:
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Msg 5243, Level 22, State 13, Line 1
An inconsistency was detected during an internal operation. Please contact technical support.
is any soulation for it
Mathew
July 13, 2011 at 8:39 am
Nope, that's not restorable at all.
You didn't answer my question about the checkDB output...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 13, 2011 at 8:49 am
Dear Gail
How i can check DB, even if i restore or attach file.
Regards
Mathew
July 13, 2011 at 8:56 am
You said in your initial post that the following didn't work:
alter database test
set emergency
go
alter database test
set single_user
go
dbcc checkdb (test, repair_allow_data_loss)
alter database test
set multi_user
go
I asked what errors they gave and what the current database state is.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply