CN108563659A - The synthesized backup method of SQL Server - Google Patents
The synthesized backup method of SQL Server Download PDFInfo
- Publication number
- CN108563659A CN108563659A CN201711481491.6A CN201711481491A CN108563659A CN 108563659 A CN108563659 A CN 108563659A CN 201711481491 A CN201711481491 A CN 201711481491A CN 108563659 A CN108563659 A CN 108563659A
- Authority
- CN
- China
- Prior art keywords
- backup
- database
- time
- snapshot
- instruction
- 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
- G06F11/1448—Management of the data involved in backup or backup restore
-
- 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
- G06F11/1448—Management of the data involved in backup or backup restore
- G06F11/1451—Management of the data involved in backup or backup restore by selection of backup contents
Abstract
The present invention relates to a kind of synthesized backup methods of SQL Server, including：It receives second and creates instruction, shared volume is created using block device storage pool；The instruction of the first snapshot is received, snapshot is carried out to database, obtains database snapshot copy；Decision instruction is received, duplicated record is read, judges whether database carries out synthetic backup for the first time；It, will be in database snapshot duplicate copy to shared volume when database does not carry out synthetic backup for the first time；When database had carried out synthetic backup, obtains copying incremental data relative to the incremental data for backing up generation for the first time and be synthesized in the backup set that backs up for the first time；The duplicated record that client where receiving the database is submitted.The synthesized backup method of above-mentioned SQL Server, other than the complete Database Replica of backup copy for the first time, a backup only backup incremental data every time, saves the time and the consumption for reducing memory space that backup total data is brought later.
Description
Technical field
The present invention relates to microcomputer data processing fields, more particularly to a kind of synthetic backup side of SQL Server
Method.
Background technology
The importance of information age, data safety are self-evident, whether inside computer system failure, or outside is not
Can drag destruction, may all cause damage or the loss of database, lead to irremediable catastrophic effect.For each
To the commercial company that user data is responsible for, data backup is all its unavoidable serious project.
SQL Server are the relevant databases developed by Microsoft, from first version publication in 1988 with
Come, have many decades history, it is integrated with the various product and resource of Microsoft, provide powerful visualization interface,
Highly integrated management development tool and perfect relational data library facility support, is that occupation rate of market is most in the world at present
Height, one of the most widely used Database Systems.
As the database product of a more mature stabilization, SQL Server provide basic backup scenario, including
Complete backup, differential backup, local backup, Log backup and file and filegroup backup etc., database administrator can need
Backup scenario is selected to formulate different backup policy according to own service demand, backup industry production quotient can also be in these sides
The basis of case provides the special service of oneself.
But on the basis of existing basic backup scenario, backed up to SQL Server to occupy there is also backup set
The problem of database larger memory space.
Invention content
Based on this, it is necessary to which the problem of occupying larger memory space for backup set in existing backup scenario provides one kind
The synthesized backup method of SQL Server.
A kind of synthesized backup method of SQL Server, including：
It receives second and creates instruction, shared volume is created using block device storage pool；
By client where the shared volume carry to database, to store the backup set of database；
The instruction of the first snapshot is received, snapshot is carried out to database, obtains database snapshot copy；
Send decision instruction so that database judges whether to have carried out synthetic backup for the first time；
It, will be in the database snapshot duplicate copy to the shared volume when database does not carry out synthetic backup for the first time；
When database had carried out synthetic backup, obtain relative to the incremental data for backing up generation for the first time, by the increasing
Amount data copy is simultaneously synthesized in the backup set backed up for the first time；
The duplicated record that client where receiving the database is submitted.
It creates and instructs in the reception in one of the embodiments, before fast equipment storage pool establishment shared volume
Further include：
It receives first and creates instruction, create block device storage pool；
Preset instructions are received, backup set is pre-set and retains number；
Register instruction is received, the database backed up required for registering.
Further include in one of the embodiments,：
Check whether backup set number is more than that pre-set backup set retains number；
When it is more than that pre-set backup set retains number to detect the backup set number, on erasing time earliest
Backup set.
Further include when database carries out the backup set failure of synthetic backup for the first time, by institute in one of the embodiments,
It states in database snapshot duplicate copy to the shared volume.
In one of the embodiments, when database had carried out synthetic backup, phase is obtained by Documents Comparison algorithm
For backing up the incremental data of generation for the first time.
A kind of synthetic backup device of SQL Server, including：
Second creation module creates instruction for receiving second, shared volume is created using block device storage pool, will be described total
It enjoys being wrapping with and is loaded onto database place client, to store the backup set of database；
Snapshot module carries out snapshot to database, obtains database snapshot copy for receiving the instruction of the first snapshot；
Sending module, for sending decision instruction so that database judges whether to have carried out synthetic backup for the first time；
First backup module, for when database does not carry out synthetic backup for the first time, the database snapshot copy to be copied
In shellfish to the shared volume；
Second backup module, for when database had carried out synthetic backup, obtaining relative to backup generation for the first time
The incremental data is copied and is synthesized in the backup set that backs up for the first time by incremental data；
Receiving module, the duplicated record submitted for client where receiving the database.
Further include in one of the embodiments,：
First creation module creates instruction for receiving first, creates block device storage pool；
Presetting module pre-sets backup set and retains number for receiving preset instructions；
Registration module, for receiving register instruction, the database backed up required for registering.
Further include in one of the embodiments,：
Detection module, for checking whether backup set number is more than that pre-set backup set retains number；
Removing module, for when it is more than that pre-set backup set retains number to detect the backup set number, deleting
Except time upper earliest backup set.
A kind of computer equipment, including memory, processor and be stored in memory grow and can run on a processor
Computer program, the processor realizes the synthetic backup of above-mentioned SQL Server method when executing described program.
A kind of storage medium, is stored thereon with computer program, which is characterized in that the program is realized when being executed by processor
The method of the synthetic backup of above-mentioned SQL Server.
The synthesized backup method and device of above-mentioned SQL Server, in addition to the complete Database Replica of backup copy for the first time
Except, it backs up only backup incremental data every time later, dramatically saves the time that backup total data is brought, and reduce and deposit
Store up the consumption in space.
Description of the drawings
Fig. 1 is the flow diagram of the synthesized backup method of SQL Server in an embodiment；
Fig. 2 is the flow diagram of the synthesized backup method of SQL Server in another embodiment；
Fig. 3 is the structure diagram of the synthetic backup device of SQL Server in an embodiment；
Fig. 4 is the structure diagram of the synthetic backup device of SQL Server in another embodiment；
Fig. 5 is the internal structure schematic diagram of one embodiment Computer equipment.
Specific implementation mode
In order to make the purpose , technical scheme and advantage of the present invention be clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
Fig. 1 is the flow diagram of the synthesized backup method of SQL Server in one embodiment of the invention.As shown in Figure 1,
A kind of synthesized backup method of SQL Server, includes the following steps：
S103, receives second and creates instruction, and shared volume is created using block device storage pool.
Specifically, second create instruction by backup management system management user backup management system initiate, be used for
Realize the operation that shared volume is created using block device storage pool.
Wherein, block device is one kind in I/O equipment, is in the block for store information in fixed size, each block has
The address of oneself can also read the data of certain length, such as hard disk, U disks, SD card etc., storage in any position of equipment
Pond is to store pool server stored copies, shadow copy and one group of disk for transmitting daily record wherein, therefore the present embodiment uses base
In storage area network block device storage pool as backup storage device.
S105, by client where shared volume carry to database, to store the backup set of database.
Specifically, the shared volume created using block device storage pool is that block device storage pool is created that the virtual memory come
Space is located in block device storage pool, the hard disk virtual as one of the host computer where being mounted to database, for storing
The Backup Data of database.
S107, receives the instruction of the first snapshot, carries out snapshot to database, obtains database snapshot copy.
Specifically, snapping technique is a kind of camera work, and with the raising of storage application demand, user needs online mode
Carry out data protection, snapshot be exactly Online storage device take precautions against loss of data one of effective ways, have become disk array,
The standard configuration function of volume manager, file system and RAID controller.Snapping technique is defined as：About
One completely available copy of specified data acquisition system, the copy include that corresponding data at some time point (or perhaps open by copy
The time point of beginning) image, snapshot can be a copy of the data represented by it, can also be one of data duplication
Product.
The effect of snapping technique mainly can carry out online data recovery, when application and trouble or text occur for storage device
Part can carry out timely data recovery when damaging, and data are reverted to the state of snapshot generation time point.Another work of snapshot
With being to provide another data access channel for storage user, when former data carry out application on site processing, user can be with
Snapshot data is accessed, can also carry out the work such as testing using snapshot.
S109 sends decision instruction so that database judges whether to have carried out synthetic backup for the first time.
Specifically, whether backup management system sends decision instruction, database response decision instruction, and to database
Judged through carrying out synthetic backup for the first time.
Data backup Main Patterns include mainly full backup, incremental backup and differential backup etc., wherein incremental backup
It is newly to have been created since hereafter only backup is relative to last backup operation every time based on last backup completely or incremental backup
It builds or updated data, but the data recovery of incremental backup is cumbersome.Must have last full backup and institute
There is incremental backup, once losing or damaging one of those, will result in the failure of recovery, and they must be along from complete standby
The time sequencing of part to incremental backup successively is counter one by one to push away recovery, therefore this just greatly extends recovery time.And this implementation
Synthetic backup in example is to maintain the short advantage of BACKUP TIME of conventional delta backup, both based on the technical of incremental backup
The resume speed that can be improved, and save consumption of the multiple full backup to data and equipment.
S111 will be in database snapshot duplicate copy to shared volume when database does not carry out synthetic backup for the first time.
Specifically, after database, which passes through, to be judged, after not carried out the conclusion of synthetic backup for the first time, by database
It carries out after snapshot in obtained snapshot duplicate copy to shared volume, that is, in deposit block device storage pool, as synthesizing for the first time
The backup set of backup.
S113 obtains, relative to the incremental data for backing up generation for the first time, to increase when database had carried out synthetic backup
Amount data copy is simultaneously synthesized in the backup set backed up for the first time.
Specifically, when database by after judgement, after having been carried out the conclusion of synthetic backup for the first time, and backing up for the first time
Obtained data are compared, and are obtained relative to the incremental data for backing up generation for the first time, and incremental data are copied to standby for the first time
In the backup set of part, and incremental data is synthesized with the data backed up for the first time, i.e., is carried out with database snapshot copy
Synthesis.
S115, the duplicated record that client where receiving database is submitted.
Specifically, the duplicated record that the client database of record where database is backed up, and it is shared by being stored in
Volume can be checked in block device storage pool, while also can be transmitted to backup management system.
The synthesized backup method of above-mentioned SQL Server, other than the complete Database Replica of backup copy for the first time,
It backs up only backup incremental data every time later, dramatically saves the time that backup total data is brought, and it is empty to reduce storage
Between consumption.
In one of the embodiments, when database had carried out synthetic backup, phase is obtained by Documents Comparison algorithm
For backing up the incremental data of generation for the first time.
Specifically, the core of Documents Comparison is exactly that compare two given texts can be the difference between byte stream etc.,
Currently, it is based on editing distance, such as LD algorithms that the difference between the comparison text of mainstream, which mainly has two major classes, one kind,；One
Class is based on Longest Common Substring, such as Needleman/Wunsch algorithms etc..LD algorithms become editing distance algorithm again, are
Become another character string B by being inserted into character, deletion character, substitute character with character string A, then the number of the process operated
Indicate the difference of two character strings.The difference of data twice can be obtained, and then obtain incremental data by Documents Comparison algorithm.
In another embodiment, when database carries out the backup set failure of synthetic backup for the first time, database snapshot pair
Originally it copies in shared volume.
Specifically, backup set failure refers to that database has carried out synthetic backup for the first time, but carries out synthetic backup and obtain
Backup set be damaged, such as situations such as loss of data or imperfect data backup, need to re-start backup, therefore by database
In snapshot duplicate copy to shared volume, as the data set backed up for the first time.
Fig. 2 is the flow diagram of the synthesized backup method of SQL Server in another embodiment.As shown in Fig. 2, connecing
It receives second and creates instruction, further include before creating shared volume using fast equipment storage pool：
S100 receives first and creates instruction, creates block device storage pool.
Specifically, it after the administrator of backup management system logs in backup management system, initiates first and creates instruction, backup pipe
Reason system receives first and creates instruction and respond the first establishment instruction, creates block device storage pool.
S101 receives preset instructions, pre-sets backup set and retains number.
Specifically, preset instructions are initiated after logging in backup management system by the administrator of backup management system, backup management
System receives and responds preset instructions, pre-sets backup set and retains number.The backup set that wherein database is backed up,
It is stored in block device storage pool, it refers to the number retained the backup set stored that backup set, which retains number, beyond guarantor
The backup set of number is stayed to need to delete.
S102 receives register instruction, the database backed up required for registering.
Specifically, the administrator of backup management system is the account that operator distributes backup management system, operator's pipe
The account of reason person's distribution logs into backup management, and database account number is used in combination, and is the number for needing to back up in backup management system
It is registered according to library, and backup policy is set.
In another embodiment, further include：
S117 checks whether backup set number is more than that pre-set backup set retains number.
Specifically, backup management system counts backup set number after receiving duplicated record, obtains backup set
Backup set number is retained number with pre-set backup set and is compared by number.
S119, when it is more than that pre-set backup set retains number to detect the backup set number, on erasing time
Earliest backup set.
Specifically, when it is more than that pre-set backup set retains number to detect the backup set number, to backup set
BACKUP TIME be ranked up, delete the earliest backup of BACKUP TIME.
The synthesized backup method of above-mentioned SQL Server is provided with backup set and retains number, considerably reduces database
The burden of administrator, when it is more than that pre-set backup set retains number to detect backup set number, on erasing time earliest
Backup set, reduce the consumption of memory space.
Fig. 3 is the structure diagram of the synthetic backup device of SQL Server in one embodiment of the invention.As shown in Fig. 3, one
The synthetic backup device of kind SQL Server, including：
Second creation module 303 creates instruction for receiving second, shared volume is created using block device storage pool, by institute
Client where stating shared volume carry to database, to store the backup set of database.
Specifically, second create instruction by backup management system management user backup management system initiate, be used for
Realize the operation that shared volume is created using block device storage pool, the shared volume created using block device storage pool, is that block device is deposited
Reservoir is created that the virtual memory space come, is located in block device storage pool, the host computer conduct being mounted to where database
One virtual hard disk, the Backup Data for storing database.
Snapshot module 305 carries out snapshot to database, obtains database snapshot copy for receiving the instruction of the first snapshot.
Specifically, the effect of snapping technique mainly can carry out online data recovery, when application event occurs for storage device
Timely data recovery can be carried out when barrier or file corruption, data are reverted to the state of snapshot generation time point.Snapshot
Another effect is to provide another data access channel for storage user, when former data carry out application on site processing,
User can access snapshot data, can also carry out the work such as testing using snapshot.
Sending module 307, for sending decision instruction so that database judges whether to have carried out synthetic backup for the first time.
Specifically, whether backup management system sends decision instruction, database response decision instruction, and to database
Judged through carrying out synthetic backup for the first time.
First backup module 309, for when database does not carry out synthetic backup for the first time, by the database snapshot copy
It copies in the shared volume.
Specifically, after database, which passes through, to be judged, after not carried out the conclusion of synthetic backup for the first time, by database
It carries out after snapshot in obtained snapshot duplicate copy to shared volume, that is, in deposit block device storage pool, as synthesizing for the first time
The backup set of backup.
Second backup module 311 is generated for when database had carried out synthetic backup, obtaining relative to backup for the first time
Incremental data, the incremental data is copied and is synthesized in the backup set that backs up for the first time.
Specifically, when database by after judgement, after having been carried out the conclusion of synthetic backup for the first time, and backing up for the first time
Obtained data are compared, and are obtained relative to the incremental data for backing up generation for the first time, and incremental data are copied to standby for the first time
In the backup set of part, and incremental data is synthesized with the data backed up for the first time, i.e., is carried out with database snapshot copy
Synthesis.
Receiving module 313, the duplicated record submitted for client where receiving the database.
Specifically, the duplicated record that the client database of record where database is backed up, and it is shared by being stored in
Volume can be checked in block device storage pool, while also can be transmitted to backup management system.
The synthetic backup device of above-mentioned SQL Server, other than the complete Database Replica of backup copy for the first time,
It backs up only backup incremental data every time later, dramatically saves the time that backup total data is brought, and it is empty to reduce storage
Between consumption.
Fig. 4 is the structure diagram of the synthetic backup device of SQL Server in another embodiment.As shown in figure 4, SQL
The synthetic backup device of Server further includes：
First creation module 300 creates instruction for receiving first, creates block device storage pool.
Specifically, it after the administrator of backup management system logs in backup management system, initiates first and creates instruction, backup pipe
Reason system receives first and creates instruction and respond the first establishment instruction, creates block device storage pool.
Presetting module 301 pre-sets backup set and retains number for receiving preset instructions.
Specifically, preset instructions are initiated after logging in backup management system by the administrator of backup management system, backup management
System receives and responds preset instructions, pre-sets backup set and retains number.The backup set that wherein database is backed up,
It is stored in block device storage pool, it refers to the number retained the backup set stored that backup set, which retains number,.
Registration module 302, for receiving register instruction, the database backed up required for registering.
Specifically, the administrator of backup management system is the account that operator distributes backup management system, operator's pipe
The account of reason person's distribution logs into backup management, and database account number is used in combination, and is the number for needing to back up in backup management system
It is registered according to library, and backup policy is set.
In another embodiment, further include：
Detection module 315, for checking whether backup set number is more than that pre-set backup set retains number.
Specifically, backup management system counts backup set number after receiving duplicated record, obtains backup set
Backup set number is retained number with pre-set backup set and is compared by number.
Removing module 317, for when detect the backup set number be more than pre-set backup set retain number when,
Earliest backup set on erasing time.
Specifically, when it is more than that pre-set backup set retains number to detect the backup set number, to backup set
BACKUP TIME be ranked up, delete the earliest backup of BACKUP TIME.
The synthetic backup device of above-mentioned SQL Server is provided with backup set and retains number, considerably reduces database
The burden of administrator, when it is more than that pre-set backup set retains number to detect backup set number, on erasing time earliest
Backup set, reduce the consumption of memory space.
Fig. 5 is the internal structure schematic diagram of one embodiment Computer equipment.The computer equipment can be used as database
The client at place.It is connect as shown in figure 5, the computer equipment includes the processor, memory, network connected by system bus
Mouth, display screen and input unit.Wherein, memory may include non-volatile memory medium and built-in storage.It can be deposited in memory
Operating system is contained, a kind of computer program is also stored with, the computer program is for realizing a kind of synthesized backup method.At this
Device is managed for providing calculating and control ability, supports the operation of entire computer equipment.Built-in storage is situated between for non-volatile memories
The operation of computer program in matter provides environment.Network interface is communicated for accessing internet with application server, such as
Receive duplicated record etc..The display screen of computer equipment can be liquid crystal display or electric ink display screen etc., input dress
It can be the touch layer covered on display screen to set, and can also be the button being arranged on computer equipment shell, trace ball or touch-control
Plate can also be external keyboard, Trackpad or mouse etc..The computer equipment can be PC machine or tablet computer etc..
Each technical characteristic of embodiment described above can be combined arbitrarily, to keep description succinct, not to above-mentioned reality
It applies all possible combination of each technical characteristic in example to be all described, as long as however, the combination of these technical characteristics is not deposited
In contradiction, it is all considered to be the range of this specification record.
Several embodiments of the invention above described embodiment only expresses, the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to the protection of the present invention
Range.Therefore, the protection domain of patent of the present invention should be determined by the appended claims.
Claims (10)
1. a kind of synthesized backup method of SQL Server, which is characterized in that including：
It receives second and creates instruction, shared volume is created using block device storage pool；
By client where the shared volume carry to database, to store the backup set of database；
The instruction of the first snapshot is received, snapshot is carried out to database, obtains database snapshot copy；
Send decision instruction so that database judges whether to have carried out synthetic backup for the first time；
It, will be in the database snapshot duplicate copy to the shared volume when database does not carry out synthetic backup for the first time；
When database had carried out synthetic backup, obtain relative to the incremental data for backing up generation for the first time, by the incremental number
According to copying and be synthesized in the backup set that backs up for the first time；
The duplicated record that client where receiving the database is submitted.
2. the synthesized backup method of SQL Server according to claim 1, which is characterized in that receive the second wound described
Instruction is built, further includes before creating shared volume using fast equipment storage pool：
It receives first and creates instruction, create block device storage pool；
Preset instructions are received, backup set is pre-set and retains number；
Register instruction is received, the database backed up required for registering.
3. the synthesized backup method of SQL Server according to claim 2, which is characterized in that further include：
Check whether backup set number is more than that pre-set backup set retains number；
When it is more than that pre-set backup set retains number to detect the backup set number, earliest backup on erasing time
Collection.
4. the synthesized backup method of SQL Server according to claim 1, which is characterized in that further include when database into
It, will be in the database snapshot duplicate copy to the shared volume when row backup set failure of synthetic backup for the first time.
5. the synthesized backup method of SQL Server according to claim 1, which is characterized in that when database had carried out
When synthetic backup, obtained relative to the incremental data for backing up generation for the first time by Documents Comparison algorithm.
6. a kind of synthetic backup device of SQL Server, which is characterized in that including：
Second creation module creates instruction for receiving second, shared volume is created using block device storage pool, by the shared volume
Client where carry to database, to store the backup set of database；
Snapshot module carries out snapshot to database, obtains database snapshot copy for receiving the instruction of the first snapshot；
Sending module, for sending decision instruction so that database judges whether to have carried out synthetic backup for the first time；
First backup module, for when database does not carry out synthetic backup for the first time, the database snapshot duplicate copy to be arrived
In the shared volume；
Second backup module, for when database had carried out synthetic backup, obtaining relative to the increment for backing up generation for the first time
The incremental data is copied and is synthesized in the backup set that backs up for the first time by data；
Receiving module, the duplicated record submitted for client where receiving the database.
7. the synthetic backup device of SQL Server according to claim 6, which is characterized in that further include：
First creation module creates instruction for receiving first, creates block device storage pool；
Presetting module pre-sets backup set and retains number for receiving preset instructions；
Registration module, for receiving register instruction, the database backed up required for registering.
8. the synthetic backup device of SQL Server according to claim 6, which is characterized in that further include：
Detection module, for checking whether backup set number is more than that pre-set backup set retains number；
Removing module, for when it is more than that pre-set backup set retains number to detect the backup set number, when deletion
Between upper earliest backup set.
9. a kind of computer equipment, including memory, processor and it is stored in memory and grows and can run on a processor
Computer program, which is characterized in that the processor is realized when executing described program described in any one of claim 1 to 5
Method.
10. a kind of storage medium, is stored thereon with computer program, which is characterized in that the program is realized when being executed by processor
Method described in any one of claim 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711481491.6A CN108563659A (en) | 2017-12-29 | 2017-12-29 | The synthesized backup method of SQL Server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711481491.6A CN108563659A (en) | 2017-12-29 | 2017-12-29 | The synthesized backup method of SQL Server |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108563659A true CN108563659A (en) | 2018-09-21 |
Family
ID=63529628
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711481491.6A Pending CN108563659A (en) | 2017-12-29 | 2017-12-29 | The synthesized backup method of SQL Server |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108563659A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110083490A (en) * | 2019-04-29 | 2019-08-02 | 浙江豪联信息科技有限公司 | A kind of database backup method, restoring method and storage medium |
| CN111158958A (en) * | 2019-12-31 | 2020-05-15 | 广州鼎甲计算机科技有限公司 | Backup method, system, device and storage medium capable of quickly recovering data |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9703644B1 (en) * | 2014-12-09 | 2017-07-11 | EMC IP Holding Company LLC | Methods for generating a synthetic backup and for consolidating a chain of backups independent of endianness |
| CN107066357A (en) * | 2017-05-31 | 2017-08-18 | 广州鼎甲计算机科技有限公司 | A kind of database synthetic backup and carry restoration methods |
| CN107133131A (en) * | 2017-05-31 | 2017-09-05 | 广州鼎甲计算机科技有限公司 | A kind of virtual machine synthesized backup method based on VMware |
-
2017
- 2017-12-29 CN CN201711481491.6A patent/CN108563659A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9703644B1 (en) * | 2014-12-09 | 2017-07-11 | EMC IP Holding Company LLC | Methods for generating a synthetic backup and for consolidating a chain of backups independent of endianness |
| CN107066357A (en) * | 2017-05-31 | 2017-08-18 | 广州鼎甲计算机科技有限公司 | A kind of database synthetic backup and carry restoration methods |
| CN107133131A (en) * | 2017-05-31 | 2017-09-05 | 广州鼎甲计算机科技有限公司 | A kind of virtual machine synthesized backup method based on VMware |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110083490A (en) * | 2019-04-29 | 2019-08-02 | 浙江豪联信息科技有限公司 | A kind of database backup method, restoring method and storage medium |
| CN111158958A (en) * | 2019-12-31 | 2020-05-15 | 广州鼎甲计算机科技有限公司 | Backup method, system, device and storage medium capable of quickly recovering data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10942894B2 (en) | Operation readiness checking and reporting | |
| US9984006B2 (en) | Data storage systems and methods | |
| US20200356443A1 (en) | Single snapshot for multiple applications | |
| US11321383B2 (en) | Data storage management operations in a secondary storage subsystem using image recognition and image-based criteria | |
| US9753812B2 (en) | Generating mapping information for single snapshot for multiple applications | |
| US9632874B2 (en) | Database application backup in single snapshot for multiple applications | |
| CN105009085B (en) | Information processing system, control program and information processing equipment | |
| US20180267856A1 (en) | Distributed storage system, data storage method, and software program | |
| CN102713856B (en) | Method and system for recovering file system of computer system | |
| US6463573B1 (en) | Data processor storage systems with dynamic resynchronization of mirrored logical data volumes subsequent to a storage system failure | |
| US20150212894A1 (en) | Restoring application data from a single snapshot for multiple applications | |
| CN101840362A (en) | Method and device for achieving copy-on-write snapshot | |
| US20150026133A1 (en) | Producing an image copy of a database object based on information within database buffer pools | |
| US8799595B1 (en) | Eliminating duplicate data in storage systems with boot consolidation | |
| US11429498B2 (en) | System and methods of efficiently resyncing failed components without bitmap in an erasure-coded distributed object with log-structured disk layout | |
| CN108563659A (en) | The synthesized backup method of SQL Server | |
| US10795588B1 (en) | Check point recovery based on identifying used blocks for block-based backup files | |
| US11074003B2 (en) | Storage system and restoration method | |
| KR102214697B1 (en) | A computer program for providing space managrment for data storage in a database management system | |
| US11194760B1 (en) | Fast object snapshot via background processing | |
| US20140019425A1 (en) | File server and file management method | |
| Kim et al. | A method for enhancing the snapshot performance in SAN volume manager |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180921 |