Search

Copyright of Przegląd Elektrotechniczny is the property of Przeglad Elektrotechniczny and its content may not be copied or emailed to multiple sites or posted to a listserv without the copyright holder's express written permission. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)

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 this is the logical choice when reducing downtime is a primary concern for the organisation. 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. The 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. [ABSTRACT FROM AUTHOR]