Free tool to Backup/restore Databases remotely?

Hi i've tried a few remote administration tools including Microsofts own Web Data Administrator for SQL server... but none of them seem to do what is essential to me and that is backup/restore databases to a file.

The only tool that seems to do it is myLittleAdmin but it's very expensive.

Does anyone know of a free tool that can just backup/restore databases. I dont really want to have to use export/import data as things like triggers get lost when using it with these remote programs.

Thanks

You can control DTS from ASP pages (or call a stored procedure) and obtain a remote backup utility.

From what ive been reading I should be able to use the query tool in web data administrator using the following syntax:

BACKUP DATABASE DBNameGoesHere
TO DISK = 'C:\temp\Somefilename.bak'
WITH INIT

RESTORE DATABASE DBNameGoesHere
FROM DISK = 'C:\temp\Somefilename.bak'
WITH REPLACE

This works with the standard query analyzer tool so I assume it works with the remote query tool also?

Hi there,

You can try out Shawman Backup Management System V 2 which is absolutely free and can be obtained from www.shawmansoftware.com.

Do let me know if this tool works out for you. I personally use this tool to backup and restore database.

In case you find any problem downloading this tool, you can write to hris@shawmansoftware.com intimating the same.

Good Luck,
Sufiyan