Hi, currently I have a shared web hosting with MS SQL server 2000 database.
I have already implemented the database, with all the data inside the database, on the server.
Now I wish to copy the whole database (.mdf) down to my PC, in case I wanna change hosting or in case the server broke down, and keep it as a safe backup.
I already created a backup of it, the .bak file, but it is all stored in the web hosting database server.
How can I actually copy the whole thing down to my pc ?
I am using Microsoft SQL Server Management Studio Express.