Can also happen if someone starts a restore and stops the restore part way through (perhaps realising they were restoring over the wrong DB).
Could you tell me what to do in this situation? Is there anyway to recover the victimized database? Did the restore not roll back when they hit cancel?
Drop the partially restored DB and start the restore from scratch. The DB that got restored over is gone.
Restores can't be run in a transaction and the first thing they do is start overwriting the file on disk
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