Question

Locked

Restoration of SQL base.

By gioacchinolupi ·
Tags: Windows, Software
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.

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Re: Restoration of SQL databases

by kramer_larry In reply to Restoration of SQL base.

I would suggest this excellent and most widely used SQL repair tool that helped us in repairing and restoring SQL database files successfully: http://www.serversdatarecovery.com/sqldatabase.html

A free trial version is also available to check its efficiency !

Larry

Collapse -

Restoration of SQL base

by RobertKnight83 In reply to Restoration of SQL base.

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/

Collapse -

Restore SQL Database

by harrypeter36 In reply to Restoration of SQL base.

Some time every database user have to face this issue but Kernel for SQL Database Recovery Software is best, simple, secure and effective Software to solve this issue. It solve or fix database issues with 100% accuracy. It can recover or restore corrupt and delete table, triggers, keys, indexes etc. it is supported by all SQL Server versions. Get more ideas and download free trial here - http://www.sqlrepair.org/

Collapse -

Use SQL Database Recovery Software

by Williamqstewart In reply to Restoration of SQL base.

Use SQL database recovery software repairs corrupt MDF file of the SQL Server database created all the SQL Server including 2012/2000/2005/2008/2008 R2 and gracefully recovers SQL XML data type files also. Read more details from here: http://www.recoverydeletedfiles.com/sql-database-recovery-software.html

Collapse -

Restore deleted data from MDF and Log file easily

by Enriquemallon In reply to Restoration of SQL base.

Well to recover deleted data from the table of the SQL database and log file the use of SQL Server recovery manager is beneficial which recover overall database and provide option to analyze the log file for recovering the data. Must get it from here:- http://www.dbpros.org/sql-server/

Collapse -

Repair Sql databse

by Petemartinezs In reply to Restoration of SQL base.

Properly working of SQL Server is more important to every SQL Database user but if you are facing any types of file corruption issue than download Sql Database Repair Tool which can easily get corrupt or damaged due to many reasons such as corrupt database file header, power failure and sudden application shutdown and Exceeded limit of SQL database size, then you can fix corrupt SQL database issue. To know more visit:- http://www.filesrecoverytool.com/sql-database-repair.html

Collapse -

SQL Database Recovery Tool.

by willsionclark In reply to Restoration of SQL base.

More reliable perfect sql database recovery software, That software easy to recover all tables, stored procedure, functions, views, rules, triggers and associated Primary Key, Unique keys, data types & all other components. To know more detail click here - http://www.server.sqldatabaserecovery.org

Back to Windows Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums