SQL, anyone can help?

H

hamfri2016-03-16 22:07:35

Database

hamfri, 2016-03-16 22:07:35

Hello everyone, my SQL server data file has been corrupted and I don't have a database backup. But it seems to me there is no problem in the system log file (ldf). Can anyone please help in recovering data from a corrupted mdf file? Are there any proven methods to return file data from the syslog?

Reply

Answer the question

In order to leave comments, you need to log in

5 answer(s)

A

Artyom Karetnikov, 2016-03-17
@art_karetnikov

If the full recovery model - then everything is possible. It is necessary to backup the log to eight different places as quickly as possible. How can you be sure that ldf is not damaged? Was it on a different drive? How damaged mdf?
What is the size of the database, what exactly needs to be pulled out, is it all or limited to some tables? Little information, it is worth setting out in more detail.

K

Kovalsky, 2016-03-16
@lazalu68

It doesn't seem to work for you

R

Roman Mirilaczvili, 2016-03-17
@2ord

It is worth contacting Microsoft Russia paid support . Or maybe other offices are also engaged in restoring the MS SQL server database.
Maybe they will help to restore the mdf file.

T

travkin2016, 2016-03-30
@travkin2016

Step 1 Right-click “databases” and the “Attach” option to open the dialog box of the selected Database.
Step 2 Click the Add button to open the Locate Database Files dialog box.
Step 3 Enter the full name of the .mdf file as shown in the following example: C:files\Data\my_data.mdf
Click OK. SQL Server Management Studio loads the database from an .mdf file.
All!
Useful sources and a program can also come in
handy /viewtopic.php?f=28&t=541510

T

techpriya, 2019-12-19
@techpriya

Hello
Just check these two apps to solve your problems. It will be helpful for you
Must visit: https://www.systoolsgroup.com/en/recovery/sql.html
2. https://www.systoolsgroup.com/en/recovery/sql-back...