MS SQL backup

Hi,

I just joined a company and we have a MS SQL database for our website. We are looking for a automated way to backup the databse regularly. The problem is that the database is at the hosting server but we would like to place the backup copy on our office server.

Is there any tool or script that would help us acomplish this?

I have worked on MYSql and am new to MS SQL. So any help would be highly appretiated.

thanks,
Ryan.

See this article:
http://web.zdnet.com.au/builder/arc...20274068,00.htm

For scheduling a backup so that it runs automatically, see "jobs, creating" in your SQL server Books Online

I have a hosted sql server db and use Data Transform Services (DTS) from a local SQL server to Pull the remote database to my local server.

Use OLEDB connections when you set up the DTS job, and copy objects & data. Don't use the default options, and choose not to copy object permissions & users.

Easiest is to set up your local server as a "clone" with the same username and password you have on the hosted server.

hi,

Thanks a lot for your help. Will try them out tomorrow. Will post here if I run into any more problems.

thanks,
Ryan