BulDML at Institute of Mathematics and Informatics >
IMI Periodicals >
Serdica Journal of Computing >
2019 >
Volume 13, Number 3-4 >

Please use this identifier to cite or link to this item:

Title: Correlation Between Storage Device and Backup and Restore Efficiency in MS SQL Server
Authors: Kuyumdzhiev, Ivan
Nacheva, Radka
Keywords: Backup and Restore Performance
Storage Media
Databases Performance Tests
MS SQL Server
Issue Date: 2019
Publisher: Institute of Mathematics and Informatics Bulgarian Academy of Sciences
Citation: Serdica Journal of Computing, Vol. 13, No 3-4, (2019), 139p-154p
Abstract: The importance of the process of restoring a database requires precise examination of all factors that affect it. Considering the decline of the price of SSD and its better read and write speeds it seems that the logical choice when reducing downtime is primary concern for the organisation. This paper categorizes storage devices in use as well as the main backup types in the MS SQL Server. Tests are conducted to evaluate the impact of the storage device on backup and restore efficiency. In this regard, the purpose of the research is to examine problems associated with the selection of a storage device for efficient backup and restore in MS SQL Server. Conducted tests showed some surprising results regarding SSD’s efficiency. The reason these findings are important is that they could be used as a guideline for choosing proper storage device for an organisation’s needs. ACM Computing Classification System (1998): H.2.7, I.3.1, D.4.2. Mathematics Subject Classification – MSC2020: 68P15.
ISSN: 1312-6555
Appears in Collections:Volume 13, Number 3-4

Files in This Item:

File Description SizeFormat
sjc-vol13-num3-4-2019-p139-p154.pdf136.33 kBAdobe PDFView/Open


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.


Valid XHTML 1.0!   Creative Commons License