Thread: [Mssqlcompressed-users] Batch-backup. How?
Brought to you by:
xclayl
Menu
▾
▴
mssqlcompressed-users
|
From: <ev...@me...> - 2011-05-13 12:20:21
|
I have a list of database-names in a file, and want to us msbp to make backups. msbp.cmd contains: ****************************************** @ECHO OFF for /F %%G in (OnlineDbs.txt) do msbp.exe backup "db(database=%%G)" "gzip()" "local(path=\\mp01-app-03\sz01-sql-01\%%G.bak.gz)" ****************************************** However, this does not seem to work... Is it my scripting, or msbp which is causing problems here? Greetings, Evert |
|
From: Clay L. <cl...@le...> - 2011-05-14 15:53:30
|
The msbp command looks correct to me. I don't know enough about batch files to say whether it is correct. On 13 May 2011 13:01, <ev...@me...> wrote: > I have a list of database-names in a file, and want to us msbp to make > backups. > msbp.cmd contains: > ****************************************** > @ECHO OFF > for /F %%G in (OnlineDbs.txt) do > msbp.exe backup "db(database=%%G)" "gzip()" > "local(path=\\mp01-app-03\sz01-sql-01\%%G.bak.gz)" > ****************************************** > > However, this does not seem to work... Is it my scripting, or msbp which > is causing problems here? > > Greetings, > Evert > > > > ------------------------------------------------------------------------------ > Achieve unprecedented app performance and reliability > What every C/C++ and Fortran developer should know. > Learn how Intel has extended the reach of its next-generation tools > to help boost performance applications - inlcuding clusters. > http://p.sf.net/sfu/intel-dev2devmay > _______________________________________________ > Mssqlcompressed-users mailing list > Mss...@li... > https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users > |
|
From: Shah, H. <Hem...@un...> - 2011-05-16 05:25:25
|
Hi Evert, The command is correct, but do not give Extra space between the parameters and it's value. Specifically, after backup, there is a 2 space. Also try and give the entire command on single line. Cheers, Hemang -----Original Message----- From: mss...@li... [mailto:mss...@li...] On Behalf Of ev...@me... Sent: Friday, May 13, 2011 5:31 PM To: mss...@li... Subject: [Mssqlcompressed-users] Batch-backup. How? I have a list of database-names in a file, and want to us msbp to make backups. msbp.cmd contains: ****************************************** @ECHO OFF for /F %%G in (OnlineDbs.txt) do msbp.exe backup "db(database=%%G)" "gzip()" "local(path=\\mp01-app-03\sz01-sql-01\%%G.bak.gz)" ****************************************** However, this does not seem to work... Is it my scripting, or msbp which is causing problems here? Greetings, Evert ------------------------------------------------------------------------ ------ Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ Mssqlcompressed-users mailing list Mss...@li... https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users |
|
From: <ev...@me...> - 2011-05-16 11:41:30
|
I have removed the extra space after 'backup', but no difference... (I do have the entire command on a single line. The email client broke it in two...) It's as if the %%G doesn't get converted into a DB-name... Greetings, Evert > Hi Evert, > > The command is correct, but do not give Extra space between the > parameters and it's value. > Specifically, after backup, there is a 2 space. > > Also try and give the entire command on single line. > > Cheers, > Hemang > > -----Original Message----- > From: mss...@li... > [mailto:mss...@li...] On Behalf > Of ev...@me... > Sent: Friday, May 13, 2011 5:31 PM > To: mss...@li... > Subject: [Mssqlcompressed-users] Batch-backup. How? > > I have a list of database-names in a file, and want to us msbp to make > backups. > msbp.cmd contains: > ****************************************** > @ECHO OFF > for /F %%G in (OnlineDbs.txt) do > msbp.exe backup "db(database=%%G)" "gzip()" > "local(path=\\mp01-app-03\sz01-sql-01\%%G.bak.gz)" > ****************************************** > > However, this does not seem to work... Is it my scripting, or msbp which > is causing problems here? > > Greetings, > Evert > > > ------------------------------------------------------------------------ > ------ > Achieve unprecedented app performance and reliability > What every C/C++ and Fortran developer should know. > Learn how Intel has extended the reach of its next-generation tools > to help boost performance applications - inlcuding clusters. > http://p.sf.net/sfu/intel-dev2devmay > _______________________________________________ > Mssqlcompressed-users mailing list > Mss...@li... > https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users > |
|
From: <ev...@me...> - 2011-05-16 12:07:29
|
Looks very promising _IF_ it is possible to have it select all online DB's only (ignoring the offline DB's). Is this possible? Greetings, Evert > I have written a small tool that allows me to backup all databases > without batch scripts, but an XML file. > May not be what you want, but it certainly works for me :-) > > http://sourceforge.net/projects/msbpm/ > > On 5/16/2011 1:40 PM, ev...@me... wrote: >> I have removed the extra space after 'backup', but no difference... >> (I do have the entire command on a single line. The email client broke >> it >> in two...) >> >> It's as if the %%G doesn't get converted into a DB-name... >> >> Greetings, >> Evert >> >> >>> Hi Evert, >>> >>> The command is correct, but do not give Extra space between the >>> parameters and it's value. >>> Specifically, after backup, there is a 2 space. >>> >>> Also try and give the entire command on single line. >>> >>> Cheers, >>> Hemang >>> >>> -----Original Message----- >>> From: mss...@li... >>> [mailto:mss...@li...] On Behalf >>> Of ev...@me... >>> Sent: Friday, May 13, 2011 5:31 PM >>> To: mss...@li... >>> Subject: [Mssqlcompressed-users] Batch-backup. How? >>> >>> I have a list of database-names in a file, and want to us msbp to make >>> backups. >>> msbp.cmd contains: >>> ****************************************** >>> @ECHO OFF >>> for /F %%G in (OnlineDbs.txt) do >>> msbp.exe backup "db(database=%%G)" "gzip()" >>> "local(path=\\mp01-app-03\sz01-sql-01\%%G.bak.gz)" >>> ****************************************** >>> >>> However, this does not seem to work... Is it my scripting, or msbp >>> which >>> is causing problems here? >>> >>> Greetings, >>> Evert >>> >>> >>> ------------------------------------------------------------------------ >>> ------ >>> Achieve unprecedented app performance and reliability >>> What every C/C++ and Fortran developer should know. >>> Learn how Intel has extended the reach of its next-generation tools >>> to help boost performance applications - inlcuding clusters. >>> http://p.sf.net/sfu/intel-dev2devmay >>> _______________________________________________ >>> Mssqlcompressed-users mailing list >>> Mss...@li... >>> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users >>> >> >> >> ------------------------------------------------------------------------------ >> Achieve unprecedented app performance and reliability >> What every C/C++ and Fortran developer should know. >> Learn how Intel has extended the reach of its next-generation tools >> to help boost performance applications - inlcuding clusters. >> http://p.sf.net/sfu/intel-dev2devmay >> _______________________________________________ >> Mssqlcompressed-users mailing list >> Mss...@li... >> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users > > |
|
From: Vinko V. <el...@vi...> - 2011-05-16 13:05:18
|
I just hacked a mode to do that. Let me know how it worked, testing wasn't very throrough On 5/16/2011 2:06 PM, ev...@me... wrote: > Looks very promising _IF_ it is possible to have it select all online DB's > only (ignoring the offline DB's). Is this possible? > > Greetings, > Evert > >> I have written a small tool that allows me to backup all databases >> without batch scripts, but an XML file. >> May not be what you want, but it certainly works for me :-) >> >> http://sourceforge.net/projects/msbpm/ >> >> On 5/16/2011 1:40 PM, ev...@me... wrote: >>> I have removed the extra space after 'backup', but no difference... >>> (I do have the entire command on a single line. The email client broke >>> it >>> in two...) >>> >>> It's as if the %%G doesn't get converted into a DB-name... >>> >>> Greetings, >>> Evert >>> >>> >>>> Hi Evert, >>>> >>>> The command is correct, but do not give Extra space between the >>>> parameters and it's value. >>>> Specifically, after backup, there is a 2 space. >>>> >>>> Also try and give the entire command on single line. >>>> >>>> Cheers, >>>> Hemang >>>> >>>> -----Original Message----- >>>> From: mss...@li... >>>> [mailto:mss...@li...] On Behalf >>>> Of ev...@me... >>>> Sent: Friday, May 13, 2011 5:31 PM >>>> To: mss...@li... >>>> Subject: [Mssqlcompressed-users] Batch-backup. How? >>>> >>>> I have a list of database-names in a file, and want to us msbp to make >>>> backups. >>>> msbp.cmd contains: >>>> ****************************************** >>>> @ECHO OFF >>>> for /F %%G in (OnlineDbs.txt) do >>>> msbp.exe backup "db(database=%%G)" "gzip()" >>>> "local(path=\\mp01-app-03\sz01-sql-01\%%G.bak.gz)" >>>> ****************************************** >>>> >>>> However, this does not seem to work... Is it my scripting, or msbp >>>> which >>>> is causing problems here? >>>> >>>> Greetings, >>>> Evert >>>> >>>> >>>> ------------------------------------------------------------------------ >>>> ------ >>>> Achieve unprecedented app performance and reliability >>>> What every C/C++ and Fortran developer should know. >>>> Learn how Intel has extended the reach of its next-generation tools >>>> to help boost performance applications - inlcuding clusters. >>>> http://p.sf.net/sfu/intel-dev2devmay >>>> _______________________________________________ >>>> Mssqlcompressed-users mailing list >>>> Mss...@li... >>>> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users >>>> >>> >>> ------------------------------------------------------------------------------ >>> Achieve unprecedented app performance and reliability >>> What every C/C++ and Fortran developer should know. >>> Learn how Intel has extended the reach of its next-generation tools >>> to help boost performance applications - inlcuding clusters. >>> http://p.sf.net/sfu/intel-dev2devmay >>> _______________________________________________ >>> Mssqlcompressed-users mailing list >>> Mss...@li... >>> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users >> > |
|
From: <ev...@me...> - 2011-05-16 13:23:19
|
Wow! :-) Sounds promising. Where can I find the docs on how to use your contraption? Greetings, Evert > I just hacked a mode to do that. Let me know how it worked, testing > wasn't very throrough > > On 5/16/2011 2:06 PM, ev...@me... wrote: >> Looks very promising _IF_ it is possible to have it select all online >> DB's >> only (ignoring the offline DB's). Is this possible? >> >> Greetings, >> Evert >> >>> I have written a small tool that allows me to backup all databases >>> without batch scripts, but an XML file. >>> May not be what you want, but it certainly works for me :-) >>> >>> http://sourceforge.net/projects/msbpm/ >>> >>> On 5/16/2011 1:40 PM, ev...@me... wrote: >>>> I have removed the extra space after 'backup', but no difference... >>>> (I do have the entire command on a single line. The email client broke >>>> it >>>> in two...) >>>> >>>> It's as if the %%G doesn't get converted into a DB-name... >>>> >>>> Greetings, >>>> Evert >>>> >>>> >>>>> Hi Evert, >>>>> >>>>> The command is correct, but do not give Extra space between the >>>>> parameters and it's value. >>>>> Specifically, after backup, there is a 2 space. >>>>> >>>>> Also try and give the entire command on single line. >>>>> >>>>> Cheers, >>>>> Hemang >>>>> >>>>> -----Original Message----- >>>>> From: mss...@li... >>>>> [mailto:mss...@li...] On >>>>> Behalf >>>>> Of ev...@me... >>>>> Sent: Friday, May 13, 2011 5:31 PM >>>>> To: mss...@li... >>>>> Subject: [Mssqlcompressed-users] Batch-backup. How? >>>>> >>>>> I have a list of database-names in a file, and want to us msbp to >>>>> make >>>>> backups. >>>>> msbp.cmd contains: >>>>> ****************************************** >>>>> @ECHO OFF >>>>> for /F %%G in (OnlineDbs.txt) do >>>>> msbp.exe backup "db(database=%%G)" "gzip()" >>>>> "local(path=\\mp01-app-03\sz01-sql-01\%%G.bak.gz)" >>>>> ****************************************** >>>>> >>>>> However, this does not seem to work... Is it my scripting, or msbp >>>>> which >>>>> is causing problems here? >>>>> >>>>> Greetings, >>>>> Evert >>>>> >>>>> >>>>> ------------------------------------------------------------------------ >>>>> ------ >>>>> Achieve unprecedented app performance and reliability >>>>> What every C/C++ and Fortran developer should know. >>>>> Learn how Intel has extended the reach of its next-generation tools >>>>> to help boost performance applications - inlcuding clusters. >>>>> http://p.sf.net/sfu/intel-dev2devmay >>>>> _______________________________________________ >>>>> Mssqlcompressed-users mailing list >>>>> Mss...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users >>>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> Achieve unprecedented app performance and reliability >>>> What every C/C++ and Fortran developer should know. >>>> Learn how Intel has extended the reach of its next-generation tools >>>> to help boost performance applications - inlcuding clusters. >>>> http://p.sf.net/sfu/intel-dev2devmay >>>> _______________________________________________ >>>> Mssqlcompressed-users mailing list >>>> Mss...@li... >>>> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users >>> >> > > |
|
From: Vinko V. <el...@vi...> - 2011-05-16 12:20:37
|
I have written a small tool that allows me to backup all databases without batch scripts, but an XML file. May not be what you want, but it certainly works for me :-) http://sourceforge.net/projects/msbpm/ On 5/16/2011 1:40 PM, ev...@me... wrote: > I have removed the extra space after 'backup', but no difference... > (I do have the entire command on a single line. The email client broke it > in two...) > > It's as if the %%G doesn't get converted into a DB-name... > > Greetings, > Evert > > >> Hi Evert, >> >> The command is correct, but do not give Extra space between the >> parameters and it's value. >> Specifically, after backup, there is a 2 space. >> >> Also try and give the entire command on single line. >> >> Cheers, >> Hemang >> >> -----Original Message----- >> From: mss...@li... >> [mailto:mss...@li...] On Behalf >> Of ev...@me... >> Sent: Friday, May 13, 2011 5:31 PM >> To: mss...@li... >> Subject: [Mssqlcompressed-users] Batch-backup. How? >> >> I have a list of database-names in a file, and want to us msbp to make >> backups. >> msbp.cmd contains: >> ****************************************** >> @ECHO OFF >> for /F %%G in (OnlineDbs.txt) do >> msbp.exe backup "db(database=%%G)" "gzip()" >> "local(path=\\mp01-app-03\sz01-sql-01\%%G.bak.gz)" >> ****************************************** >> >> However, this does not seem to work... Is it my scripting, or msbp which >> is causing problems here? >> >> Greetings, >> Evert >> >> >> ------------------------------------------------------------------------ >> ------ >> Achieve unprecedented app performance and reliability >> What every C/C++ and Fortran developer should know. >> Learn how Intel has extended the reach of its next-generation tools >> to help boost performance applications - inlcuding clusters. >> http://p.sf.net/sfu/intel-dev2devmay >> _______________________________________________ >> Mssqlcompressed-users mailing list >> Mss...@li... >> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users >> > > > ------------------------------------------------------------------------------ > Achieve unprecedented app performance and reliability > What every C/C++ and Fortran developer should know. > Learn how Intel has extended the reach of its next-generation tools > to help boost performance applications - inlcuding clusters. > http://p.sf.net/sfu/intel-dev2devmay > _______________________________________________ > Mssqlcompressed-users mailing list > Mss...@li... > https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users |
|
From: Clay L. <cl...@le...> - 2011-05-18 21:36:40
|
Vinko, Looks good. :) A number of people have requested this. I'm glad to see this hole filled. If I had the time, I'd love to work on a restore program. I find restoring databases painful -- both with the msbp command line, and with the SSMS GUI. I want to drag and drop a number of bak files - full, diff, log, compressed, not compressed, whatever, and have the tool figure out the best way to restore. Also, it'll do NORECOVERY by default. ;) Oh, the number of times I've made that mistake. Thanks again for your tool. Clay On 16 May 2011 12:52, Vinko Vrsalovic <el...@vi...> wrote: > I have written a small tool that allows me to backup all databases > without batch scripts, but an XML file. > May not be what you want, but it certainly works for me :-) > > http://sourceforge.net/projects/msbpm/ > > On 5/16/2011 1:40 PM, ev...@me... wrote: > > I have removed the extra space after 'backup', but no difference... > > (I do have the entire command on a single line. The email client broke it > > in two...) > > > > It's as if the %%G doesn't get converted into a DB-name... > > > > Greetings, > > Evert > > > > > >> Hi Evert, > >> > >> The command is correct, but do not give Extra space between the > >> parameters and it's value. > >> Specifically, after backup, there is a 2 space. > >> > >> Also try and give the entire command on single line. > >> > >> Cheers, > >> Hemang > >> > >> -----Original Message----- > >> From: mss...@li... > >> [mailto:mss...@li...] On Behalf > >> Of ev...@me... > >> Sent: Friday, May 13, 2011 5:31 PM > >> To: mss...@li... > >> Subject: [Mssqlcompressed-users] Batch-backup. How? > >> > >> I have a list of database-names in a file, and want to us msbp to make > >> backups. > >> msbp.cmd contains: > >> ****************************************** > >> @ECHO OFF > >> for /F %%G in (OnlineDbs.txt) do > >> msbp.exe backup "db(database=%%G)" "gzip()" > >> "local(path=\\mp01-app-03\sz01-sql-01\%%G.bak.gz)" > >> ****************************************** > >> > >> However, this does not seem to work... Is it my scripting, or msbp which > >> is causing problems here? > >> > >> Greetings, > >> Evert > >> > >> > >> ------------------------------------------------------------------------ > >> ------ > >> Achieve unprecedented app performance and reliability > >> What every C/C++ and Fortran developer should know. > >> Learn how Intel has extended the reach of its next-generation tools > >> to help boost performance applications - inlcuding clusters. > >> http://p.sf.net/sfu/intel-dev2devmay > >> _______________________________________________ > >> Mssqlcompressed-users mailing list > >> Mss...@li... > >> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users > >> > > > > > > > ------------------------------------------------------------------------------ > > Achieve unprecedented app performance and reliability > > What every C/C++ and Fortran developer should know. > > Learn how Intel has extended the reach of its next-generation tools > > to help boost performance applications - inlcuding clusters. > > http://p.sf.net/sfu/intel-dev2devmay > > _______________________________________________ > > Mssqlcompressed-users mailing list > > Mss...@li... > > https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users > > > > ------------------------------------------------------------------------------ > What Every C/C++ and Fortran developer Should Know! > Read this article and learn how Intel has extended the reach of its > next-generation tools to help Windows* and Linux* C/C++ and Fortran > developers boost performance applications - including clusters. > http://p.sf.net/sfu/intel-dev2devmay > _______________________________________________ > Mssqlcompressed-users mailing list > Mss...@li... > https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X