Paul_Blackler
asked on
Can I use SQL Server to backup, zip and ftp - as a one button process
Hi
I have a requirement to backup a database, shrink it, zip it and ftp to a server all as one process (me thinks here this is going to be command line stuff) - does any body have any ideas on how to accomplish this.
Thanks
Paul
I have a requirement to backup a database, shrink it, zip it and ftp to a server all as one process (me thinks here this is going to be command line stuff) - does any body have any ideas on how to accomplish this.
Thanks
Paul
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
in theory, if there is commandline access to the FTP prog, there should be no problem.
i personally just have objections to the use of cmdExec from a security perspective.
i personally just have objections to the use of cmdExec from a security perspective.
ASKER
Thanks both of you
Paul
Paul
ASKER
Thanks