Download address and instructions for Log Explorer for SQL Server v4.0.2

Title:LogExplorerForSQL Server v4.0. 2 and instructions for use
Time:2012-08-09
Location: Shenzhen

Source: http: // Topic.csdn.net / U / 20090305 / 00 / 849723bf - 74ad - 495f - 8fc6 - 22d2describeb10.html? Seed = 1633183628
*/

1 Lumigent Log Explorer For SQL Server v4. 0.2 Special Edition
HTTP: // Down.chinaz.com / Soft / 7887 . Htm
Log Explorer For SQL Server 4.2 Registration Code
Wv5rc - Uxvpz - E33 - Nr4694qs2

2 , Log Explorer For SQL Server v4. 0.2
RegisterProgram(The compressed file has a registration machine)
Open Log Explorer File => Attach Log File -> Select Server and login Mode -> Connect ->
Select Database -> Attach -> Browse in the left-side dialog box -> View Log -> You can see the log record.
Click" View DDL commands contains many drop Table Command
Click the "undo" button below to generate the table structure Statement ( Create Table ....)
Click the "Salvage" button below to generate the insert Statement ( Insert Into ... Values ....)
To restore the log, right-click the log record undo transation. -> Select save file name and Path -> Then open the file and run t in the query analyzer. - SQLCodeYou can.

For example, if log is deleteTable Where... The generated file code is insertTable....

Log Several questions about using Explorer
1 ). The database is backed up completely, differently, and in logs.
Deleted non-active entries in the transaction log are selected during Backup.
When I try to view logs with Log Explorer
No prompt Log Recorders found that match the filter, wocould you Like To View Unfiltered data
Select Yes and you will not be able to see the record.
If you do not select to delete non-active entries in the transaction log
Log Explorer can be used to view logs.
2 ), Modified part of the data in one of the tables. Log Explorer is used to view logs and restore logs.
3 ), And then restore the backup. (Note: the recovery is to disconnect Log Explorer from the database or connect to other data,
Otherwise, the database is in use and cannot be recovered)
After restoration, Log Explorer prompts No Log Recorders found that match the filter, wocould you Like To View Unfiltered data
If yes is selected, the log record modified in 2 is not displayed, so the restoration cannot be performed.
4 ). Do not use the SQL backup function to back up your logs.
The correct backup method is:
Stop SQL Service, copy data files and log files for file backup.
Start the SQL service and use Log Explorer to restore data.
5 ). If the Log Recovery Model of your database is simple, you cannot use Log Explorer to recover the database.
6 ), Log Explorer must be installed on the SQL Server server on which the database is to be restored, or the server is installed on the SQL Server server, and the client is installed on the operating computer for data recovery.

3 If the data volume is large and the drive and cluster are used, the genuine Veritas is installed, which is a good way to restore data.
The following are important new features of the software:
1 ), Disaster recovery drill (disaster recovery fire drill) -- Ability to freely test, plan and test disaster recovery plans without interrupting the production process.
2 ), Cluster Simulator) -- You can test the application failover scheme to verify the availability of the application and check whether the application is migrated to the most appropriate server based on the planned failover policy and application requirements.
3 ), Global Cluster options (Global Cluster Option ) -- When the availability requirement is migrated from local to wide-area disaster recovery, it can be quickly and easily upgraded to any architecture.
4 ), Instant access to copy data -- When copying data, you can instantly access the data, which only occupies part of the available storage capacity of the customer.
5 ), Volume replication Advisor (Volume Replicator Advisor) -- Accurately analyzes bandwidth requirements to ensure application optimization.

4 some data restoration experiences:
1 ). You must perform hot backup, daily backup, monthly backup, annual backup, and data replication on both servers, exception record and other work can be done in a timely manner when data is lost.
2 ) if the disk damage is incorrect or the database is deleted by mistake, you can use software such as easyrecovery or recover4all to restore deleted or damaged files and recover data.
3 ) if the network is disconnected from the replication operation due to natural factors, we recommend that you only manually" CREATE "a batch of data to compensate for data loss, generally, data similar to latitude (such as time and region) is selected.