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
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)
References: Add references at CitEc
Citations: Track citations by RSS feed
Downloads: (external link)
http://informatics.ue-varna.bg/conference19/Conf.p ... .years%20166-176.pdf (application/pdf)
This item may be available elsewhere in EconPapers: Search for items with the same title.
Export reference: BibTeX
RIS (EndNote, ProCite, RefMan)
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 ().