Free tool to Backup/restore Databases via the web?

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.

Could I perhaps do it using stored procs and asp.net? Or 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

use DTS.
creat a DTS package, which u can run by asp.net
dipit

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.

Within Sql Server you can create DTS Packages, like dip said, that will do all of this for you, then once you have the DTS packages created, you can just schedule them to run at certain times.

Thanks for the info.

I simply just wanted to be able to work on the db at home, so I can just grab it from the work webserver any time.

I have managed to do it using the TSQL statements above no probs.

I had a quick look at DTS packages just now, im not sure how you would execute a DTS package over the web either... though I do see theres an FTP task.

If you have Sql Server installed at home, then you could set it up as a linked server, or just register it in enterprise manager.