![\"\"](\"http:\/\/wordpress.semnaitik.com\/wp-content\/uploads\/2013\/11\/download-free-demo.png\")
<\/a><\/p>\n\n\n\n
I\u2019ll share some manual techniques which might also work in getting back the deleted records and if by chance they fail then you have to spend some bucks and try professional recovery software. It is really difficult to recover deleted or lost records from the database but we can give a try by following the manual methods and see if the manual methods can fix this problem or not.<\/p>\n\n\n\n
Steps to Recover Lost Data in SQL Server 2012 and other Versions<\/strong><\/h2>\n\n\n\nFirst try the manual procedure and if it fails, then move to the Professional method.<\/p>\n\n\n\n
Try to Recover Data via LSN<\/strong><\/h3>\n\n\n\nLSN means Log Sequence numbers which identify the time of SQL Log\nTransaction when it has occurs. So you can get back deleted data with the help\nof LSN. But the prerequisite for this method is that you should remember the\ntime and date when you have deleted the data. You can follow the steps given\nbelow to get back erased data in SQL Database:-<\/p>\n\n\n\n
- Check the number of rows present in the table by using the query given below.<\/li><\/ul>\n\n\n\n
SELECT * FROM Table_name<\/pre>\n\n\n\n
- Use the following query and then create a backup of the SQL Log transaction.<\/li><\/ul>\n\n\n\n
USE Databasename
\nGO
\nBACKUP LOG [Databasename]
\nTO DISK = N\u2019D:\\Databasename\\RDDTrLog.trn\u2019
\nWITH NOFORMAT, NOINIT,
\nNAME = N\u2019Databasename-Transaction Log Backup\u2019,
\nSKIP, NOREWIND, NOUNLOAD, STATS = 10
\nGO<\/pre>\n\n\n\n
- Run the following query to retrieve information\nof the deleted records.<\/li><\/ul>\n\n\n\n
USE Databasename
\nGO
\nSelect [Current LSN] LSN], [Transaction ID], Operation, Context, AllocUnitName
\nFROM
\nfn_dblog(NULL, NULL)
\nWHERE Operation = \u2018LOP_DELETE_ROWS\u2019<\/pre>\n\n\n\nNow, you\u2019ll get the transaction of all the deleted record and if you have got the transaction I.D. of the lost record then go to the next step.<\/p>\n\n\n\n
- In the following query enter the transaction I.D. of your deleted data and then you’ll know the time and date of deletion.<\/li><\/ul>\n\n\n\n
USE Databasename
\nGO
\nSELECT
\n[Current LSN], Operation, [Transaction ID], [Begin Time], [Transaction Name],\n[Transaction SID]
\nFROM
\nfn_dblog(NULL, NULL)
\nWHERE
\n[Transaction ID] = \u2018Transaction of your deleted data\u2032
\nAND
\n[Operation] = \u2018LOP_BEGIN_XACT\u2019<\/pre>\n\n\n\nYou\u2019ll get the LSN value of your deleted record and now, it is the\ntime to restore deleted records in SQL Server.<\/p>\n\n\n\n
- Execute the following query to initiate the\nrecovering process.<\/li><\/ul>\n\n\n\n
Recover Deleted D USE Databasename
\nGO
\nRESTORE DATABASE Databasename_COPY FROM
\nDISK = \u2018D:\\Databasename\\RDDFull.bak\u2019
\nWITH
\nMOVE \u2018Databasename\u2019 TO \u2018D:\\RecoverDB\\Databasename.mdf\u2019,
\nMOVE \u2018Databasename_log\u2019 TO \u2018D:\\RecoverDB\\Databasename_log.ldf\u2019,
\nREPLACE, NORECOVERY;
\nGO<\/pre>\n\n\n\n
- Now, put the LSN value that you have got in the following command.<\/li><\/ul>\n\n\n\n
USE Databasename
GO
RESTORE LOG Databasename_COPY FROM DISK=N\u2019D:\\Databasename\\RDOTrLog.trn\u2019 WITH STOPBEFOREMARK=\u2018lsn:0x00000020:000001d0:0002\u2032 <\/pre>\n\n\n\n![\"\"](\"https:\/\/wordpress.semnaitik.com\/wp-content\/uploads\/2019\/08\/1.bmp\")
<\/figure><\/div>\n\n\n\n- Finally, Run the following query and see whether you have\nsucceeded in restoring the data back.<\/li><\/ul>\n\n\n\n
USE\nDatabasename_Copy GO Select * from Table_name<\/pre>\n\n\n\nYou May Also Read- SQL Server Login Error 18456<\/a><\/p>\n\n\n\nI hope this\nmanual method will help you out to resolve your issue but there are some\ndrawbacks of using the manual methods.<\/p>\n\n\n\n
Disadvantages of the Manual Method<\/strong><\/h4>\n\n\n\n- It is a very time-consuming method and you also have to run all the queries will full concentration.<\/li>
- Any kind of negligence during the whole process may result in full data loss.<\/li>
- The manual method is not recommended for novice users because it requires a lot of technical expertise.<\/li><\/ul>\n\n\n\n
SQL Database Recovery Software<\/a><\/h3>\n\n\n\nThe professional tool is the only solution for getting back the deleted data in SQL Database and it also defeats all the disadvantages of the manual methods and neither is it time taking nor there is any chance of data loss. The user can easily recover all the data either it is deleted or has gone corrupted.<\/p>\n\n\n\n
Conclusion<\/strong><\/h4>\n\n\n\nThe ball is in your court and you have to decide which method will be the best option for recovering records and if you are having good technical knowledge then you can try the manual method otherwise you should go with the Software because it is quick and there are no chances of data loss during the recovery process. So, make your choice and restore deleted records in SQL Server.<\/p>\n","protected":false},"excerpt":{"rendered":"
LSN means Log Sequence numbers which identify the time of SQL Log\nTransaction when it has occurs. So you can get back deleted data with the help\nof LSN. But the prerequisite for this method is that you should remember the\ntime and date when you have deleted the data. You can follow the steps given\nbelow to get back erased data in SQL Database:-<\/p>\n\n\n\n
- Check the number of rows present in the table by using the query given below.<\/li><\/ul>\n\n\n\n
SELECT * FROM Table_name<\/pre>\n\n\n\n
- Use the following query and then create a backup of the SQL Log transaction.<\/li><\/ul>\n\n\n\n
USE Databasename
\nGO
\nBACKUP LOG [Databasename]
\nTO DISK = N\u2019D:\\Databasename\\RDDTrLog.trn\u2019
\nWITH NOFORMAT, NOINIT,
\nNAME = N\u2019Databasename-Transaction Log Backup\u2019,
\nSKIP, NOREWIND, NOUNLOAD, STATS = 10
\nGO<\/pre>\n\n\n\n- Run the following query to retrieve information\nof the deleted records.<\/li><\/ul>\n\n\n\n
USE Databasename
\nGO
\nSelect [Current LSN] LSN], [Transaction ID], Operation, Context, AllocUnitName
\nFROM
\nfn_dblog(NULL, NULL)
\nWHERE Operation = \u2018LOP_DELETE_ROWS\u2019<\/pre>\n\n\n\nNow, you\u2019ll get the transaction of all the deleted record and if you have got the transaction I.D. of the lost record then go to the next step.<\/p>\n\n\n\n
- In the following query enter the transaction I.D. of your deleted data and then you’ll know the time and date of deletion.<\/li><\/ul>\n\n\n\n
USE Databasename
\nGO
\nSELECT
\n[Current LSN], Operation, [Transaction ID], [Begin Time], [Transaction Name],\n[Transaction SID]
\nFROM
\nfn_dblog(NULL, NULL)
\nWHERE
\n[Transaction ID] = \u2018Transaction of your deleted data\u2032
\nAND
\n[Operation] = \u2018LOP_BEGIN_XACT\u2019<\/pre>\n\n\n\nYou\u2019ll get the LSN value of your deleted record and now, it is the\ntime to restore deleted records in SQL Server.<\/p>\n\n\n\n
- Execute the following query to initiate the\nrecovering process.<\/li><\/ul>\n\n\n\n
Recover Deleted D USE Databasename
\nGO
\nRESTORE DATABASE Databasename_COPY FROM
\nDISK = \u2018D:\\Databasename\\RDDFull.bak\u2019
\nWITH
\nMOVE \u2018Databasename\u2019 TO \u2018D:\\RecoverDB\\Databasename.mdf\u2019,
\nMOVE \u2018Databasename_log\u2019 TO \u2018D:\\RecoverDB\\Databasename_log.ldf\u2019,
\nREPLACE, NORECOVERY;
\nGO<\/pre>\n\n\n\n- Now, put the LSN value that you have got in the following command.<\/li><\/ul>\n\n\n\n
USE Databasename
GO
RESTORE LOG Databasename_COPY FROM DISK=N\u2019D:\\Databasename\\RDOTrLog.trn\u2019 WITH STOPBEFOREMARK=\u2018lsn:0x00000020:000001d0:0002\u2032 <\/pre>\n\n\n\n<\/figure><\/div>\n\n\n\n- Finally, Run the following query and see whether you have\nsucceeded in restoring the data back.<\/li><\/ul>\n\n\n\n
USE\nDatabasename_Copy GO Select * from Table_name<\/pre>\n\n\n\n
You May Also Read- SQL Server Login Error 18456<\/a><\/p>\n\n\n\n
I hope this\nmanual method will help you out to resolve your issue but there are some\ndrawbacks of using the manual methods.<\/p>\n\n\n\n
Disadvantages of the Manual Method<\/strong><\/h4>\n\n\n\n
- It is a very time-consuming method and you also have to run all the queries will full concentration.<\/li>
- Any kind of negligence during the whole process may result in full data loss.<\/li>
- The manual method is not recommended for novice users because it requires a lot of technical expertise.<\/li><\/ul>\n\n\n\n
SQL Database Recovery Software<\/a><\/h3>\n\n\n\n
The professional tool is the only solution for getting back the deleted data in SQL Database and it also defeats all the disadvantages of the manual methods and neither is it time taking nor there is any chance of data loss. The user can easily recover all the data either it is deleted or has gone corrupted.<\/p>\n\n\n\n
Conclusion<\/strong><\/h4>\n\n\n\n
The ball is in your court and you have to decide which method will be the best option for recovering records and if you are having good technical knowledge then you can try the manual method otherwise you should go with the Software because it is quick and there are no chances of data loss during the recovery process. So, make your choice and restore deleted records in SQL Server.<\/p>\n","protected":false},"excerpt":{"rendered":"
- Finally, Run the following query and see whether you have\nsucceeded in restoring the data back.<\/li><\/ul>\n\n\n\n
- Now, put the LSN value that you have got in the following command.<\/li><\/ul>\n\n\n\n
- Execute the following query to initiate the\nrecovering process.<\/li><\/ul>\n\n\n\n
- In the following query enter the transaction I.D. of your deleted data and then you’ll know the time and date of deletion.<\/li><\/ul>\n\n\n\n
- Run the following query to retrieve information\nof the deleted records.<\/li><\/ul>\n\n\n\n
- Use the following query and then create a backup of the SQL Log transaction.<\/li><\/ul>\n\n\n\n