Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a .bak file from an SQL Server database on an old hosting account, is there any way to view this file with an application on Mac OS X? All I need to do is get the data out of it.



EDIT: I see that you can't read the file on Mac OS, however is there a relatively easy way to split the .bak file into it's component .mdf and .ldf files? A Mac solution is preferable but anything that doesn't require SQL Server to be installed is good. Thanks.

share|improve this question
up vote 4 down vote accepted

Short answer: No.

There is a similar question on Stackoverflow that is somewhat related.

The .bak file is actually two files in one - a .mdf (data) and an .ldf (logs)

If you are somehow able to load the .bak file back into SQL Server you could then export a format that could be read.

Alternatively you can always try opening it in your favourite text editor (eg. TextMate, TextWrangler, BBEdit, emacs, vim, etc.) and see what information you can pull from the file.

share|improve this answer
Alright, that's sort of what I thought, I have had some success with a text editor, thanks. – Kyle Aug 5 '09 at 5:40

Easiest thing to do is fire up your copy of parallels/vmware fusion or bootcamp with your favourite version of Windows and install SQL Server Express and do a restore.

As long as your database isn't bigger then 4GB you should be ok. If not, get your hands on SQL Server 2008 Developer.

You may have some success with Redgate Data Compare which can read .bak files. You may be able to trick it into generating SQL statements without SQL Server from the .bak, but you'll still need Windows.

share|improve this answer

No you can't. There's no software for the Mac that can read the file. You'd have to restore the database to a SQL Server of the same version of higher to get anything useful out of it.

You could read it in a text editor, as the bulk of the data is in plain text, but you won't get much out of it.

share|improve this answer

Your Answer


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.