Choosing Storage Devices with Consideration of Backup and Restore Performance in MS SQL SERVER

Ivan Kuyumdzhiev () and Radka Nacheva ()
Additional contact information
Ivan Kuyumdzhiev: University of Economics – Varna/Informatics Department, Varna, Bulgaria
Radka Nacheva: University of Economics – Varna/Informatics Department, Varna, Bulgaria

Conferences of the department Informatics, 2019, issue 1, 166-176

Abstract: Importance of the process of restoring a database requires precise exami-nation of all factors that affects it. Considering the decline of price of SSD and it’s better read and write speeds it seems like logical choice when reducing downtime is primary concern for the organization. This paper categorizes storage devices in use as well as main backup types in 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 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 organization’s needs.

Keywords: backup and restore performance; storage media; databases performance tests; MS SQL server (search for similar items in EconPapers)
JEL-codes: C8 (search for similar items in EconPapers)
Date: 2019
References: Add references at CitEc
Citations:

Downloads: (external link)
http://informatics.ue-varna.bg/conference19/Conf.p ... .years%20166-176.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:vrn:katinf:y:2019:i:1:p:166-176

Access Statistics for this article

Conferences of the department Informatics is currently edited by Vladimir Sulov

More articles in Conferences of the department Informatics from Publishing house Science and Economics Varna Contact information at EDIRC.
Bibliographic data for series maintained by Vladimir Sulov ().