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

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

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