Back Up Hosted SQL Server

I have an SQL Server that was setup by my host and I was wondering if there was any way to save or backup the remotely stored SQL 2000 Database on my local computer? I currently have SQL 2000 running on my local computer. If there is a site out there that explains everything to me like a child that would be great also.

This is probably not very simple. The SQL Server configuration usually shares the backup area across databases. This means that when you backup your database it will be backed up in the same folder as everybody elses. Obviously, it's not very wise for your ISP to give you FTP access to this folder because you could grab other user's backup files

There are tools available for backing the files up. However, I guess if you are using shared hosting you are operating on a shoestring budget and can't afford £££££s for what might be considered non-essential utilities. The other alternative is to use the Export tools to export the data. However, it's not very easy to set-up a schedule for this and it might be a real burden trying to sort this out

Let's hope you get a few more suggestions from some real SQL gurus here - I'm just an amateur!

If you have a local server, and if you can get to your hosted server over the Internet, DTS works well.

Set up a matching database on your local sql server with matching users and permissions to your hosted server. Then create a DTS job tha imports objects and data from your remote server to your local database. If you are running SQL Agent you can do like I do, schedule the backup DTS job to run in the wee hours of the AM.