Hi,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 recoveryI 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..Pols.
delete database without deleting restore history from SSMS, it will delete in a snap.