How to restore .bbk file to SQL!!!!!

Question

Post reply

How to restore .bbk file to SQL!!!!!

cm62597

SSC Eights!

Points: 976
More actions
January 15, 2009 at 5:59 pm

#196144

I have .bbk file is there a way I can import or restore to SQL server....so i can extract the data.:hehe:

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

What's a .bbk file? It's not the standard extention for a SQL backup (though that doesn't mean it isn't a sQL backup)

Where did you get the file? How was it created?

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

Have you tried using RESTORE? While the standard extension for a Native SQL Backup is .bak you can use any extension you want and it will restore using RESTORE.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Jerry Hung SSChampion Points: 12968 More actions · Answer 3

Try to read the file, if it lists logical names, it's a SQL Native Backup and you can restore from it

RESTORE FILELISTONLY FROM DISK = '\\filepath\filename.bbk'

SQLServerNewbieMCITP: Database Administrator SQL Server 2005

cm62597 SSC Eights! Points: 976 More actions · Answer 4

I get the following error....Server: Msg 3242, Level 16, State 1, Line 1

The file on device 'F:\ponic.bbk' is not a valid Microsoft Tape Format backup set.

I guess there is no way to restore this file then.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

You may be able to if you can find out what was used to create the backup. Backup Exec, Litespeef, RedGate SQLBackup are all possibilities. Where did you get it from?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

cm62597 SSC Eights! Points: 976 More actions · Answer 6

I got this backup file from some accounting software I use.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 7

Do you have any support (even online)?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

2005_DBA Mr or Mrs. 500 Points: 524 More actions · Answer 8

I think this is the error message related to corrupted backup.

Possible that backup is corrupted.

EdVassie SSC Guru Points: 60476 More actions · Answer 9

If the accounting software created the backup, it probably has a tool to restore its backup. If so, you will need to use that tool to do the restore.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Big Data Man SSCrazy Eights Points: 8536 More actions · Answer 10

cm62597 (1/15/2009)
I have .bbk file is there a way I can import or restore to SQL server....so i can extract the data.:hehe:

Hey,

If you are restoring via the GUI, make sure you select "disk", as you may have selected tape, which would generate this error.

Thanks,

Phillip Cox

birendra-993989 Newbie Points: 1 More actions · Answer 11

birendra-993989

Newbie

Points: 1

February 13, 2009 at 6:19 am

#943497

Try restoring from database restore GUI.