Method and system of performing incremental sql server database backups
A system, method, and medium for performing incremental backups of a Microsoft SQL server database. A snapshot of the database is created, and then a map identifying the changed extents is retrieved from the snapshot. The changed extents are then retrieved from the snapshot and stored in a backup st...
Gespeichert in:
Hauptverfasser: | , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
container_end_page | |
---|---|
container_issue | |
container_start_page | |
container_title | |
container_volume | |
creator | STEVEN R. DEVOS DEEPAK SARAF MICHAEL A. PAYNE LOUIS J. BEATTY |
description | A system, method, and medium for performing incremental backups of a Microsoft SQL server database. A snapshot of the database is created, and then a map identifying the changed extents is retrieved from the snapshot. The changed extents are then retrieved from the snapshot and stored in a backup storage device. For a restore operation, a full database backup file is written to a storage device and then the changed extents from a stored incremental backup file may be merged with the full backup file. Next, the database server is notified of the reconstructed file and then the reconstructed file is mounted by the database server as a live instance of the database. |
format | Patent |
fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN102591982A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN102591982A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN102591982A3</originalsourceid><addsrcrecordid>eNrjZHD3TS3JyE9RSMxLUSiuLC5JzVXIT1MoSC1Kyy_KzcxLV8jMSy5KzU3NK0nMUSguBOLUorLUIoWUxJLEpMTiVIWkxOTs0oJiHgbWtMSc4lReKM3NoOjmGuLsoZtakB-fWlyQmJyal1oS7-xnaGBkamloaWHkaEyMGgCCZzQ2</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Method and system of performing incremental sql server database backups</title><source>esp@cenet</source><creator>STEVEN R. DEVOS ; DEEPAK SARAF ; MICHAEL A. PAYNE ; LOUIS J. BEATTY</creator><creatorcontrib>STEVEN R. DEVOS ; DEEPAK SARAF ; MICHAEL A. PAYNE ; LOUIS J. BEATTY</creatorcontrib><description>A system, method, and medium for performing incremental backups of a Microsoft SQL server database. A snapshot of the database is created, and then a map identifying the changed extents is retrieved from the snapshot. The changed extents are then retrieved from the snapshot and stored in a backup storage device. For a restore operation, a full database backup file is written to a storage device and then the changed extents from a stored incremental backup file may be merged with the full backup file. Next, the database server is notified of the reconstructed file and then the reconstructed file is mounted by the database server as a live instance of the database.</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2012</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20120718&DB=EPODOC&CC=CN&NR=102591982A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76289</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20120718&DB=EPODOC&CC=CN&NR=102591982A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>STEVEN R. DEVOS</creatorcontrib><creatorcontrib>DEEPAK SARAF</creatorcontrib><creatorcontrib>MICHAEL A. PAYNE</creatorcontrib><creatorcontrib>LOUIS J. BEATTY</creatorcontrib><title>Method and system of performing incremental sql server database backups</title><description>A system, method, and medium for performing incremental backups of a Microsoft SQL server database. A snapshot of the database is created, and then a map identifying the changed extents is retrieved from the snapshot. The changed extents are then retrieved from the snapshot and stored in a backup storage device. For a restore operation, a full database backup file is written to a storage device and then the changed extents from a stored incremental backup file may be merged with the full backup file. Next, the database server is notified of the reconstructed file and then the reconstructed file is mounted by the database server as a live instance of the database.</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2012</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZHD3TS3JyE9RSMxLUSiuLC5JzVXIT1MoSC1Kyy_KzcxLV8jMSy5KzU3NK0nMUSguBOLUorLUIoWUxJLEpMTiVIWkxOTs0oJiHgbWtMSc4lReKM3NoOjmGuLsoZtakB-fWlyQmJyal1oS7-xnaGBkamloaWHkaEyMGgCCZzQ2</recordid><startdate>20120718</startdate><enddate>20120718</enddate><creator>STEVEN R. DEVOS</creator><creator>DEEPAK SARAF</creator><creator>MICHAEL A. PAYNE</creator><creator>LOUIS J. BEATTY</creator><scope>EVB</scope></search><sort><creationdate>20120718</creationdate><title>Method and system of performing incremental sql server database backups</title><author>STEVEN R. DEVOS ; DEEPAK SARAF ; MICHAEL A. PAYNE ; LOUIS J. BEATTY</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN102591982A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2012</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>STEVEN R. DEVOS</creatorcontrib><creatorcontrib>DEEPAK SARAF</creatorcontrib><creatorcontrib>MICHAEL A. PAYNE</creatorcontrib><creatorcontrib>LOUIS J. BEATTY</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>STEVEN R. DEVOS</au><au>DEEPAK SARAF</au><au>MICHAEL A. PAYNE</au><au>LOUIS J. BEATTY</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Method and system of performing incremental sql server database backups</title><date>2012-07-18</date><risdate>2012</risdate><abstract>A system, method, and medium for performing incremental backups of a Microsoft SQL server database. A snapshot of the database is created, and then a map identifying the changed extents is retrieved from the snapshot. The changed extents are then retrieved from the snapshot and stored in a backup storage device. For a restore operation, a full database backup file is written to a storage device and then the changed extents from a stored incremental backup file may be merged with the full backup file. Next, the database server is notified of the reconstructed file and then the reconstructed file is mounted by the database server as a live instance of the database.</abstract><oa>free_for_read</oa></addata></record> |
fulltext | fulltext_linktorsrc |
identifier | |
ispartof | |
issn | |
language | chi ; eng |
recordid | cdi_epo_espacenet_CN102591982A |
source | esp@cenet |
subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
title | Method and system of performing incremental sql server database backups |
url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-05T10%3A28%3A31IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=STEVEN%20R.%20DEVOS&rft.date=2012-07-18&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN102591982A%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true |