Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a BKS file that is around 20GB. How do I extract the MSSQL files from that?

Thanks

share|improve this question
1  
I didn't think BKS files contained the actual data, just a list of what data was to be backed up? –  RobM Jun 4 '10 at 17:18
    
Thanks Robert. Thats what I thought too. But the BKS is 20GB so i suspect it has the data. –  ServerDown Jun 4 '10 at 17:29
add comment

3 Answers

If the backup was created using ntbackup, you'd need to restore all or selected files from it using the Backup and Restore Wizard. If you trying to determine which files to restore, the SQL databases typically live in files with file extensions of MDF, LDF and NDF though that's not a requirement.

I'm not sure if ntbackup guarantees database consistency when doing backups, so it's possible the database would not restore cleanly.

share|improve this answer
    
Thanks SqlACID. But I cant use the BKS file in the restore. the ntbackup only allows the BKF file to be selected for restoring. Any other way to extract data from BKS files? –  ServerDown Jun 4 '10 at 17:06
add comment

I wonder if the backup was accidentally saved as a BKS file? A "real" BKS file would open in Notepad and be readable. You could try to open the file in Notepad and if it is human-readable, it doesn't contain your data. Else, you could change the extension to BKF and see if NTBackup will restore it.

share|improve this answer
    
I have to agree with this. After all, what's the worse that can happen. –  RobM Jun 4 '10 at 18:35
    
Notepad won't open a 20GB file, either use something like EditPad, or a hex editor (HxD is good). –  Dentrasi Jun 4 '10 at 19:46
add comment
up vote 0 down vote accepted

It was actually a BAK file. Just run the standard restore database and point to the bks file.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.