hello, I am looking for some freeware sql backup program I can use to connect to a host and backup the sql database I got there, and I want to be able to store the backp locally on my computer.

Anybody know a program for this? Should be freeware, and I am connecting to a mssql database. I have found some programs but so far none that works like I hope, most of them only make backups of an sql server installed locally on the computer, not able to connect to a host.

This is a program that is the closest I have got so far,http://datadmin.com/ but it gives me some error message so I`m looking for something else...

To connect to MS SQL remotely you need to have TCP access to the SQL server for a start.
What is the error you get?

Originally Posted by chrishirst

To connect to MS SQL remotely you need to have TCP access to the SQL server for a start.
What is the error you get?

this is the error message I get,
invalid object name sys.tables
invalid object name sys.objects
invalid object name sys.assembly_modules
invalid object name sys.triggers
invalid object name sys.sql_modules
invalid object name sys.system_sql_modules
invalid object name sys.schemas.

but I think that this has something to do with the program I have found. I have no problem connecting to the database, it is when I try to start the backup it fails... so I`m looking for another program if anyone knows...

if anyone else should need the same, a nice and free sql backup program can be found here.
http://datadmin.com/index.php?section=download&lang=en

I had to download a beta version, there was no support for sql 2000 in the version I tried first, therefor I got some error messages.