Primary methods and models to optimize backup and restore databases in MS SQL Server Express
Abstract
This article examines the problems associated with the selection of a backup and recovery strategy on the same database while increasing its size as a result of connected systems activity. There is a method proposed to test backup strategy efficiency. The method is implemented in an application for automated testing. The test results show that the effectiveness of the differential backups decreases with increasing the database size and the last backup of transaction log takes twice as long to recover than the ones preceding it - despite their equal size. The reason these findings are important is that they allow database administrators to make informed choices when deciding what backup strategy to implement;References
BSI Group. 2008. BS ISO/IEC 27005:2008 Information technology - Security techniques - Information security risk management. London: BSI Group
Desai, А. 2000. SQL Server 7 Backup & Recovery. Mcgraw-Hill Osborne Media
Georeference, 2015. Oracle Express Edition, [online] Available at:
George, R., Delano, L.,2006.SQL Server 2005 Express Edition Starter Kit. Wrox
GFI, 2015. What are the size limitations for Microsoft SQL Server Express databases?, [online] Available at:
Jorgensen, A., Wort, S.,LoForte .R and Knight, B., 2012.Professional Microsoft SQL Server 2012 Administration. Wrox
Kasheva, M. and Kuyumdzhiev, I. and Tuleshkova, O., 2009. Bazi ot danni. Varna: Nauka I ikonomika, p. 49-50.
Masood-Al-Farooq, B. 2014. SQL Server 2014 Development Essentials.Packt Publishing p. 10
Microsoft Press. 2008. 6231A Maintaining a Microsoft SQL Server 2008 Database. Microsoft Press p.3.2
Microsoft, 2015. Microsoft SQL Server 2008 R2 RTM - Express, [online] Available at:
Microsoft, 2015. What's New in SQL Server 2016, October Update, [online] Available at:
Microsoft, 2015. Estimate the Size of a Database, [online]
Available at:
Microsoft, 2015. SQL Database Management Objects (SQL-DMO), [online] Available at:
Microsoft, 2015. Data Collection, [online] Available at:
Microsoft, 2015. Partial Backups, [online] Available at:
Simmons, K. and Carstarphen, S.,2012. Pro SQL Server 2012 Administration. Apress, DOI: http://dx.doi.org/10.1007/978-1-4302-3916-1
Strate, J and Krueger, T., 2012. Expert Performance Indexing for SQL Server 2012. Apress, DOI: http://dx.doi.org/10.1007/978-1-4302-3742-6
Walters, R. and Fritchey, G., 2012.Beginning SQL Server 2012 Administration.Apress
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
By submitting a paper for publishing the authors hereby comply with the following provisions: 1. The authors retain the copyrights and only give the journal the right for first publication while licensing the work under Creative Commons Attribution License, which grants permissions to others to share the contribution citing this journal as first publication of the text. 2. The authors may enter separate, additional contractual relations for non-exclusive distribution of the published version of the work in this journal (e.g. to upload it in an institutional depository, or to be published in a book), given that they cite the first publication in this journal. 3. The authors are allowed and are encouraged to publish their works online (e.g. to upload it in an institutional depository, personal websites, social networks, etc.) before, during, and after the submission of the paper here, because this may lead to productive exchange, as well as earlier and larger referencing of the published works (see The Effect of Open Access).
