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