Re^2: Backup Sql databse

in reply to Re: Backup Sql databse
in thread Backup Sql databse

Indeed - backups are the kind of thing cron jobs (or on Windows, Scheduled Tasks) were invented for.

dmsparts appears to be using Microsoft SQL Server. There are facilities for scheduling regular backups of a database built right into the SQL Server management console.

Comment on Re^2: Backup Sql databse

Replies are listed 'Best First'.
Re^3: Backup Sql databse by marto (Cardinal) on Feb 02, 2012 at 11:32 UTC
While such facilities exist I think it's clear that OP wants to do this dynamically (not as a scheduled task) and remotely. The TSQL method seems like a reasonable solution to this.	[reply]
Re^3: Backup Sql databse by mje (Curate) on Feb 02, 2012 at 11:43 UTC
If you are using SQL Server Express I believe Maintenance Plans are not available.	[reply]

In Section Seekers of Perl Wisdom