January 11, 2010 at 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 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.
January 11, 2010 at 2:15 am
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
August 8, 2012 at 6:54 am
How to cancel restoring state of database ??
Which is hanging state in mssql server instance..
August 9, 2012 at 1:43 pm
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.
August 10, 2012 at 12:08 am
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..
August 10, 2012 at 12:24 am
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..
October 18, 2017 at 3:27 am
pols - Monday, January 11, 2010 1:49 AMHi,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.
November 19, 2019 at 4:38 am
This reply has been reported for inappropriate content.
best buy geek squad appointment |
geek squad appointment scheduling |
schedule a geek squad appointment online |
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply