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

Question

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

pols

SSC Eights!

Points: 935
More actions
January 11, 2010 at 1:49 am

#215312

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.

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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 More actions · Answer 2

How to cancel restoring state of database ??

Which is hanging state in mssql server instance..

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 3

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 More actions · Answer 4

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 More actions · Answer 5

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: 383 More actions · Answer 6

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 More actions · Answer 7

This reply has been reported for inappropriate content.

geek squad appointment |

best buy geek squad appointment |

geek squad appointment scheduling |

schedule a geek squad appointment online |

schedule geek squad appointment |

geek squad in home appointment