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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: STEVEN R. DEVOS, DEEPAK SARAF, MICHAEL A. PAYNE, LOUIS J. BEATTY
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&amp;date=20120718&amp;DB=EPODOC&amp;CC=CN&amp;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&amp;date=20120718&amp;DB=EPODOC&amp;CC=CN&amp;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