Browse > Article
http://dx.doi.org/10.13089/JKIISC.2018.28.4.859

Comparing Recoverability of Deleted Data According to Original Source Collection Methods on Microsoft SQL Server  

Shin, Jiho (Police Science Institute, Korean National Police University)
Publication Information
Journal of the Korea Institute of Information Security & Cryptology / v.28, no.4, 2018 , pp. 859-868 More about this Journal
Abstract
Previous research related to recovering deleted data in database has been mainly based on transaction logs or detecting and recovering data using original source files by physical collection method. However there was a limit to apply if the transaction log does not exist in the server or it is not possible to collect the original source file because a database server owner does not permit stopping the database server because of their business loss or infringement at the scene. Therefore it is necessary to examine various collection methods and check the recoverability of the deleted data in order to handling the constraints of evidence collection situation. In this paper we have checked an experiment that the recoverability of deleted data in the original database source according to logical and physical collection methods on digital forensic investigation of Microsoft SQL Server database.
Keywords
Database; Microsoft SQL Server; Logical / Physical Collection; Deleted Data; Recovery; Page;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 Jiho Shin, "Comparison of Remaining Data According to Deletion Events on Microsoft SQL Server," Journal of The Korea Institute of Information Security & Cryptology, vol. 27, no. 2, pp. 223-232, 2017.   DOI
2 Theo Haerder and Andreas Reuter, "Theo Principles of Transaction-Oriented Database Recovery," ACM Computing Surveys (CSUR), vol. 15, pp. 287-317, 1983   DOI
3 Park Soo-Young, "A Research for Record Recovery Method in Database," Thesis for the Degree of Master, Korea University, Dec, 2013
4 Ryu Gi-Hwan, "A Study for Recovering Records of Microsoft SQL Server's Database," Thesis for the Degree of Master, Korea University, Dec, 2014
5 WIKIPEDIA, Microsoft SQL Server, https://en.wikipedia.org/wiki/Microsoft_SQL_Server, 2018.3.25
6 Microsoft, Microsoft Data Platform, https://www.microsoft.com/en-us/sql-server/, 2018.3.25
7 Microsoft TechNet, Understanding Pages and Extents, https://technet.microsoft.com/en-us/library/ms190969(v=sql.105).aspx, 2018.3.25
8 Microsoft Docs, Shrink a Database, https://docs.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-database, 2018.5.3
9 Mark and Kimura Meiji, "Database first step: catch up with the database of the complete novice," Hanbit media, 2018.5.3
10 Kim Kyung-Chang, "A Study on Data Backup and Recovery Technique for Dynamic Real-Time Database," Electronics and Telecommunications Research Institute, 1994
11 Microsoft Docs, Pages and Extents Architecture Guide, https://docs.microsoft.com/en-us/sql/relational-databases/pages-and-extents-architecture-guide, 2018.6.30