July 9, 2014 at 6:29 pm
Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes here, when I try to to restore my .bkf file, it becomes inaccessible.
Does anyone know what causes this? I'm suspecting corruption here (it's just a suspicion as I'm not sure). Please help me. The copies of my databases are very crucial.
Many thanks in advance.
July 9, 2014 at 9:53 pm
chengchong36 (7/9/2014)
Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes here, when I try to to restore my .bkf file, it becomes inaccessible.Does anyone know what causes this? I'm suspecting corruption here (it's just a suspicion as I'm not sure). Please help me. The copies of my databases are very crucial.
Many thanks in advance.
We can't help you without knowing the step(s) you take and the error(s) you receive. Details please.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 9, 2014 at 11:33 pm
This was removed by the editor as SPAM
July 10, 2014 at 12:04 am
chengchong36 (7/9/2014)
Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes here, when I try to to restore my .bkf file, it becomes inaccessible.Does anyone know what causes this? I'm suspecting corruption here (it's just a suspicion as I'm not sure). Please help me. The copies of my databases are very crucial.
Many thanks in advance.
After backup, have you checked the backup consitenency or verify backup?
Please check backup with: RESTORE VERIFYONLY - http://msdn.microsoft.com/en-IN/library/ms188902.aspx
Thanks
July 10, 2014 at 12:57 am
Don't ever append backups to the same file. If you do and there's damage to the header, you can lose all of the backups. Backups should go to individual files, preferably time-stamped with the date as part of the file header.
You should test your backups, make sure they restore. RESTORE VERIFYONLY is near-useless unless you take backups WITH CHECKSUM. It's not perfect even if you do.
What happens if you try to restore that backup (to a new database) WITH CONTINUE_AFTER_ERROR?
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
July 11, 2014 at 2:28 am
I don't think he's using native SQL backups here--isn't BE Backup Exec? The reference to a .bkf file suggests that as well. That being the case, definitely need more information on any errors reported during the restore process.
July 25, 2014 at 2:58 am
chengchong36 (7/9/2014)
Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes here, when I try to to restore my .bkf file, it becomes inaccessible.Does anyone know what causes this? I'm suspecting corruption here (it's just a suspicion as I'm not sure). Please help me. The copies of my databases are very crucial.
Many thanks in advance.
More than likely the backup media that Backup Exec wrote to is not catalogued or online. Consult your backup admin for more help
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2016 at 4:05 am
December 27, 2016 at 5:11 am
chengchong36 (7/9/2014)
Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes here, when I try to to restore my .bkf file, it becomes inaccessible.Does anyone know what causes this? I'm suspecting corruption here (it's just a suspicion as I'm not sure). Please help me. The copies of my databases are very crucial.
Many thanks in advance.
Microsoft SQL Server has no relation with Backup Exec. It's very clear that the backup is corrupt. As per my knowledge, I'm not aware of any free tool or manual trick to fix corruption from backup files. You should consult a data recovery expert which can perform recovery from corrupt backup. Or you can try a professional backup recovery tool to perform recovery by your own. You can download free demo version Backup Exec BKF Repair Pro tool. It supports SQL database recovery from corrupt backup files. I found this product on CNET - http://download.cnet.com/SysInfoTools-Backup-Exec-BKF-Repair-Pro/3000-2242_4-76150110.html
I hope it would be helpful here.
Regards.
December 27, 2016 at 5:30 am
This thread is over 2 years old!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2017 at 12:00 am
This was removed by the editor as SPAM
October 5, 2017 at 12:01 am
This was removed by the editor as SPAM
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply