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.
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.
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
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.