mssqlcompressed-users — This list is for issues of interest to *users* of the software.

[Mssqlcompressed-users] Multithreaded compression

[Louie G. <lou...@ie...>]

Clay

 

Excellent stuff, the SQL world has been crying out for something like this.
Not only compression, but backups across the network - I have a few servers
to backup, and want them all on the one USB disk. Excellent.

 

You said: Multithreaded Compression. SQL Server Compressed Backup can
compress your backups using multiple threads to take advantage of multiple
cores.

 

How do I get this to work? Can I select how many cores are active? Runtime
selection? Much used or beta or ...?

 

My backup ran on one core, I have eight cores, and the disks weren't busy  I
did dig around your code, trying to find an answer. I hoped it would be a
param on zip64(), but I see it has only two/one in its schema
(Zip64Transform.cs). Can't find any other params that might control it.
Considered that it might be additional transforms in the pipeline, but that
sounds difficult, even nonsensical. I'm guessing its a compilation option L.

 

I have thought of another option: write an uncompressed backup onto a
windows-compressed file system. Not possible with vanilla SQL2005, easy I
expect with your handy program. Though I'm not sure that windows would
compress multi-core. Any comments?

 

Regards

Louie Gregg

 

IT Dept, IESA Ltd

 <mailto:lou...@ie...> lou...@ie...

01925 454409

0759 577 3206

 


IESA Limited, a company registered in England and Wales with the company number 4188491 and VAT Number GB 703 4081 74 whose registered office is Dallam Lane, Warrington, Cheshire, WA2 7PZ. 

For more details of our services visit *** http://www.iesa.co.uk *** 

This communication contains information which is confidential and may also be privileged. It is for the exclusive use of the addressee. If you are not the addressee please note that any distribution, reproduction, copying, publication or use of this communication or the information in it is prohibited. If you have received this communication in error, please telephone us immediately (UK +44 1925 454400) and also delete the communication from your computer. The views expressed in this communication may not necessarily be the views held by IESA Limited.

Re: [Mssqlcompressed-users] User and Passwordcredentials in Connectionstring

[Otis L. <oti...@go...>]

Hello Clay,

you are right.
I created a user on the DB with my Windows - usergroup - credentials and
gave him the sysadmin-role.
The DB runs on a Windows 2008 System, so i fire the batch in a planned task
with the Checkbox "highest  rights"
(dont know, how it is written in english (it's a german system).

here is the batch (the echos are for the test):

echo off

SET
logfile="d:\db-Dumps\NV-REP_ENTW_BACKUP_LOG-%date:~-4,4%-%date:~-7,2%-%date:~0,2%%1%.log"

echo ========================== Starting Backup Of Repository NV_REP_ENTW
================================

C:\MSSQLCompressedBackup\msbp.exe backup "db(database=NV_REP_ENTWICKLUNG)"
"zip64(level=3)" "local(path=d:\db-Dumps\NV_REP_ENTW.bak.zip)"  >> %logfile%

echo ============================= finished Backup
==============================

: end

Your application is absolutely great! especially, if you have
commandline-admins and they think that we developer will reach with
10 GB 100 years ;-)


Sorry, my english is absolutely bad...
Have a nice day and thank you very much!

Otis

Re: [Mssqlcompressed-users] User and Passwordcredentials in Connectionstring

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

Otis,

The app makes two connections to SQL Server. One is a standard ADO.Net
connection where you can use SQL Logins. The second connection
receives the stream of bytes to save and only authenticates using
Windows Authentication.  It is possible to authenticate differently
with the two connections, but I'd want to hear why this would be
useful as it could lead to a brittle application that might only
partitially connect to SQL Server.

Another option is to change the app to install a Windows Service
running as a Windows user that has high SQL Server permissions to make
the second connection and receive the data, however this connection
would be responsible for writing the data and this service user may
not have the rights to write to the file especially if the file is on
a network share.

In general, I'd prefer the permissions to be simple as possible: only
one Windows user is involved and this user must have the appropriate
rights in both SQL Server and the filesystem, though I'm open to hear
how this restriction might cause problems for people.

Cheers,
Clay

On Tuesday, December 8, 2009, Otis Loomgard <oti...@go...> wrote:
> Hi there,
> is it possible to make a connection (and backup) with a special User and Password to connect to the database?
>
> I have tried several Versions but the commandline throws an error that the UserCredentials (it takes my Windows - logincredentials)have not the special rights to connect to the database.
>
>
> Thank you and best regards!Otis Loomgard
> Some Examples would be fine.
>
>

[Mssqlcompressed-users] User and Passwordcredentials in Connectionstring

[Otis L. <oti...@go...>]

>
> Hi there,


is it possible to make a connection (and backup) with a special User and
Password to connect to the database?
I have tried several Versions but the commandline throws an error that the
UserCredentials (it takes my Windows - logincredentials)
have not the special rights to connect to the database.

Thank you and best regards!
Otis Loomgard

Some Examples would be fine.

Re: [Mssqlcompressed-users] Prevent Backslash Escaping

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

Tim,

There is a new version of the application that fixes the blackslash escaping
issue.  The \s, \p, and \\ are no longer escape sequences, and the only
escaping is ";;" (to allow for ";" in parameters).

-Clay

2009/8/9 Clay Lenhart <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
>
>

[Mssqlcompressed-users] Fwd: Prevent Backslash Escaping

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

I'll look into it.


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

[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

[Mssqlcompressed-users] Prevent Backslash Escaping

[Tim B. <ti...@tl...>]

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.

[Mssqlcompressed-users] using mssqlcompressed backup from VB6 application

[Steve K. <st...@mi...>]

Hi
I have an application that backs up sql DB / Logs and restores them to a warm server.
The application is written in VB6 and it would be great if the VB app could use mssqlcompressed backup.

would it be possible to call the plugin DLL's directly or write an intermediate DLL which acts in the same way as MSBP.EXE.

also is the source code available for msbp.exe.

regards

Steve
Steve Keeley
Technical Support
01344 861133 ext 227

--------------------------------------------------------------------------
Miles 33 Ltd, Miles House, Easthampstead Road, Bracknell, Berkshire RG12 1NJ
Registered in England No. 2924416    Tel:01344 861133    Fax:01344 860224

[Mssqlcompressed-users] test

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

test

[Mssqlcompressed-users] test

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

test