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

[Vinko V. <el...@vi...>]

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