Restoring database on my localhost

Hi there,

I am using VWD and have my production website hosted elsewhere. The hosting company provides a backup service that allows me to download a something.bak file as the backup of my website. My query is: how to export or copy the data in the something.bak file into the database on my own computer? Can anyone helps please?

Thanks in advance.

Why you want to use .bak file. Just connect you sql server to remote database using enterprise manager and import the database from remote server to your server.

Please let me know if you have any doubt.

|||

Thanks for your response.

I am not familiar with SQL server. I am using .bak because the backup service provided by my hosting company uses this method. BTW, what I have is just a VWD. Where can I get the enterprise manager?

Regards.

|||

you can download SQL Management studio expresshere. You need external database access from your hosting company, I suggest contacting your hosting company for more information.

Regards Frederik