I have a database that is stuck in restore mode and I want to stop the restore process so I can start it over after making some updates/fixes. thanks.
I tried running "Restore database [dbname] with recovery" but this did not work and I got the following error "The database cannot be recovered because the log was not restored."
any help would be appreciated.
Kill the SPID. Has happened with me a few times.
SP_WHO2 Active
KILL SPID
Once killed, restart your restore process and you should be able to do it without any hiccups. Hope this helps.
Thanks,
S
It looks like you may have some log backups that need to be restored. Is this part of log shipping or mirroring? Has there been a recent failover from primary to this server?
Did the server recently reboot during a heavy transaction?
Please provide errors from the error logs.
