I accidentally restored an sql server database from a backup file and lost all my previous data. I did not have any backup but I read that some third party software (like apexSQL) can retrieve some data by reading the transaction logs. However, if restoring the database has also overwritten the transaction log file, this operation is pointless.
So my question is: does restoring a database from a backup file also overwrite the transaction logs or just append to it.