Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re^2: Backup Sql databse

by tobyink (Abbot)
on Feb 02, 2012 at 11:04 UTC ( #951411=note: print w/replies, xml ) Need Help??


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.

Replies are listed 'Best First'.
Re^3: Backup Sql databse
by marto (Bishop) 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.

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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://951411]
help
Chatterbox?
[haukex]: $? and system - the exit code of a process is stored in the upper bits of $?, so >> 8 does a bit shift to get at it
[hippo]: (truncating)
[erix]: aah, yes haukex++
[hippo]: Re: DBD::Sqlite queries slow - and gives wrong results has 6 upvotes. Is everyone quite well?
[erix]: hippo I think the 26 downvotes sick
[erix]: eh, 29 downvotes
[erix]: but I guess there's no stopping the herd
[1nickt]: Thank you haukex and hippo. I'm thinking of using IPC::System:: Simple::capture instead. But will go reread Hauke's treatise first :-)

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (9)
As of 2017-12-13 11:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What programming language do you hate the most?




















    Results (359 votes). Check out past polls.

    Notices?