MS SQL Server data recovery software test-comparison of the number of records of export results

1. Testing purpose: MS SQL Server data recovery software is a tool to restore the faulty database, which is designed to solve the data recovery of the bad database. The most basic recovery function of this tool is that it can recover any good database data without deviation under normal circumstances, but in practice, the databases of various applications have different usage scenarios and development environments, and there are slight differences. software recovery to take into account a variety of details, it is inevitable to miss some key details, resulting in the recovery results may not reach 100%. Therefore, the database recovery test comparison can get the corresponding improvement methods and improve the software quality.

Second, testing steps: to test a good database, we will come into contact with a variety of application databases in the actual data recovery business. In these databases, there are bad databases and bad database backups (good backups). The database source of our test is these good backup libraries. With these good backup databases, you can accurately compare the recovery results. The test steps are as follows:

1. Attach or restore the good database backup to the MS SQL Server database to get a healthy test database.

2. Stop the MS SQL Server service, COPY the database obtained in the first step, and then start the MS SQL Server service. The database files from COPY are used for opening and reading of MS SQL Server data recovery software.

3. Open the database from COPY with MS SQL Server data recovery software and import the data into a new database.

4. Figure: a good database name is "UFDATA_006_2015_ cool", and the exported database name is "UFDATA_006_2015_ cool _ out"

5. After the data is imported, the data comparison test can be carried out. The export result comparison steps are as follows:

A. Create a new database, named T, as follows:

Create two tables to store the table names and records of "UFDATA_006_2015_ cool" and "UFDATA_006_2015_ cool _ out": the table statement is as follows

CREATE TABLE [T]. [dbo]. [UFDATA_006_2015_ cool _ Count] (

[Name] nvarchar NULL

[num] nvarchar NULL

) ON [PRIMARY]

CREATE TABLE [T]. [dbo]. [UFDATA_006_2015_ cool _ out_Count] (

[Name] nvarchar NULL

[num] nvarchar NULL

) ON [PRIMARY]

After the completion of the table, it is as follows:

B. Build a statement to get the number of table records:

Use UFDATA_006_2015_ is so cool.

Select 'use UFDATA_006_2015_ is so cool.

Insert into [T] .[ dbo] .UFDATA _ 006 cool 2015 _ Count select object_name ('+ convert (nvarchar,id) +'), count (*) from [UFDATA_006_2015_ cool]. [dbo]. ['+ name+']'

From sysObjects where xtype='U' order by id

Get all the table record acquisition statements in the UFDATA_006_2015_ cool database, insert the table name and record into [T]. [dbo]. [UFDATA_006_2015_ cool _ Count] table, add and copy the table executed by the above SQL statement, and then run, you can get the data of the table [T]. [DBO]. [UFDATA _ 006 cool 2015 _ cool _ Count]

Use UFDATA_006_2015_ is so cool _ out

Select 'use UFDATA_006_2015_ is so cool _ out

Insert into [T] .[ dbo] .UFDATA _ 006 cool 2015 _ out_Count select object_name ('+ convert (nvarchar,id) +'), count (*) from [UFDATA_006_2015_ cool _ out]. [dbo]. ['+ name+']'

From sysObjects where xtype='U' order by id

Execute as above

A statement that gets the number of records in each table

Insert the number of records for each table into the newly created table

C. Compare tables with different records

A table with the same number of records

SELECT A. [Name]

, A. [num]

, B. [Name]

, B. [num]

FROM [T]. [dbo]. [UFDATA_006_2015_ cool _ Count] A, [T]. [dbo]. [UFDATA_006_2015_ cool _ out_Count] B

Where A.Name=B.Name and A.num=B.num order by convert (int,A.num) desc

A table with more records than the exported result

SELECT A. [Name]

, A. [num]

, B. [Name]

, B. [num]

FROM [T]. [dbo]. [UFDATA_006_2015_ cool _ Count] A, [T]. [dbo]. [UFDATA_006_2015_ cool _ out_Count] B

Where A.Name=B.Name and A.num > B.num order by convert (int,A.num) desc

A table with fewer records than the exported result

SELECT A. [Name]

, A. [num]

, B. [Name]

, B. [num]

FROM [T]. [dbo]. [UFDATA_006_2015_ cool _ Count] A, [T]. [dbo]. [UFDATA_006_2015_ cool _ out_Count] B

Where A.Name=B.Name and A.num