Re: [Mssqlcompressed-users] Batch-backup. How?

[<ev...@me...>]

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
>
>