0
Good afternoon to you all!
In SQL Server 2008, I needed to do a database conversion for one of our clients and I was going to do the backup in case there was a problem, only I mistakenly pressed to do a Store and by inattention I gave "Ok"at the very moment I pressed the button I noticed that I was doing Store and pressed the action "Stop Action Now" it stopped and gave a message saying that the user had canceled the action. So far so good, only that when I went to take the backup really it did not leave saying that there was already a restore to that database and when I saw the BD was in "Restoring" mode. I searched the internet and saw that it was to run the following query: RESTORE DATABASE Nomedatabase WITH RECOVERY
But before running I asked my boss if I could run this query there and he said that it was not to do because it would restore to the most recent backup (and the most recent is the day 23/08). So we only have the client’s MDF and LDF file, but when we try to make an attach it gives the following error:
Msg 1813, Level 16, State 2, Line 1 Could not open new database 'Dadosxxx'. CREATE DATABASE has been nullified. Msg 9004, Level 21, State 1, Line 1 Error processing log to database 'Dadosxxx' data. If possible, restore from the backup. If there is no backup available, it may be necessary to recreate the log.
I researched this error on google also and saw that it is necessary to recreate the log but nobody here in the company has this knowledge. I wonder if anyone here has ever been in this situation has any knowledge to be able to help.
Grateful from now on.
This Store you made by mistake was of what type? Because it is even possible to do the Restore for a "moment" of time, when you have a full backup + a Log file
– Alexandre Cavaloti
Hello! The image follows: https://i.imgur.com/eOwWS41.png
– Alcofra
Try to make a new Store, for a new base, not to lose the data from the current base. And in the "to a point in time" field, click on the "..." button and see what options the log gives you, in the new window, see what is the most recent point in time that the database can be restored.
– Alexandre Cavaloti
So.. Then we have a problem, my boss made a detach on this base that gave problem, and then deleted to try to make a Store by MDF. Can I do it anyway?
– Alcofra
Then I don’t think so. Because you didn’t get to Tachar again it’s not?
– Alexandre Cavaloti
No, every time I tried to make the attach I’d make the mistake that was quoted up there :/
– Alcofra