Please use this identifier to cite or link to this item: http://hdl.handle.net/10525/3875

 Title: Correlation Between Storage Device and Backup and Restore Efficiency in MS SQL Server Authors: Kuyumdzhiev, IvanNacheva, Radka Keywords: Backup and Restore PerformanceStorage MediaDatabases Performance TestsMS 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. URI: http://hdl.handle.net/10525/3875 ISSN: 1312-6555 Appears in Collections: Volume 13, Number 3-4

Files in This Item:

File Description SizeFormat