Click here to Skip to main content
14,330,512 members
Rate this:
Please Sign up or sign in to vote.
See more:
When I checked my database, the database is in restoring stage. I wrote the query to run the datbase normal,

What I have tried:

RESTORE DATABASE TestingDb WITH RECOVERY
GO

and the error occur in message box
The database cannot be recovered because the log was not restored.
Posted
Updated 3-Jan-18 0:47am

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

You have to restore it scratch.

restore the db with fresh backup file because log was not restored properly.

this happens when you stopped the restoring process mid way.
   
Comments
Member 13338075 2-Jan-18 22:29pm
   
Yes, the restoring process is mid way and i want the solution to with queries when the fresh db backup is deleted or not stored in the storage. Is there a possible way to run the queries to get the database normal?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100