search

adzm / mssqlPipe

SQL Server command line backup and restore through pipes using stdin and stdout
GNU General Public License v3.0
13 stars 6 forks source link

adhoc sql support #3

Open gfody opened 6 years ago

gfody commented 6 years ago

instead of trying to wrap all the various options for backup and restore, just allow a backup or restore statement and replace {device} with the virtual device name. e.g.:

mssqlPipe backup "backup log mydb to virtual_device='{device}' with differential, encryption algorithm=aes_128"

this is a lot easier to use from a SQL Agent job than using pipe to and a separate query, at least I couldn't figure out how to get SQL Agent to start a query after starting a command that doesn't return.

adzm commented 4 years ago

This is a really great idea. I'll try to merge this before too long while checking backwards compatibility.

gfody commented 4 years ago

fwiw I've been running this version in prod for ~2yrs with no issues. we're shipping logs to/from s3 every 5min and streaming nightly diffs and weekly full backups to s3 and restoring them each morning on a staging environment all thru mssqlPipe.

avonwyss commented 5 months ago

fwiw I've been running this version in prod for ~2yrs with no issues.

@gfody Since this was not yet merged, would you happen to have a binary to share?