Restoring SQL Database

%3CLINGO-SUB%20id%3D%22lingo-sub-1462039%22%20slang%3D%22en-US%22%3ERestoring%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1462039%22%20slang%3D%22en-US%22%3EHi%20All%2C%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20anyone%20help%20me%20regarding%20the%20SQL%20Database%20Restoring%20Process.%3CBR%20%2F%3E%3CBR%20%2F%3ECase%3A%20Server%20Crashed%20on%2010th%20June%202020%20and%20all%20files%20are%20encrypted.%20Nothing%20is%20accessible%20on%20the%20server.%3CBR%20%2F%3E%3CBR%20%2F%3ELuckily%20we%20have%20restored%20the%20Server%20Image%20which%20we%20have%20taken%20on%205th%20May%202020%20but%20we%20need%20to%20restore%20the%20latest%20database%20of%20our%20ERP.%3CBR%20%2F%3E%3CBR%20%2F%3EWe%20are%20using%20the%20SQL%20backup%20tool%20for%20the%20backups%20and%20we%20restored%20the%20Full%20Backup%20which%20we%20have%20taken%20on%205th%20June%202020.%3CBR%20%2F%3E%3CBR%20%2F%3EBackup%20Plan%3A%20We%20are%20taking%20Differential%20Backups%20on%20daily%20basis%20and%20Full%20backup%20on%20weekly%20basis.%3CBR%20%2F%3E%3CBR%20%2F%3EAfter%20restoring%20the%20Full%20backup%20as%20of%205th%20June%202020%20we%20have%20Differential%20backups%20for%3CBR%20%2F%3E%3CBR%20%2F%3E6th%20June%20%2C%207th%20June%20%2C%208th%20June%20and%209th%20June.%3CBR%20%2F%3E%3CBR%20%2F%3EWe%20tried%20to%20restore%20the%20differential%20backup%20of%206th%20June%20but%20we%20are%20getting%20the%20below%20Error%3CBR%20%2F%3E%3CBR%20%2F%3EError%3A%20This%20differential%20backup%20cannot%20be%20restored%20because%20the%20database%20has%20not%20been%20restored%20to%20the%20correct%20earlier%20state.%3CBR%20%2F%3E%3CBR%20%2F%3EWe%20tried%20to%20to%20restore%20the%20Full%20backup%20in%20Non%20Recovery%20Mode%20and%20then%20restore%20the%20differential%20of%206th%20June%20and%20it%20got%20successful%20but%20still%20we%20are%20facing%20issue%20when%20trying%20to%20restore%20the%207th%20%2C%208th%20and%209th%20June.%3CBR%20%2F%3E%3CBR%20%2F%3EKindly%20tell%20me%20the%20correct%20procedure%20for%20the%20restoration.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20in%20advance.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1462039%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1795161%22%20slang%3D%22en-US%22%3ERe%3A%20Restoring%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1795161%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F699015%22%20target%3D%22_blank%22%3E%40adildyna365%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20read%20your%20SQL%20related%20issues.%20Here%2C%20I%20am%20to%20suggest%20to%20you%20one%20of%20the%20best%20solutions%20that%20will%20sort%20out%20all%20your%20SQL%20database%20recovery%20issues.%20This%20professional%20software%20named%20%3CA%20href%3D%22https%3A%2F%2Fwww.arysontechnologies.com%2Fsql-database-recovery.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%3CSTRONG%3ESQL%20Database%20Recovery%3C%2FSTRONG%3E%3C%2FA%3E%20can%20repair%20and%20recover%20your%20damaged%20database%20without%20affecting%20the%20healthy%20database.%26nbsp%3B%20This%20third%20party%20tool%20has%20some%20amazing%20features%20which%20will%20help%20you%20in%20the%20database%20recovery%20process.%20You%20can%20use%20this%20tool%20to%20repair%20your%20SQL%20database%20repairing.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hi All,

Can anyone help me regarding the SQL Database Restoring Process.

Case: Server Crashed on 10th June 2020 and all files are encrypted. Nothing is accessible on the server.

Luckily we have restored the Server Image which we have taken on 5th May 2020 but we need to restore the latest database of our ERP.

We are using the SQL backup tool for the backups and we restored the Full Backup which we have taken on 5th June 2020.

Backup Plan: We are taking Differential Backups on daily basis and Full backup on weekly basis.

After restoring the Full backup as of 5th June 2020 we have Differential backups for

6th June , 7th June , 8th June and 9th June.

We tried to restore the differential backup of 6th June but we are getting the below Error

Error: This differential backup cannot be restored because the database has not been restored to the correct earlier state.

We tried to to restore the Full backup in Non Recovery Mode and then restore the differential of 6th June and it got successful but still we are facing issue when trying to restore the 7th , 8th and 9th June.

Kindly tell me the correct procedure for the restoration.

Thanks in advance.
1 Reply

Hey @adildyna365 

I read your SQL related issues. Here, I am to suggest to you one of the best solutions that will sort out all your SQL database recovery issues. This professional software named SQL Database Recovery can repair and recover your damaged database without affecting the healthy database.  This third party tool has some amazing features which will help you in the database recovery process. You can use this tool to repair your SQL database repairing.