Geodesic
Correlation Between Storage Device and Backup and Restore Efficiency in MS SQL Server
Serdica Journal of Computing, Tome 13 (2019) no. 3-4, pp. 139-154

Voir la notice de l'article provenant de la source Bulgarian Digital Mathematics Library

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.
Keywords: Backup and Restore Performance, Storage Media, Databases Performance Tests, MS SQL Server 
@article{SJC_2019_13_3-4_a3,
     author = {Kuyumdzhiev, Ivan and Nacheva, Radka},
     title = {Correlation {Between} {Storage} {Device} and {Backup} and {Restore} {Efficiency} in {MS} {SQL} {Server}},
     journal = {Serdica Journal of Computing},
     pages = {139--154},
     publisher = {mathdoc},
     volume = {13},
     number = {3-4},
     year = {2019},
     language = {en},
     url = {http://geodesic.mathdoc.fr/item/SJC_2019_13_3-4_a3/}
}
TY  - JOUR
AU  - Kuyumdzhiev, Ivan
AU  - Nacheva, Radka
TI  - Correlation Between Storage Device and Backup and Restore Efficiency in MS SQL Server
JO  - Serdica Journal of Computing
PY  - 2019
SP  - 139
EP  - 154
VL  - 13
IS  - 3-4
PB  - mathdoc
UR  - http://geodesic.mathdoc.fr/item/SJC_2019_13_3-4_a3/
LA  - en
ID  - SJC_2019_13_3-4_a3
ER  - 
%0 Journal Article
%A Kuyumdzhiev, Ivan
%A Nacheva, Radka
%T Correlation Between Storage Device and Backup and Restore Efficiency in MS SQL Server
%J Serdica Journal of Computing
%D 2019
%P 139-154
%V 13
%N 3-4
%I mathdoc
%U http://geodesic.mathdoc.fr/item/SJC_2019_13_3-4_a3/
%G en
%F SJC_2019_13_3-4_a3
Kuyumdzhiev, Ivan; Nacheva, Radka. Correlation Between Storage Device and Backup and Restore Efficiency in MS SQL Server. Serdica Journal of Computing, Tome 13 (2019) no. 3-4, pp. 139-154. http://geodesic.mathdoc.fr/item/SJC_2019_13_3-4_a3/