UNSOLVED

CharleyFisher

updated

8 years ago

0

898

June 9th, 2018 16:00

In the database there was an unknown difficult

During operation, an emergency power failure occurred, and my computer was disconnected with the running SQL and open database. After I tried to get through the editing of my ill-fated file, I saw an error - maybe some data is now lost. This information was important to me, and I really want to return it.

  • fireberd

    11 Legend

    •

    33399 Posts

    •

    112848 Points

    773

    0

    Posted June 10th, 2018 05:00

    With a power failure and no backup, recovery of data is usually not possible.  Sorry.

    A sudden power failure and no UPS battery backup is not very wise, especially considering the needed data is not recoverable.

     

    Inspiron 16 5630 Laptop and WD22TB4 Docking Station
    Self-built desktop for recording studio application
  • BillyRussell

    1 Message

    732

    0

    Posted June 16th, 2018 13:00

    Below is the detailed steps you may try to follow.

    Click Start, point to All Programs, point to Microsoft SQL Server, point to ms sql database repair tool, and then click SQL Server Configuration Manager. 

    If you do not have these entries on the Start menu,  SQL Server is not correctly installed. Run Setup to install the  SQL Server Database Engine. 

    • In SQL Server Configuration Manager, on the left pane, click SQL Server Services. The right pane lists several services that are related to  SQL Server. If the  Database Engine is installed, the  Database Engine service is listed as SQL Server (MSSQLSERVER) if it is the default instance; or SQL Server (<instance_name>), if the  Database Engine is installed as a named instance. Unless the instance name is changed,  SQL Server Express installs as a named instance with the name SQLEXPRESS. A green triangle icon indicates that the  Database Engine is running. A red square icon indicates that the  Database Engine is stopped. 

    • To start the  Database Engine, in the right pane, right-click the  Database Engine, and then click Start.

    Reference:

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home

  • ejn63

    12 Elder

    •

    31859 Posts

    •

    156307 Points

    726

    0

    Posted June 16th, 2018 17:00

    Potential risk of data theft in link above.

     

  • SteffBaxter

    1 Message

    610

    0

    Posted June 26th, 2018 19:00

    This is a unique method:
    Step 1. Login to your MySQL server using Secure Shell (SSH).
    Step 2. Repairing MyISAM mySQL Tables/Databases.
    cd /var/lib/mysql/DBNAME
    myisamchk -r -f tables.MYI
    Please note that MyISAM is a default storage engine of MySQL, unless you change it. Mostly MyISAM is set as default engine to check and repair all the tables in the mysql database.
    Once I couldn't know how to be after computer restore by manuals ms sql database repair tool, my friend suggested to read these articles

    http://smallbusiness.chron.com/restore-back-up-onenote-46149.html
    https://support.microsoft.com/en-us/help/825779/how-to-recover-information-in-a-damaged-onenote-section-file

  • ejn63

    12 Elder

    •

    31859 Posts

    •

    156307 Points

    672

    0

    Posted June 27th, 2018 04:00

    More risky data-theft suspect links above.