Re: Backup in SQL Server
SQL Server 2012 Express Rafael El 11/09/2018 a las 10:18, Stephen Russell escribió: What type of SQL Server version are you using? sql server backup maintenance plan scheduled backup part-1 https://www.youtube.com/watch?v=K_0LDFsvQyQ On Mon, Sep 10, 2018 at 3:34 PM Rafael Copquin wrote: 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 --- [excessive quoting removed by server] ___ Post Messages to: ProFox@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/202bfc19-0604-90a0-24d1-fa2a0df7e...@yahoo.com.ar ** 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.
Re: Backup in SQL Server
What type of SQL Server version are you using? sql server backup maintenance plan scheduled backup part-1 https://www.youtube.com/watch?v=K_0LDFsvQyQ On Mon, Sep 10, 2018 at 3:34 PM Rafael Copquin wrote: > 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 > --- > [excessive quoting removed by server] ___ Post Messages to: ProFox@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/cajidmylc92f94gygbnhhhnk2dqovlpt+evzq57k91hourhx...@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.
Re: Backup in SQL Server
I'd probably automate it with a SQL Server Agent job. https://www.serverintellect.com/support/sqlserver/scheduled-db-backup-plan/ -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@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/1536663618.2621981.1504066376.3efa9...@webmail.messagingengine.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.
Re: Backup in SQL Server
If you want to go the route of writing your own code, the backup syntax is here: https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-2017 On 10 September 2018 16:33:32 GMT-04:00, Rafael Copquin wrote: >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 >--- > [excessive quoting removed by server] ___ Post Messages to: ProFox@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/c9f8b9d0-d61e-487b-9e00-20fcfc29c...@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.
Re: Backup in SQL Server
I use SQL backup and FTP which is free for up to 2 databases. You can schedule backups to run automatically and it zips up the backup. On 10 September 2018 16:33:32 GMT-04:00, Rafael Copquin wrote: >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 >--- > [excessive quoting removed by server] ___ Post Messages to: ProFox@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/17deac0a-9a31-4ca3-b499-0b78a7371...@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.
Backup in SQL Server
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: ProFox@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=10616wwu...@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.