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

[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