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

[Clay L. <cl...@le...>]

Vinko, Looks good. :)  A number of people have requested this.  I'm glad to
see this hole filled.

If I had the time, I'd love to work on a restore program.  I find restoring
databases painful -- both with the msbp command line, and with the SSMS GUI.
I want to drag and drop a number of bak files - full, diff, log, compressed,
not compressed, whatever, and have the tool figure out the best way to
restore.  Also, it'll do NORECOVERY by default. ;) Oh, the number of times
I've made that mistake.

Thanks again for your tool.

Clay

On 16 May 2011 12:52, Vinko Vrsalovic <el...@vi...> wrote:

> 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
>
>
>
> ------------------------------------------------------------------------------
> What Every C/C++ and Fortran developer Should Know!
> Read this article and learn how Intel has extended the reach of its
> next-generation tools to help Windows* and Linux* C/C++ and Fortran
> developers boost performance applications - including clusters.
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> Mssqlcompressed-users mailing list
> Mss...@li...
> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users
>