Re: [Mssqlcompressed-users] Batch-backup. How?
Brought to you by:
xclayl
Menu
▾
▴
Re: [Mssqlcompressed-users] Batch-backup. How?
|
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 |
