how can I restore a mbf file on SQL Server 2k

[kleinma]

I am used to using BAK files to backup and restore my database on SQL Server... but my webhost is giving me backups of my online SQL Server database in a fileformat of .mbf

I can't find any info on how to restore a database from an mbf file. Books online doesn't even find any matches on a search for mbf, and google doesn't turn up anything either. How can I go about restoring my database with this file. Its a complete backup, not a partial (if it matters)

[kleinma]

well just because I was out of ideas... I changed the file to .bak and what do you know.. but it worked to restore

[Hack]

well just because I was out of ideas... I changed the file to .bak and what do you know.. but it worked to restore

LOL. I was going to suggest that when I saw your second post.

Anyway, do you have any say with your webhost? It seems that the backup extension will only cause a minor problem, but if they can send it to you with the proper .bak extension, then changing the extension would be one less thing you would have to do when restoring.

[kleinma]

well what they did for me is actually pretty nice of them. The DB is backed up every hour, and they stick the backup file in a virtual directory on the webserver. I will then automate a download of this file a few times a day so in the event of a problem we can load the backup here on the local SQL Server and run off of that...

I also found out that if you specify "restore from a device" and then select file from there.. it doesn't matter what the extension is.. it will restore