[Mssqlcompressed-users] Fwd: Prevent Backslash Escaping

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

The short answer is that msbp (not .Net) is converting \s to ";", and this
is by design (well, questionable design ;) )

The args are semicolon separated, so to be able to include a semicolon, you
use "\s".  To get what you want you have to escape the backslash, eg "\\s".

"\s", "\p" and "\\" are special in msbp.  Since \s and \p occur commonly in
paths, I have a think of an alternative, perhaps \: for semicolon for
example.

This command is what you want:
msbp.exe backup "db(instancename=sqlexpress;database=salonware)"
"zip64(level=7;filename=salonware.bak)" "local(path=c:\documents and
settings\timb\desktop\\salonwaretest.bak.7z)"

Cheers,
Clay



---------- Forwarded message ----------
From: Tim Bushell <ti...@tl...>
Date: 2009/8/6
Subject: [Mssqlcompressed-users] Prevent Backslash Escaping
To: mss...@li...


Hi there,

I just downloaded version 1.1 and was running some tests with it.

Can you recommend any way to prevent the backslash escaping that .NET is
doing?

Here is why I ask:

When I run following command, the output file is invalid because the \s
for the file name is being interpreted as an escaped semicolon.  If I
change the \s to \S then the file is created as intended.

 >msbp.exe backup "db(instancename=sqlexpress;database=salonware)"
"zip64(level=7;filename=salonware.bak)" "local(path=c:\documents and
settings\timb\desktop\salonwaretest.bak.7z)"
Connecting: Data Source=.\sqlexpress;Initial Catalog=master;Integrated
Security=SSPI;Asynchronous Processing=true;
local:
       path=c:\documents and settings\timb\desktop;alonwaretest.bak.7z
zip64: level = 7, filename=salonware.bak
Backup started


--
Tim Bushell
IT Manager
TLS - Connecting Voices
Phone: (519) 964-3121


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Mssqlcompressed-users mailing list
Mss...@li...
https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users