Rafael Copquin
2018-09-10 20:33:32 UTC
I am using the free tool (SQL Back Up Master) to perform backups of the
different SQL Server databases.
I installed it in my clients's computers, admonishing them to back up their
work every day, so I would not be responsible if any data loss occurs.
Most of my clients use it with no problems, but sometimes, they "forget" to
do their daily backup. (they are just too lazy or too much in a hurry to go
home after work, to spend the few minutes it takes to do the back up)
So I was thinking of embedding a back up routine in my app that would fire
when they shut down the app.
My idea is to call a stored procedure to do the backup.
However I do not know how to write such a procedure.
Could you help me on this, please?
Basically I want the database to be zipped (as SBM does) and send it to any
cloud repository, such as dropbox, google drive, one drive or an ftp site
Thanks
Rafael Copquin
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAHM-jJ2Ho+UoNeGDR_OEo5C3ycaX9ViUn22c2g=***@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
different SQL Server databases.
I installed it in my clients's computers, admonishing them to back up their
work every day, so I would not be responsible if any data loss occurs.
Most of my clients use it with no problems, but sometimes, they "forget" to
do their daily backup. (they are just too lazy or too much in a hurry to go
home after work, to spend the few minutes it takes to do the back up)
So I was thinking of embedding a back up routine in my app that would fire
when they shut down the app.
My idea is to call a stored procedure to do the backup.
However I do not know how to write such a procedure.
Could you help me on this, please?
Basically I want the database to be zipped (as SBM does) and send it to any
cloud repository, such as dropbox, google drive, one drive or an ftp site
Thanks
Rafael Copquin
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAHM-jJ2Ho+UoNeGDR_OEo5C3ycaX9ViUn22c2g=***@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.