Good afternoon, everyone!
In SQL Server 2008, I needed to do a conversion in the database of one of our clients and was going to back up in case there was a problem, but I mistakenly pressed for a restore and for lack of attention I gave "Ok" just when I pressed the button I noticed that I was restoring and pressed the action "Stop Action Now" he stopped and gave a message saying that the user had canceled the action. So far so good, but when I went to do the backup it really did not let me say that there was already a restore for that database and when I saw the DB it was in Restore mode. I searched the internet and saw that it was to execute the following query: RESTORE DATABASE DatabaseName WITH RECOVERY
But before running I asked my boss if he could run this query there and he said it was not to do because he would restore to the most recent backup (and the most recent one is on 23/08). So we only have the MDF and LDF file of the client, but when we try to make an attach it gives the following error:
Msg 1813, Level 16, State 2, Line 1 Could not open the new database 'DataXXX'. CREATE DATABASE was aborted. Msg 9004, Level 21, State 1, Line 1 Error processing log for database data 'DataXXX'. If possible, restore from backup. If there is no backup available, you may need to re-create the log.
I researched this error in google as well and saw that it is necessary to re-create the log, but no one here in the company has this knowledge. I would like to know if anyone here has ever had this situation have any knowledge to help.
Thank you in advance.