automate database backup?

[seongbae]

Hi,

Is there a way to automate database backup for mssql? I have a server and I want to use it to automatically download database backups from jodohost every x days.
Thanks.

Seong Bae

 

[fortress]

Sure. I do it every day.

On my SQL server, I wrote a DTS script to mirror the JodoHost database to my SQL server at my office. Then I scheduled the script to run each evening.

Then, I back up my office SQL server using normal backup tools.

Here's links for documentation: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_tools_wiz_8vsj.asp

 

[Mio]

Sure. I do it every day.

On my SQL server, I wrote a DTS script to mirror the JodoHost database to my SQL server at my office. Then I scheduled the script to run each evening.

Then, I back up my office SQL server using normal backup tools.

Here's links for documentation: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_tools_wiz_8vsj.asp

Can you please post sample DTS script for i can edite and use ?

Thank's

 

[seongbae]

ah.. i thought of that but my options are limited because i don't have sql server installed on my server and i don't plan to. if i can't find any other tools, then my last choice would be installing sql server.
thanks.

seong