C Problems with database restoration

Author: Xiao Kuan] private void restore().

string path = recovery path. text;Obtain the backup path and database name.

string dbname = restore database. text;

string sqlstr1 = "server='" + "';database='"+ Restore the database. text + "';persist security info=true;user id='" + "';password='" + "'";

string sqlstr2 = "use master restore database " + dbname + " from disk='" + path + "' with replace ";If you run without replacing with replace, you may get a "Database has not been backed up in the tail of the log" error.

using (sqlconnection con = new sqlconnection(sqlstr1))

trysqlcommand cmd = new sqlcommand(sqlstr2, con);

con;"The data was restored successfully");

If the restore fails, make sure that the restored item corresponds to the library");

finally

private void bt reverts click(object sender, eventargs e).

restore();

restore database database name from disk='Path and file name' with replace

This is the SQL statement that completely restores the database.

Use the executeNonQuery method of the sqlcommand class in C to execute it.

I don't know what your situation is.

Here's an example. If the database you are using is sqlserver, you can go in and create a database with the same name.

Then restore your database files.

In this way, the table and the data in it are restored.

restore database @name from disk=@path with replace

That's it! Just write your stored procedure in the master database.

Wouldn't you be able to restore it in sqlserver?

Just use EasyRecovery.

This version is a registration-free version and is a very powerful hard drive data recovery software that uses EasyRecovery directly. It can help you recover your lost data. EasyRecovery doesn't write any data to your hardware, it can recover data from hard drives, memory cards, USB sticks, and portable hard drives.

It can help you recover lost data and rebuild the file system.

Is there a backup? Or roll back with logs. What kind of database are you?

If the database has a backup file.

You can restore the database data by restoring the backup file.

Reference: It depends on what kind of database file, general software can not be recovered, it is recommended to find a professional data recovery company, recommend Xi'an Junwang Data Recovery Center, there is a certain study of database files.

It may be that the database you want to restore is in use, and you have to go offline or close the connection.

The role and value of database backup and copy recovery are mainly reflected in the following aspects:

1. Improve the high availability and disaster recoverability of the system, when the database system crashes, there is no way to find the data without database backup.

2. Using database backup to restore the database is the best solution to provide the minimum cost of data recovery when the database system crashes, and the cost will be too great if the customer is asked to fill in the data again.

3. There is no data without everything, database backup is a powerful means to prevent disasters before they occur.

The function and value are one: if the data in the database is destroyed, or if you want to check the original data, you can attach a backup to it, which will take a lot less effort.

Hello, database loss comes very scary since.

Because it involves a lot of commercial things, it will be backed up under normal circumstances, and the database is not a general data recovery for ordinary files, which is relatively easy, but an integrated data package, if it is tampered with, it cannot be imported, so normal backup is a must.

Hope the answer is helpful to you.

If the backup file is corrupted, re-copy the new file and then restore the test.

First, there is the issue of database version.

Second, there is a problem with the backup file.

It is recommended to use SQL scripts.

It can be recovered with recovery software, and you can recover files with anedata almighty. If the partition table is corrupted, repartitioned, and the drive letter cannot be opened, the software can scan out the original partition for recovery in a few minutes. Sometimes when a disk check is done, the normal file becomes the extension is *

chk files, the software can automatically recognize this situation and automatically correct the extension back according to the original file type. This software is especially recommended.

It can be backed up and restored or software restored, occasionally.

Oracle DBA: PRM-DUL disaster recovery tool and schema-level data recovery. PRM-DULFOR Oracle Database Schema-level Oracle Database Data Recovery Manager, or ParnassusData Recovery Manager, is an enterprise-level Oracle database disaster recovery tool.

PRM can restore truncated tables without backup, and can also restore data in Oracle databases that cannot be opened (alter database open failed).

select * from store_record as of timestamp sysdate-1/24/60*40;

The default time of flashback is very short.

sysdate-1 is the day before.

You cut it down and see.

commit? If the archive is not opened, you can try it with flashback query.

I'd love to help you, but I don't get it.

I don't understand it either, so I can make it clearer.