Unsolved
This post is more than 5 years old
1 Message
0
860
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.
No Events found!
fireberd
9 Legend
•
33.4K Posts
0
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.
BillyRussell
1 Message
0
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
10 Elder
•
30.1K Posts
0
June 16th, 2018 17:00
Potential risk of data theft in link above.
SteffBaxter
1 Message
0
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
10 Elder
•
30.1K Posts
0
June 27th, 2018 04:00
More risky data-theft suspect links above.