my db name is abc.. i hv restored the bckup on tht db.. But in middle i have cancleed the restoration..
After refreshing the respective db, i am getting as db is in 'restoring' position.
once i cancelled the restore command in middle,it should not restore right.. why iam getting as still it is restoring state?
i hv executed: restore database abc with recovery
I am geting as 'The database cannot be recovered because the log was not restored.'
Now i dont hv old backup to continue my restoration.
how to bring that db in normal state?pls help..