I accidentally restored an SQL Server database from the wrong backup using the following statement:
RESTORE DATABASE [" + conn.Database + "] FROM DISK='" + path_backup + "'"
This is the exact query I used. I'm not an expert, so I don't really know why this worked, but it actually did.
I did not use
REPLACE. Is there any way that I can rollback to previous state of the database? I've read that
REPLACE overwrites the database, does this mean that if I don't use it, there is a copy somewhere?