The database cannot be recovered because the log was not restored.

  • pols

    SSC Eights!

    Points: 861

    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 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..

    Pols.

  • Gail Shaw

    SSC Guru

    Points: 1004484

    Restore it from scratch.

    You cancelled the restore part way through so the entire database was not restored. That cannot be brought online. Drop it, get a fresh backup and restore completely, this time not killing the restore part way through.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • dineshvishe

    SSCrazy

    Points: 2308

    How to cancel restoring state of database ??

    Which is hanging state in mssql server instance..

  • Summer90

    SSC-Dedicated

    Points: 32835

    dineshvishe (8/8/2012)


    How to cancel restory state of databaase..

    It is stuck in this state since you canceled the restore. Once a restore has been started you cannot undo what the restore has begun... there is no rollback a restore process so it is left in a hung state.

    About all you can do is get another good backup and restore it from that.

  • dineshvishe

    SSCrazy

    Points: 2308

    Restoring state is still hang then go right click and Delete option there.You can option with close with connection..select as per your requirement..

  • dineshvishe

    SSCrazy

    Points: 2308

    before restoring backup check following...

    restore verifyonly from disk ='E:\bk_full_datacenter\test1.bak' --The backup set on file 1 is valid.

    restore labelonly from disk ='E:\bk_full_datacenter\test1.bak'-- media related information

    restore filelistonly from disk ='E:\bk_full_datacenter\test1.bak'--list filegroups in backup

    restore headeronly from disk ='E:\bk_full_datacenter\test1.bak' --see compatiblity level and software version

    then try to restore backup..

  • appalaraju_k-596051

    Old Hand

    Points: 323

    pols - Monday, January 11, 2010 1:49 AM

    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.

  • jennrani0804

    Grasshopper

    Points: 14

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply