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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » The database cannot be recovered because the...

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

Rate Topic

Display Mode

Topic Options

Author

Message

pols

Posted Monday, January 11, 2010 1:49 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 06, 2011 2:12 AM
Points: 27, Visits: 172

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.

Post #845222

GilaMonster

Posted Monday, January 11, 2010 2:15 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:25 AM
Points: 37,734, Visits: 29,999

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 2008, MVP
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

Post #845228

dineshvishe

Posted Wednesday, August 08, 2012 6:54 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 1:46 AM
Points: 44, Visits: 232

How to cancel restoring state of database ??
Which is hanging state in mssql server instance..

Post #1341829

Markus

Posted Thursday, August 09, 2012 1:43 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:14 AM
Points: 1,048, Visits: 2,216

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.

Post #1342977

dineshvishe

Posted Friday, August 10, 2012 12:08 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 1:46 AM
Points: 44, Visits: 232

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

Post #1343154

dineshvishe

Posted Friday, August 10, 2012 12:24 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 1:46 AM
Points: 44, Visits: 232

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

Post #1343160

« Prev Topic | Next Topic »

Permissions