Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The database cannot be recovered because the log was not restored. Expand / Collapse
Author
Message
Posted Monday, January 11, 2010 1:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 6, 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
Posted Monday, January 11, 2010 2:15 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:13 AM
Points: 40,609, Visits: 37,070
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
Posted Wednesday, August 8, 2012 6:54 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:49 AM
Points: 62, Visits: 326
How to cancel restoring state of database ??
Which is hanging state in mssql server instance..
Post #1341829
Posted Thursday, August 9, 2012 1:43 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:10 PM
Points: 1,322, Visits: 2,937
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
Posted Friday, August 10, 2012 12:08 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:49 AM
Points: 62, Visits: 326
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
Posted Friday, August 10, 2012 12:24 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:49 AM
Points: 62, Visits: 326
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 »

Add to briefcase

Permissions Expand / Collapse