CN108932312A - A kind of snapshot verification method and device based on sql server database - Google Patents
A kind of snapshot verification method and device based on sql server database Download PDFInfo
- Publication number
- CN108932312A CN108932312A CN201810638215.4A CN201810638215A CN108932312A CN 108932312 A CN108932312 A CN 108932312A CN 201810638215 A CN201810638215 A CN 201810638215A CN 108932312 A CN108932312 A CN 108932312A
- Authority
- CN
- China
- Prior art keywords
- snapshot
- data
- destination disk
- destination
- disk
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
Abstract
The invention discloses a kind of snapshot verification methods based on sql server database, include the following steps：Snapshot is created to several destination disks or executes timing snapshot construction strategy；Create respective database and tables of data simultaneously in several destination disks；After executing data manipulation to destination disk, record executes data in the destination disk at data manipulation time point；Snapshot is created to destination disk, records the moment destination disk snapshot；After the completion of upper snapshot creation task, repeats record and execute data and snapshot in the destination disk at data manipulation time point；According to destination disk snapshot record sequence rollback, successively compare whether the Data Matching with same time point, if matching, snapshot functions are normal, if mismatching, snapshot functions are abnormal.It may be implemented to make up the blank of the snapshot verification method based on database application field to the verifying of storage snapshot functions authenticity and completeness.
Description
Technical field
The present invention relates to technical field of memory, especially a kind of snapshot verification method based on sql server database and
Device.
Background technique
With the arrival of big data era, data have become enterprise, mechanism and personal most important wealth.And data set
In have become trend of the times, more and more enterprises all select self-built (cloud) storage system, or directly Data Migration to cloud.
Online data backup is carried out by snapshot at present and is restored, becomes one indispensable function of on-line system, receives producer
With the favor of client.
When storing equipment and application failure or file corruption occurring, snapshot can carry out quick data recovery, by data
Restore the state at some available time point.Another effect of snapshot is to provide another data access for storage user
Channel, when former data carry out application on site processing, the accessible snapshot data of user can also be tested etc. using snapshot
Work.The importance of snapshot proposes huge dependence and challenge to the authenticity and completeness of snapshot.
Summary of the invention
The object of the present invention is to provide a kind of snapshot verification method and device based on sql server database, realization pair
Store the verifying of snapshot functions authenticity and completeness.
To achieve the above object, the present invention adopts the following technical solutions：
First aspect present invention provides a kind of snapshot verification method based on sql server database, including following step
Suddenly：
Snapshot is created to several destination disks or executes timing snapshot construction strategy；
Create respective database and tables of data simultaneously in several destination disks；
After executing data manipulation to destination disk, record executes data in the destination disk at data manipulation time point；To destination disk
Snapshot is created, the moment destination disk snapshot is recorded；
After the completion of upper snapshot creation task, repeats record and execute in the destination disk at data manipulation time point data and fast
According to；
According to destination disk snapshot record sequence rollback, successively compare whether the Data Matching with same time point, if matching,
Snapshot functions are normal, if mismatching, snapshot functions are abnormal.
With reference to first aspect, in a first possible implementation of that first aspect, described that several destination disks are created
Before snapshot or execution timing snapshot construction strategy step, further include：
Sql server is mounted on destination host, installation directory is set in destination disk.
With reference to first aspect, in a second possible implementation of that first aspect, described that several destination disks are created
Snapshot specifically includes：
Create the mark volume of source book；
Create the local replica mapping relations of source book and mark volume；
Start local replica mapping.
With reference to first aspect, described that several destination disks are executed in first aspect in the third possible implementation
Timing snapshot construction strategy, specifically includes：
Set snapshot creation time strategy；
According to snapshot creation time strategy, creation snapshot command is issued to destination disk by CLI；
Create the mark volume of source book；
Create the local replica mapping relations of source book and mark volume；
Start local replica mapping.
With reference to first aspect, described that data behaviour is executed to destination disk in the 4th kind of possible implementation of first aspect
Make, specifically includes：
The operation of insertion/lookup/modification data is executed to the tables of data of destination disk.
Second aspect of the present invention provides a kind of snapshot verifying device based on sql server database, including：
Snapshot policy creation module creates snapshot to several destination disks or executes timing snapshot construction strategy；
Destination disk data operation modules execute the operation of insertion/lookup/modification data to the tables of data of destination disk；
Destination disk data recordin module, record execute data in the destination disk at data manipulation time point；
Destination disk snapshot logging modle creates snapshot to destination disk, records the moment destination disk snapshot；
Destination disk comparison module, according to destination disk snapshot record sequence rollback, successively compare whether with same time point
Data Matching.
The control device of the network service of second aspect of the present invention can be realized each of first aspect and first aspect
Method in implementation, and obtain identical effect.
The effect provided in summary of the invention is only the effect of embodiment, rather than invents all whole effects, above-mentioned
A technical solution in technical solution has the following advantages that or beneficial effect：
The present invention disposes sql server database on snapshot disk, by different time points sql server function
The comparison of application state and data may be implemented to make up based on data the verifying of storage snapshot functions authenticity and completeness
The blank of the snapshot verification method of library application field.Storage system functionality proof scheme is improved, the reliability of storage system is improved,
Improve product competitiveness.
Detailed description of the invention
Fig. 1 is one method flow diagram of the embodiment of the present invention；
Fig. 2 is two method flow diagram of the embodiment of the present invention；
Fig. 3 is apparatus of the present invention schematic diagram.
Specific embodiment
In order to clarify the technical characteristics of the invention, below by specific embodiment, and its attached drawing is combined, to this hair
It is bright to be described in detail.Following disclosure provides many different embodiments or example is used to realize different knots of the invention
Structure.In order to simplify disclosure of the invention, hereinafter the component of specific examples and setting are described.In addition, the present invention can be with
Repeat reference numerals and/or letter in different examples.This repetition is that for purposes of simplicity and clarity, itself is not indicated
Relationship between various embodiments and/or setting is discussed.It should be noted that illustrated component is not necessarily to scale in the accompanying drawings
It draws.Present invention omits the descriptions to known assemblies and treatment technology and process to avoid the present invention is unnecessarily limiting.
Embodiment one
As shown in Figure 1, a kind of snapshot verification method based on sql server database, includes the following steps：
S1, several destination disks are created with snapshot or executes timing snapshot construction strategy.
S2, respective database and tables of data are created simultaneously in several destination disks.
S3, after executing data manipulation to destination disk, data in the destination disk for executing data manipulation time point are recorded；To target
Disk creates snapshot, records the moment destination disk snapshot.
S4, after the completion of upper snapshot creation task, repeat step S3, record execute data manipulation time point destination disk
Interior data and snapshot.
Snapshot creation time is related with the data variation amount of the quantity of volume, the size of volume and volume.After tested, as long as destination disk
Within 10, half an hour can be used as the task time value of patent scene.
S5, according to destination disk snapshot record sequence rollback, successively compare whether the Data Matching with same time point, if
Match, snapshot functions are normal, if mismatching, snapshot functions are abnormal.
Embodiment two
As shown in Fig. 2, a kind of snapshot verification method based on sql server database, includes the following steps：
S1, sql server is mounted on destination host, installation directory is set in destination disk.
S2, several destination disks are created with snapshot or executes timing snapshot construction strategy.
S3, respective database and tables of data are created simultaneously in several destination disks.
S4, after executing data manipulation to destination disk, data in the destination disk for executing data manipulation time point are recorded；To target
Disk creates snapshot, records the moment destination disk snapshot.
S5, after the completion of upper snapshot creation task, repeat step S4, record execute data manipulation time point destination disk
Interior data and snapshot.
Snapshot creation time is related with the data variation amount of the quantity of volume, the size of volume and volume.After tested, as long as destination disk
Within 10, half an hour can be used as the task time value of patent scene.
S6, according to destination disk snapshot record sequence rollback, successively compare whether the Data Matching with same time point, if
Match, snapshot functions are normal, if mismatching, snapshot functions are abnormal.
In step S2, snapshot is created to several destination disks, is specifically included：
S21, the mark volume for creating source book；
The local replica mapping relations of S22, creation source book and mark volume；
S23, starting local replica mapping.
In step S2, timing snapshot construction strategy is executed to several destination disks, is specifically included：
S201, setting snapshot creation time strategy；
S202, according to snapshot creation time strategy, creation snapshot command is issued to destination disk by CLI；
S203, the mark volume for creating source book；
The local replica mapping relations of S204, creation source book and mark volume；
S205, starting local replica mapping.
Data manipulation is executed to destination disk in step S4, is specifically included：
The operation of insertion/lookup/modification data is executed to the tables of data of destination disk.
As shown in figure 3, a kind of snapshot based on sql server database verifies device, including：
Snapshot policy creation module 101 creates snapshot to several destination disks or executes timing snapshot construction strategy；
Destination disk data operation modules 102 execute the operation of insertion/lookup/modification data to the tables of data of destination disk；
Destination disk data recordin module 103, record execute data in the destination disk at data manipulation time point；
Destination disk snapshot logging modle 104 creates snapshot to destination disk, records the moment destination disk snapshot；
Destination disk comparison module 105, according to destination disk snapshot record sequence rollback, successively compare whether with same time point
Data Matching.
Above-mentioned, although the foregoing specific embodiments of the present invention is described with reference to the accompanying drawings, not protects model to the present invention
The limitation enclosed, those skilled in the art should understand that, based on the technical solutions of the present invention, those skilled in the art are not
Need to make the creative labor the various modifications or changes that can be made still within protection scope of the present invention.
Claims (6)
1. a kind of snapshot verification method based on sql server database, characterized in that include the following steps：
Snapshot is created to several destination disks or executes timing snapshot construction strategy；
Create respective database and tables of data simultaneously in several destination disks；
After executing data manipulation to destination disk, record executes data in the destination disk at data manipulation time point；Destination disk is created
Snapshot records the moment destination disk snapshot；
After the completion of upper snapshot creation task, repeats record and execute data and snapshot in the destination disk at data manipulation time point；
According to destination disk snapshot record sequence rollback, successively compare whether the Data Matching with same time point, if matching, snapshot
Function is normal, if mismatching, snapshot functions are abnormal.
2. the snapshot verification method as described in claim 1 based on sql server database, characterized in that described to several
Before a destination disk creation snapshot or execution timing snapshot construction strategy step, further include：
Sql server is mounted on destination host, installation directory is set in destination disk.
3. the snapshot verification method as claimed in claim 1 or 2 based on sql server database, characterized in that described right
Several destination disks create snapshot, specifically include：
Create the mark volume of source book；
Create the local replica mapping relations of source book and mark volume；
Start local replica mapping.
4. the snapshot verification method as claimed in claim 1 or 2 based on sql server database, characterized in that described right
Several destination disks execute timing snapshot construction strategy, specifically include：
Set snapshot creation time strategy；
According to snapshot creation time strategy, creation snapshot command is issued to destination disk by CLI；
Create the mark volume of source book；
Create the local replica mapping relations of source book and mark volume；
Start local replica mapping.
5. the snapshot verification method as claimed in claim 1 or 2 based on sql server database, characterized in that described right
Destination disk executes data manipulation, specifically includes：
The operation of insertion/lookup/modification data is executed to the tables of data of destination disk.
6. a kind of snapshot based on sql server database verifies device, characterized in that including：
Snapshot policy creation module creates snapshot to several destination disks or executes timing snapshot construction strategy；
Destination disk data operation modules execute the operation of insertion/lookup/modification data to the tables of data of destination disk；
Destination disk data recordin module, record execute data in the destination disk at data manipulation time point；
Destination disk snapshot logging modle creates snapshot to destination disk, records the moment destination disk snapshot；
Destination disk comparison module, according to destination disk snapshot record sequence rollback, successively compare whether the data with same time point
Matching.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810638215.4A CN108932312A (en) | 2018-06-20 | 2018-06-20 | A kind of snapshot verification method and device based on sql server database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810638215.4A CN108932312A (en) | 2018-06-20 | 2018-06-20 | A kind of snapshot verification method and device based on sql server database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108932312A true CN108932312A (en) | 2018-12-04 |
Family
ID=64446241
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810638215.4A Pending CN108932312A (en) | 2018-06-20 | 2018-06-20 | A kind of snapshot verification method and device based on sql server database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108932312A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104965771A (en) * | 2015-07-29 | 2015-10-07 | 浪潮(北京)电子信息产业有限公司 | Method and system for verifying remote disaster recovery data consistency |
| CN105653718A (en) * | 2016-01-04 | 2016-06-08 | 浪潮电子信息产业股份有限公司 | Method for ensuring data consistence of database after snapshot in disk snapshot storing environment |
| CN107391307A (en) * | 2017-07-27 | 2017-11-24 | 郑州云海信息技术有限公司 | The method of testing and device of storage area network storage device snapshot functions |
| CN107491363A (en) * | 2017-08-24 | 2017-12-19 | 郑州云海信息技术有限公司 | A kind of Snapshot Method and device of the storage volume based on linux kernel |
-
2018
- 2018-06-20 CN CN201810638215.4A patent/CN108932312A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104965771A (en) * | 2015-07-29 | 2015-10-07 | 浪潮(北京)电子信息产业有限公司 | Method and system for verifying remote disaster recovery data consistency |
| CN105653718A (en) * | 2016-01-04 | 2016-06-08 | 浪潮电子信息产业股份有限公司 | Method for ensuring data consistence of database after snapshot in disk snapshot storing environment |
| CN107391307A (en) * | 2017-07-27 | 2017-11-24 | 郑州云海信息技术有限公司 | The method of testing and device of storage area network storage device snapshot functions |
| CN107491363A (en) * | 2017-08-24 | 2017-12-19 | 郑州云海信息技术有限公司 | A kind of Snapshot Method and device of the storage volume based on linux kernel |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103136243B (en) | File system duplicate removal method based on cloud storage and device | |
| CN106933703B (en) | Database data backup method and device and electronic equipment | |
| US9880762B1 (en) | Compressing metadata blocks prior to writing the metadata blocks out to secondary storage | |
| CN104199750B (en) | A kind of file access pattern method and device of Linux system | |
| US20190196919A1 (en) | Maintaining files in a retained file system | |
| CN110008129B (en) | Reliability test method, device and equipment for storage timing snapshot | |
| US9977706B2 (en) | System and method of validating data for incremental format of backup archive | |
| US8825653B1 (en) | Characterizing and modeling virtual synthetic backup workloads | |
| US10976942B2 (en) | Versioning a configuration of data storage equipment | |
| RU2012154324A (en) | CHECK POINTS FOR FILE SYSTEM | |
| CN104077380A (en) | Method and device for deleting duplicated data and system | |
| US8762347B1 (en) | Method and apparatus for processing transactional file system operations to enable point in time consistent file data recreation | |
| CN106899654A (en) | A kind of sequence value generation method, apparatus and system | |
| CN107818029A (en) | A kind of cloud hard disc data recovers the automated testing method of uniformity | |
| CN113360322A (en) | Method and equipment for recovering data based on backup system | |
| CN107577549A (en) | It is a kind of to store the method for testing for deleting function again | |
| CN107861693A (en) | The OSD procedure deployments method, apparatus and medium of a kind of distributed block storage system | |
| US9146921B1 (en) | Accessing a file system during a file system check | |
| CN106155838B (en) | A kind of database back-up data restoration methods and device | |
| CN104375905A (en) | Incremental backing up method and system based on data block | |
| CN106354587A (en) | Mirror image server and method for exporting mirror image files of virtual machine | |
| CN105868127A (en) | Data storage method and device and data reading method and device | |
| CN106682021A (en) | Database migration method and device | |
| CN106326041A (en) | Second-level recovery method for database | |
| CN109462661A (en) | Method of data synchronization, device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181204 |
|
| RJ01 | Rejection of invention patent application after publication |