Re: [Mssqlcompressed-users] MSBP on SQL2005

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Dear Clay,

I have installed the first C++ library link as suggested, and the command now works :-) With the default instance I ran the command successfully without the instancename parameter, (with the instancename parameter it gives the "connection string not valid" error).

Thanks for giving your time freely. If you have a paypal account, please send it over so I can make a small donation in appreciation.

Many Thanks - Bilal.

Bilal Omarjee
Senior DBA
Health Information Technology

The Royal Children's Hospital Melbourne
50 Flemington Road Parkville 3052 Victoria
T: 9345 6542   F: 9345 4970   M: 0488 442 096
www.rch.org.au

The Royal Children's Hospital Melbourne

This email and subsequent correspondence including any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed.

If you have received this email in error, please notify the sender by return email immediately and erase all copies of this message and attachments.

________________________________
From: Clay Lenhart <cl...@le...>
Sent: Thursday, 2 April 2015 10:51 PM
To: Bilal Omarjee
Cc: mss...@li...
Subject: RE: [Mssqlcompressed-users] MSBP on SQL2005

It's related to loading the sqlvdi.dll.  Maybe it's due to needing the C++ library installed.

http://www.microsoft.com/en-us/download/details.aspx?id=29

There is a service pack for it, so I'm not sure if you need to install both or just the service pack above.

http://www.microsoft.com/en-us/download/details.aspx?id=11895

-Clay

---- On Wed, 01 Apr 2015 21:36:02 -0400 Bilal Omarjee<Bil...@rc...> wrote ----

Hello Clay,

Thanks for getting back to me.

And yes can confirm that we are running the command locally on the target server. The sqlvdi.dll exists in the c:\Program Files\Microsoft SQL Server\80\COM directory.

Have tried the same command without the instancename parameter, haven’t had any luck though it does give a slightly different error.

The other instances I back up using this tool are named instances.

Would appreciate any feedback you might have.

Much appreciated, Bilal.

Bilal Omarjee
Senior DBA
Health Information Technology

The Royal Children's Hospital Melbourne
50 Flemington Road Parkville 3052 Victoria
T: 9345 6542   F: 9345 4970   M: 0488 442 096
www.rch.org.au<http://www.rch.org.au/>

[The Royal Children's Hospital Melbourne]<http://www.rch.org.au/home.html>

This email and subsequent correspondence including any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the sender by return email immediately and erase all copies of this message and attachments.

From: Clay Lenhart [mailto:cl...@le...]
Sent: Thursday, 2 April 2015 12:11 PM
To: Bilal Omarjee
Cc: mss...@li...<mailto:mss...@li...>
Subject: Re: [Mssqlcompressed-users] MSBP on SQL2005

Just to double check, this command should run on the server, ie it doesn't work remotely.

It sounds like it is not finding the sqlvdi.dll which should be located here on a x64 machine:
C:\Program Files (x86)\Microsoft SQL Server\80\COM\
or here on a x86 machine:
C:\Program Files\Microsoft SQL Server\80\COM\

Let me know how you get on.

Cheers,
Clay

---- On Wed, 25 Mar 2015 02:49:40 -0400 Bilal Omarjee <Bil...@rc...<mailto:Bil...@rc...>> wrote ----

Dear MSSQLCOmpressed,

Your tool is excellent, we use it on some other servers with great success :)

I was wondering if I could get some help with a query running it on SQL 2005 32 bit.

The server has a default instance installed.

When I run command C:\MSBP\MSSQLCompressedBackup-1.2-20110729_x86\msbp.exe backup "db(instancename=MSSQLSERVER;database=master)" "zip64(level=1;filename=master_20150325_1704.bak)" "local(path=D:\MSSQL.1\MSSQL\USERDB\FULLBAK\master_20150325_1704.bak.zip)"

I get the following error;

[cid:1.28876465421.8566682859989144435.14c79f91065__inline__img__src]

I thought the issue might be the instance name of ‘MSSQLSERVER’ because it is a default instance; so I tried running the command without the instance name parameter; but I get a different error from the assembly.

[cid:2.28876465421.499252568461572138.14c79f91065__inline__img__src]

Would appreciate any help you could provide.

Much Appreciated!

Bilal.

Bilal Omarjee
Senior DBA
Health Information Technology

The Royal Children's Hospital Melbourne
50 Flemington Road Parkville 3052 Victoria
T: 9345 6542   F: 9345 4970   M: 0488 442 096
http://www.rch.org.au/

[The Royal Children's Hospital Melbourne]<http://www.rch.org.au/home.html>

This email and subsequent correspondence including any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the sender by return email immediately and erase all copies of this message and attachments.

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/_______________________________________________
Mssqlcompressed-users mailing list
Mss...@li...<mailto:Mss...@li...>
https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users