Post reply

Corruption of the file format .mdf

  • May 19, 2018 at 3:48 am

    #340507

  • I had a problem. Whileworking in MS SQL Server was made to emergency restart the computer. After reboottried again to run the file, but nothing happened. There is a possibility ofdamage to the database, the program marks the file base in gray. The format ofthe file is mdf. What to do? Is it possible to get well?

  • May 19, 2018 at 4:02 am

    #1991114

    I'm 99% positive that this has been posted before (I recall finding the idea of an MDF getting well again (it had a cold? 🙂 ) quite amusing).

    The answer was (surprise!) to download/buy a specific application to fix the problem. I've flagged this as spam in anticipation.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • May 19, 2018 at 4:05 am

    #1991115

    Found it! https://www.sqlservercentral.com/Forums/1935691/Corruption-of-the-file-format-mdf#bm1955086

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • May 28, 2018 at 3:54 am

    This was removed by the editor as SPAM

  • May 28, 2018 at 4:08 am

    #1992100

    kentsteve207 - Saturday, May 19, 2018 3:48 AM

  • I had a problem. Whileworking in MS SQL Server was made to emergency restart the computer. After reboottried again to run the file, but nothing happened. There is a possibility ofdamage to the database, the program marks the file base in gray. The format ofthe file is mdf. What to do? Is it possible to get well?

  • Solutionfor this problem is quick and it is the following (Execute SQL in Given Order):
  • 1.    Connect to yourdatabase server using Microsoft SQL Server Management Studio

    2.    Execute the followingSQL script in given order: 

    NOTE:replace [DatabaseName] with your database name

    1.    -- This query willrollback any transaction which is running on that database

    2.    -- and bring SQLServer database in a "single user" mode

    3.    ALTER DATABASEMicrosoftDynamicsAX SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    4.     

    5.    -- Marking databaseREAD_ONLY, disable logging,

    6.    -- and limitingaccess only to members of the sysadmin fixed server role

    7.   ALTER DATABASEMicrosoftDynamicsAX SET EMERGENCY

    8.    

    9.    -- Checks thelogical and physical integrity of all the objects in the specified database

    10.DBCCcheckdb(MicrosoftDynamicsAX)

    11.

    12.-- In case ofsimple failure then we can use allow data loss option to recover Database

    13.

    14.--  DBCC CheckDB (MicrosoftDynamicsAX,REPAIR_ALLOW_DATA_LOSS)

    15.

    16. -- Set databaseaccessibility to it's original state, allowing all logins

    17.ALTER DATABASEMicrosoftDynamicsAX SET MULTI_USER

    18. you can try to use mdf repair tool - 

    http://www.mdf.repair/

    19.EXECsp_resetstatus MicrosoftDynamicsAX

  • May 28, 2018 at 5:56 am

    #1992104

    kentsteve207 - Saturday, May 19, 2018 3:48 AM

  • I had a problem. Whileworking in MS SQL Server was made to emergency restart the computer. After reboottried again to run the file, but nothing happened. There is a possibility ofdamage to the database, the program marks the file base in gray. The format ofthe file is mdf. What to do? Is it possible to get well?

    • Do you have a recent backup?
    😎

  • May 28, 2018 at 6:07 am

    #1992106

    Thom A - Saturday, May 19, 2018 4:05 AM

    Found it! https://www.sqlservercentral.com/Forums/1935691/Corruption-of-the-file-format-mdf#bm1955086

    Followed your link, looks like the same thing with a slight variation. Well spotted.

    ...

  • June 18, 2018 at 11:17 pm

    This was removed by the editor as SPAM

    • Viewing 8 posts - 1 through 7 (of 7 total)

    You must be logged in to reply to this topic. Login to reply