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
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: Technical documentation | Microsoft Learn
Can you please post sample DTS script for i can edite and use ?
Thank’s
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