November 26, 2019 at 2:13 pm
Hello dears, I have dropped all tables in database and I have no backup. I was trying several tools, the best results I had with ApexSQL Restore but trial version is restoring every of ten rows and buying licence for me is too expensive (one licence is as 4x my whole monthly income).
Can someone (who have licensed ApexSQL Restore) restore me the data? I will pay for it, let tell me your price and I will send you .mdf and .ldf file. The best is contact me at radek.jancik@sunamo.cz.
Database model was Simple.
It's not be only ApexSQL, but any other tool/way which can restore dropped tables. Or if someone know less expensive tool up to 100 USD, please tell me too.
Thanks very much
November 26, 2019 at 3:12 pm
I am pretty sure that that would violate the license terms for any tool that is out there.
I highly doubt you will find anyone willing to do this for you with a tool that they have licensed. I imagine your best bet would be to open the mdf in a hex editor after creating a backup and see if you can figure out what data belongs where and recreate things.
If you have VSS turned on in windows, you may be able to recover from a snapshot that windows was handling?
Failing both of those options, you may be stuck attempting to recreate the data manually.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
November 26, 2019 at 3:29 pm
bmg002:
I think it's legal. Developer had bought licence and it's only his decision, for what activity it will be use. It's one-time action for poor (and fool) student, then I will set up backup with VSS. When no one will help me and other tryings will fail, I will have to really do it manually in hex notation :/
Unfortunately, SQL Server Agent service was turned off.
November 26, 2019 at 4:16 pm
I would not recommend using VSS for a backup strategy personally. SQL has a built in backup tool; I would use that.
As for the legality of using the tool that way, I am not certain it can be used for that. I am pretty sure that software vendors for tools like that don't let you buy the tool then sell the services the tool offers. But I could be mistaken on that.
That being said, ApexSQL Restore was discontinued back in 2017. And from reading about the tool here:
https://knowledgebase.apexsql.com/apexsql-restore-evaluation-guide-first-time-users/
My understanding is that having the mdf and ldf is not going to be enough. You will need a backup to restore from. To quote the website:
ApexSQL Restore is a SQL Server tool that attaches both native and natively compressed SQL database backups and transaction log backups as live databases.
So, as long as you have a valid backup, you should be able to get the data back without using ApexSQL Restore.
Was also thinking about the hex editor method and rethinking about that, I don't think that will help you. The data is likely gone unless you have some backup to restore from.
But maybe one of the other experts on here will have a better suggestion for you? I am pretty sure that without a valid backup, there is not going to be a good solution.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply