Restoration of SQL base.
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: