Restoration of SQL base.

Asked by GerardLefebvre92

Good day.
Question:
SQL server of 2000 Entrpraise. There is a database in which removed certain records 2 days ago. I will specify. I Know what period and what data was beaten deleted. For an example we had a firm with certain ID. Somebody decided that we do not work with this company up and removed the firm from "Contractors". Within 2 days it was actively recorded information. Two days later this employee decided to restore the company adding the old firm under the new ID. Accordingly, the database includes a new ID, and there is no movement, but very necessary. Now these remote data should be returned back. Backup for every day in the morning at 6.00. Mode of copying of FULL. The program interface at us occurs through Access. Some solutions:
1. Is it possible with standard tools SQL to solve this problem?
2. Have a Log file LDF. Is it possible to recover data from it. And how? I read about different utilities which restore information from this file. Is it possible to use them to recover the data I need? And which ones would you recommend? Thank you in advance for a response.

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu Edit question
Assignee:
No assignee Edit question
Solved by:
TimothyCarr
Solved:
Last query:
Last reply:
Revision history for this message
actionparsnip (andrew-woodhead666) said :
#1

What is the output of:

lsb_release -a; uname -a; dpkg -l | grep -i sql

Thanks

Revision history for this message
Best TimothyCarr (timothycarr) said :
#2

You can read some useful information here:
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1914-restore-the-sql-server-database
You can restore the database in two ways:
If I understand correctly, you have to have two bases. There is a Base 1 in which there are reliable data. There is a Base 2 in which is not the correct data. Do the following:
1. Restore Database 1. In the program find all the documents on company ID. Copy them into an intermediate database in Access.
2. Restore Base 2. In the program open the SQL base and manually add all entries from intermediate base. Check it out. Should all work.
You can try other way if this doesn't work. Use the utility of Recovery Toolbox for SQL Server. It perfectly restores bases especially from backup. You will find here
 https://sql.recoverytoolbox.com/

Revision history for this message
GerardLefebvre92 (gerardlefebvre92) said :
#3

Thanks TimothyCarr, that solved my question.

Revision history for this message
GerardLefebvre92 (gerardlefebvre92) said :
#4

solved! thanks!

Revision history for this message
actionparsnip (andrew-woodhead666) said :
#5

Please don't ask for Windows support here. This is Ubuntu support only