February 21, 2017 at 4:04 pm
Hi and Thanks everybody for helping me and read this topic ,
i have huge problem , my server lost all files and deleted , now i get recovered file in good statement , but i can't restore .bak files , i get error
February 22, 2017 at 12:30 am
If you're getting that error, the backup is probably damaged and not restorable.
No backups of your server?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2017 at 2:50 am
Thanks for reply me, but i don't have any other backup, how can fix this damaged database?
Please help me this is very very important for me, this is whole year money about income and spend for my little company, thanks
February 22, 2017 at 2:57 am
You probably can't. If the backup's damaged to the point you're getting that error then it's likely to be unusable.
The other possibility is that you're trying to restore it to an earlier version of sQL Server, eg trying to restore a 2012 backup to SQL 2005.
What do RESTORE VERIFYONLY and RESTORE HEADERONLY return for that backup file?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2017 at 5:01 am
My Backup Belong to SQL Server 2008 R2 and i'm trying restore to 2008 R2 also , but i can't , please give me a way to fix damaged database , my Database set as UTF-8 , recovered my database completely without losing 1 kb , the size exactly same as original , but i can't restore database , can you help me ?
please please please , please 10000 times help me
February 22, 2017 at 5:06 am
If the backup is damaged enough that SQL's throwing a media family error, the backup is likely to be garbage and unusable, and there's no magic 'fix backup' command that can be run.
Again, what do RESTORE VERIFYONLY and RESTORE HEADERONLY return for that backup file?
Look on other servers, see if there are any old backups that you can restore, or copies of the database in a dev environment or similar.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2017 at 6:38 am
Gail has given you step one, RESTORE VERIFYONLY. Here's a link to the command so you can work out how to do it.
Are you sure that what you're attempting to restore is a backup taken through the SQL Server BACKUP command? Maybe it's a different type of file?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 22, 2017 at 7:45 am
my Database set as UTF-8
I'm curious what is meant by that. I didn't know there was such a setting. To those that know, is this a clue as to why this might not be working? Is this even possible? Is it an indication that it's not actually an SQL Server backup?
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2017 at 7:57 am
Jeff Moden - Wednesday, February 22, 2017 7:45 AMmy Database set as UTF-8
I'm curious what is meant by that. I didn't know there was such a setting. To those that know, is this a clue as to why this might not be working? Is this even possible? Is it an indication that it's not actually an SQL Server backup?
That is interesting as I think it applies to MySQL.
Sue
February 22, 2017 at 8:04 am
Sue_H - Wednesday, February 22, 2017 7:57 AMJeff Moden - Wednesday, February 22, 2017 7:45 AMmy Database set as UTF-8
I'm curious what is meant by that. I didn't know there was such a setting. To those that know, is this a clue as to why this might not be working? Is this even possible? Is it an indication that it's not actually an SQL Server backup?
That is interesting as I think it applies to MySQL.
Sue
Precisely my thought. It doesn't sound like anything having to do with SQL Server especially since even BULK INSERT wasn't made to recognize UTF-8 until (IIRC) 2016.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2017 at 10:08 am
are these backups taken natively or via Litespeed or SQLBackup or some other 3rd party app.
Native restore will not recognise 3rd party backup files and it sounds very much like this is the case here.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 22, 2017 at 2:21 pm
Perry Whittle - Wednesday, February 22, 2017 10:08 AMare these backups taken natively or via Litespeed or SQLBackup or some other 3rd party app.
Native restore will not recognise 3rd party backup files and it sounds very much like this is the case here.
That is my thought too. I've seen that when I tried to restore a red-gate SQLBackup backup using the native restore tool when I was a completely new accidental DBA and didn't even really know how to do backups or restores.
If that isn't the case, do you have any other backups you can restore from? Better to lose a little bit of data than to lose everything.
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.
February 22, 2017 at 3:25 pm
i realized something , my server get virus and files split to two section , one file with .bak and one file .decrypt2017 , i'm wonder both file have same description , same size (mb) , same date and time , in this case any hope to fix this problem
https://1drv.ms/i/s!At8n1LALvdw3jWvkpeq0akJmbSLY
February 22, 2017 at 3:29 pm
AHMN48 - Wednesday, February 22, 2017 3:25 PMi realized something , my server get virus and files split to two section , one file with .bak and one file .decrypt2017 , i'm wonder both file have same description , same size (mb) , same date and time , in this case any hope to fix this problem
https://1drv.ms/i/s!At8n1LALvdw3jWvkpeq0akJmbSLY
That sounds like ransomware. If I am correct, your .bak file will be corrupted beyond repair unless you pay money to get the decryption tool and even then there is no promise that it can get decrypted.
Do you have any offsite backup or tape backup or anything?
Unless you are willing to pay money, you likely won't be getting that database back.
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.
February 22, 2017 at 5:43 pm
unfortunately there is no another backup here , all my backup in one external hard , with Easeus Partition Master 11 recovered anything in good state , but i don't have how can decrypt my files , i attached my files here can you check please and if can help me i will pay you money to restore my database
Thanks
placed two database .bak with same .decrypt2017
Thanks
https://1drv.ms/f/s!At8n1LALvdw3jW8mIqho5R3X4M9o
Viewing 15 posts - 1 through 15 (of 32 total)
You must be logged in to reply to this topic. Login to reply