mssqlcompressed-users Mailing List for MSSQL Compressed Backup
Brought to you by:
xclayl
Menu
▾
▴
mssqlcompressed-users — This list is for issues of interest to *users* of the software.
You can subscribe to this list here.
| 2009 |
Jan
|
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
(3) |
Jul
|
Aug
(3) |
Sep
|
Oct
|
Nov
(1) |
Dec
(7) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2010 |
Jan
|
Feb
(2) |
Mar
(7) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(4) |
Nov
|
Dec
|
| 2011 |
Jan
|
Feb
(3) |
Mar
|
Apr
|
May
(9) |
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
(2) |
| 2012 |
Jan
(1) |
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
(3) |
| 2013 |
Jan
(1) |
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
(1) |
Apr
(5) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Bilal O. <Bil...@rc...> - 2015-04-03 04:51:10
|
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 |
|
From: Clay L. <cl...@le...> - 2015-04-02 11:52:06
|
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 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... 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...> wrote ---- Dear MSSQLCOmpressed, Your tool is excellent, we use it on some other servers with great success J 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; 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. 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/ 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... https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users |
|
From: Bilal O. <Bil...@rc...> - 2015-04-02 01:36:16
|
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... 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:image002.png@01D06D41.92FEAC50] 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:image003.png@01D06D41.92FEAC50] 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 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. ------------------------------------------------------------------------------ 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 |
|
From: Clay L. <cl...@le...> - 2015-04-02 01:29:20
|
Also, use the command without the instance name. ---- On Wed, 25 Mar 2015 02:49:40 -0400 Bilal Omarjee<Bil...@rc...> wrote ---- Dear MSSQLCOmpressed, Your tool is excellent, we use it on some other servers with great success J 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; 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. 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 www.rch.org.au 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... https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users |
|
From: Clay L. <cl...@le...> - 2015-04-02 01:26:17
|
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...> wrote ---- Dear MSSQLCOmpressed, Your tool is excellent, we use it on some other servers with great success J 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; 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. 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 www.rch.org.au 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... https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users |
|
From: Bilal O. <Bil...@rc...> - 2015-03-25 07:17:33
|
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:image001.png@01D06723.EF3971E0] 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:image003.png@01D06724.111D97A0] 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 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: Patel, S. <sp...@cm...> - 2013-06-12 13:25:24
|
Hi, Currently I have a 100GB DB on SQL Server 2005 and the backup runs very slow over NAMEDPIPE. Can I define as parameter to use TCP/IP? My code is here Z:\MSSQLCompressBKP\msbp.exe backup "db(database=CMT_Txn;clusternetworkname=DBServer;backuptype=full;filegroup=primary;checksum)" zip64 "local(path=z:\MSSQL\BACKUP\FULL\CMT_Txn\CMT_Txn.full.bak;path=z:\MSSQL\BACKUP\FULL\CMT_Transaction\CMT_Txn.full.2.bak)" *Sushil Patel* Sr. Database Administrator / Architect Creative Mobile Technologies, LLC 5803 Kennett Pike Suite C | Wilmington, DE 19807 302-660-3740 | SP...@cm... |
|
From: Robert E. <re...@co...> - 2013-02-12 16:49:16
|
Just a follow up for anyone interested: I've been digging through the code for the gzip compressor and it turns out the compression level on the gzip is never set so its always defaulting to 9: In GzipTransform.cs: return new GZIPOutputStream(writeToStream, level); should be something like this: var compressedOutputStream = new GZipOutputStream(writeToStream); compressedOutputStream.SetLevel(level); return compressedOutputStream; I imagine the same is true of the bzip2 plugin etc. Once that's done and built etc it works like a charm! On 8 January 2013 10:29, Robert Emery <re...@co...> wrote: > Hi, > > We are testing msbp with gzip compression against a test db (3.5GB) on > SQL Server 2005 SP4, Server 2008 Standard using the following commands > > msbp.exe backup "db(database=VehicleData)" "gzip(level=1)" > "local(path=F:\SQLDumps\VehicleData\VehicleData_backup_20130104_l1.bak.gz)" > msbp.exe backup "db(database=VehicleData)" "gzip(level=9)" > "local(path=F:\SQLDumps\VehicleData\VehicleData_backup_20130104_l9.bak.gz)" > > We've found that changing the gzip level makes no difference as to the > size or amount of time taken to perform the backup? > uncompressed: 3530221KB, approx 55 seconds > > level=1 400,515KB Approx 4 mins > level=9 400,514KB Approx 4 mins > > For us, we are looking to get *some* compression (even 8:10 would be > enough) without a large decrease in speed. > > Two questions: does the gzip level definitely get applied and is there > a way for me to verify this? > Secondly: does anyone have any recommendations how to decrease the > duration for gzip level=1? > > Something I also noticed, when I gunzipped the files and then re-gzipped > them > with the gzip command on our linux server, the file sizes came out larger > for > level=1. > > Many Thanks, > > -- > Robert Emery > Database Administrator > |
|
From: Robert E. <re...@co...> - 2013-01-08 10:29:52
|
Hi, We are testing msbp with gzip compression against a test db (3.5GB) on SQL Server 2005 SP4, Server 2008 Standard using the following commands msbp.exe backup "db(database=VehicleData)" "gzip(level=1)" "local(path=F:\SQLDumps\VehicleData\VehicleData_backup_20130104_l1.bak.gz)" msbp.exe backup "db(database=VehicleData)" "gzip(level=9)" "local(path=F:\SQLDumps\VehicleData\VehicleData_backup_20130104_l9.bak.gz)" We've found that changing the gzip level makes no difference as to the size or amount of time taken to perform the backup? uncompressed: 3530221KB, approx 55 seconds level=1 400,515KB Approx 4 mins level=9 400,514KB Approx 4 mins For us, we are looking to get *some* compression (even 8:10 would be enough) without a large decrease in speed. Two questions: does the gzip level definitely get applied and is there a way for me to verify this? Secondly: does anyone have any recommendations how to decrease the duration for gzip level=1? Something I also noticed, when I gunzipped the files and then re-gzipped them with the gzip command on our linux server, the file sizes came out larger for level=1. Many Thanks, -- Robert Emery Database Administrator |
|
From: Shah, H. <Hem...@un...> - 2012-12-14 05:31:16
|
Hi Clay, I am very much new to this product. I am also facing the similar issue. I am using windows 7 enterprise edition – 64 bit OS. You told that – “Be sure to use the 64 bit binary.” Could you please elaborate on this? Thanks in advance, Hemang From: mss...@li... [mailto:mss...@li...] On Behalf Of Clay Lenhart Sent: Thursday, December 13, 2012 2:46 PM To: Sridhara N Cc: mss...@li... Subject: Re: [Mssqlcompressed-users] Will this Support 64Bit OS? It definitely works on 64 bit machines. Be sure to use the 64 bit binary. On Thursday, 13 December 2012, Sridhara N wrote: Dear Users, Not able to use this tool in Win 7 machine. it fails on 64 Bit machines. see the error message. ***************************** Backup using Utility Starts 11:12:12 17:43:38 **************************** Unhandled Exception: System.BadImageFormatException: Could not load file or assembly 'MSBackupPipe.VirtualBackupDevice, Version=1.0.3640.23404, Culture=neutral, PublicKeyToken=d210a28332c6e3f1' or one of its dependencies. An attempt was made to load a pro gram with an incorrect format. File name: 'MSBackupPipe.VirtualBackupDevice, Version=1.0.3640.23404, Culture=neutral, PublicKeyToken=d210a28332c6e3f1' at MSBackupPipe.Cmd.Program.Main(String[] args) === Pre-bind state information === LOG: User = NT AUTHORITY\NETWORK SERVICE LOG: DisplayName = MSBackupPipe.VirtualBackupDevice, Version=1.0.3640.23404, Culture=neutral, PublicKeyToken=d210a28332c6e3f1 (Fully-specified) LOG: Appbase = file:///C:/Project2/bin/MSSQLCompressedBackup/ LOG: Initial PrivatePath = NULL Calling assembly : msbp, Version=1.2.3799.32996, Culture=neutral, PublicKeyToken=d210a28332c6e3f1. === LOG: This bind starts in default load context. LOG: No application configuration file found. LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework64\v2.0.50727\config\machine.config. LOG: Post-policy reference: MSBackupPipe.VirtualBackupDevice, Version=1.0.3640.23404, Culture=neutral, PublicKeyToken=d210a28332c6e3f1 LOG: Attempting download of new URL file:///C:/Project2/bin/MSSQLCompressedBackup/MSBackupPipe.VirtualBackupDevice.DLL. ERR: Failed to complete setup of assembly (hr = 0x8007000b). Probing terminated. ***************************** Backup using Utility Ends 11:12:12 17:43:38 **************************** any help would be appreciable. Regards, sridhara.n -- Sridhara.N |
|
From: Clay L. <cl...@le...> - 2012-12-13 10:16:55
|
It definitely works on 64 bit machines. Be sure to use the 64 bit binary. On Thursday, 13 December 2012, Sridhara N wrote: > Dear Users, > > Not able to use this tool in Win 7 machine. it fails on 64 Bit machines. > see the error message. > > ***************************** Backup using Utility Starts 11:12:12 > 17:43:38 **************************** > Unhandled Exception: System.BadImageFormatException: Could not load file > or assembly 'MSBackupPipe.VirtualBackupDevice, Version=1.0.3640.23404, > Culture=neutral, PublicKeyToken=d210a28332c6e3f1' or one of its > dependencies. An attempt was made to load a pro gram with an incorrect > format. File name: 'MSBackupPipe.VirtualBackupDevice, > Version=1.0.3640.23404, Culture=neutral, > PublicKeyToken=d210a28332c6e3f1' at > MSBackupPipe.Cmd.Program.Main(String[] args) === Pre-bind state information > === LOG: User = NT AUTHORITY\NETWORK SERVICE LOG: DisplayName = > MSBackupPipe.VirtualBackupDevice, Version=1.0.3640.23404, Culture=neutral, > PublicKeyToken=d210a28332c6e3f1 (Fully-specified) LOG: Appbase = > file:///C:/Project2/bin/MSSQLCompressedBackup/ LOG: Initial PrivatePath = > NULL Calling assembly : msbp, Version=1.2.3799.32996, Culture=neutral, > PublicKeyToken=d210a28332c6e3f1. === LOG: This bind starts in default load > context. LOG: No application configuration file found. LOG: Using machine > configuration file from > C:\Windows\Microsoft.NET\Framework64\v2.0.50727\config\machine.config. LOG: > Post-policy reference: MSBackupPipe.VirtualBackupDevice, > Version=1.0.3640.23404, Culture=neutral, PublicKeyToken=d210a28332c6e3f1 > LOG: Attempting download of new URL > file:///C:/Project2/bin/MSSQLCompressedBackup/MSBackupPipe.VirtualBackupDevice.DLL. > ERR: Failed to complete setup of assembly (hr = 0x8007000b). Probing > terminated. > ***************************** Backup using Utility Ends 11:12:12 17:43:38 > **************************** > > any help would be appreciable. > > Regards, > sridhara.n > > -- > Sridhara.N > |
|
From: Sridhara N <n.s...@gm...> - 2012-12-13 06:38:35
|
Dear Users, Not able to use this tool in Win 7 machine. it fails on 64 Bit machines. see the error message. ***************************** Backup using Utility Starts 11:12:12 17:43:38 **************************** Unhandled Exception: System.BadImageFormatException: Could not load file or assembly 'MSBackupPipe.VirtualBackupDevice, Version=1.0.3640.23404, Culture=neutral, PublicKeyToken=d210a28332c6e3f1' or one of its dependencies. An attempt was made to load a pro gram with an incorrect format. File name: 'MSBackupPipe.VirtualBackupDevice, Version=1.0.3640.23404, Culture=neutral, PublicKeyToken=d210a28332c6e3f1' at MSBackupPipe.Cmd.Program.Main(String[] args) === Pre-bind state information === LOG: User = NT AUTHORITY\NETWORK SERVICE LOG: DisplayName = MSBackupPipe.VirtualBackupDevice, Version=1.0.3640.23404, Culture=neutral, PublicKeyToken=d210a28332c6e3f1 (Fully-specified) LOG: Appbase = file:///C:/Project2/bin/MSSQLCompressedBackup/ LOG: Initial PrivatePath = NULL Calling assembly : msbp, Version=1.2.3799.32996, Culture=neutral, PublicKeyToken=d210a28332c6e3f1. === LOG: This bind starts in default load context. LOG: No application configuration file found. LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework64\v2.0.50727\config\machine.config. LOG: Post-policy reference: MSBackupPipe.VirtualBackupDevice, Version=1.0.3640.23404, Culture=neutral, PublicKeyToken=d210a28332c6e3f1 LOG: Attempting download of new URL file:///C:/Project2/bin/MSSQLCompressedBackup/MSBackupPipe.VirtualBackupDevice.DLL. ERR: Failed to complete setup of assembly (hr = 0x8007000b). Probing terminated. ***************************** Backup using Utility Ends 11:12:12 17:43:38 **************************** any help would be appreciable. Regards, sridhara.n -- Sridhara.N |
|
From: Clay L. <cl...@le...> - 2012-09-20 15:37:55
|
Once backed up, I don't know of a way to split the file into multiple backup files. However when you are backing up, you can backup to multiple files by providing multiple "path" parameters: http://mssqlcompressed.sourceforge.net/doc_plugins_local.shtml -Clay On 19 September 2012 10:06, Sameh Fawzy <sf...@gc...> wrote: > Is there any way to split the backup file into parts (is there any > parameters I can use to split the generated backup into parts without > affect the restore using the same method)**** > > ** ** > > Thank you**** > > * * > > *Sameh Fawzy Ahmed* > > DBA | GCSSD**** > > *Mob: **+20 11-3362-026** > *sf...@gc...<http://us.mc509.mail.yahoo.com/mc/compose?to=rn...@gc...> > * > *www.gcssd.com**** > > ** ** > > > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://ad.doubleclick.net/clk;258768047;13503038;j? > http://info.appdynamics.com/FreeJavaPerformanceDownload.html > _______________________________________________ > Mssqlcompressed-users mailing list > Mss...@li... > https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users > > |
|
From: Sameh F. <sf...@gc...> - 2012-09-19 14:21:52
|
Is there any way to split the backup file into parts (is there any parameters I can use to split the generated backup into parts without affect the restore using the same method) Thank you Sameh Fawzy Ahmed DBA | GCSSD Mob: +20 11-3362-026 sf...@gc...<http://us.mc509.mail.yahoo.com/mc/compose?to=rn...@gc...> www.gcssd.com<http://www.gcssd.com/> |
|
From: Suwanto A. <sa...@ya...> - 2012-07-24 07:21:11
|
Hi, Please advise as I hits the following error messages when trying to backup SQL Server 2005 database. Thanks. C:\MSSQLCompressedBackup>msbp.exe backup "db(database=model)" "local(path=c:\mod el.bak)" Could not load file or assembly 'VdiNet.VirtualBackupDevice32, Version=1.0.3970. 37477, Culture=neutral, PublicKeyToken=b2100563907f98e7' or one of its dependenc ies. This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1) System.IO.FileLoadException at VdiNet.VirtualBackupDevice.Exe32Sql32.VirtualDeviceSetExe32Sql32..ctor() at VdiNet.VirtualBackupDevice.VirtualBackupDeviceFactory.NewVirtualDeviceSet( SqlPlatform sqlP) in C:\Users\Clay\Documents\vdi.net\VdiNet.VirtualBackupDevice\ VirtualBackupDeviceFactory.cs:line 18 at MSBackupPipe.Common.BackupPipeSystem.BackupOrRestore(Boolean isBackup, Con figPair storageConfig, ConfigPair databaseConfig, List`1 pipelineConfig, IUpdate Notification updateNotifier) in C:\Users\Clay\Documents\MSSQL Compressed\mssql s ourceforge2\MSBackupPipe.Common\BackupPipeSystem.cs:line 183 at MSBackupPipe.Common.BackupPipeSystem.Backup(ConfigPair databaseConfig, Lis t`1 pipelineConfig, ConfigPair storageConfig, IUpdateNotification updateNotifier ) in C:\Users\Clay\Documents\MSSQL Compressed\mssql sourceforge2\MSBackupPipe.Co mmon\BackupPipeSystem.cs:line 51 at MSBackupPipe.Cmd.Program.Main(String[] args) in C:\Users\Clay\Documents\MS SQL Compressed\mssql sourceforge2\MSBackupPipe.Cmd\Program.cs:line 110 This application has failed to start because the application configuration is in correct. Reinstalling the application may fix this problem. (Exception from HRES ULT: 0x800736B1) System.Runtime.InteropServices.COMException This application has failed to start because the application configuration is in correct. Reinstalling the application may fix this problem. (Exception from HRES ULT: 0x800736B1) The backup failed. Below are the commands for msbp.exe: msbp.exe help msbp.exe backup msbp.exe restore msbp.exe listplugins msbp.exe helpplugin msbp.exe version For more information, type msbp.exe help <command> C:\MSSQLCompressedBackup> |
|
From: Cary L. <car...@gm...> - 2012-04-09 17:28:25
|
I want to be able to create a compressed backup of a sql database, but I want to be able to run msbp on a different server than the actual SQL server machine. Is there a way to specify host, username, password, and database name? Thank you. |
|
From: João C. P. <jc...@eu...> - 2012-01-04 14:21:47
|
Hi there, Indeed the use of bzip2 plugin with msbp slows down the backup to nearly 8 hours instead of 45m without it. So the backup produces a lock with ACTIVE_TRANSACTION in log_reuse_wait_desc with transaction log growing to near 12GB. Thanks and best regards, -- João C. Pinto <jc...@eu...> Eurotux Informática, S.A. Em Fri, 23 Dec 2011 11:33:47 -0000, Clay Lenhart <cl...@le...> escreveu: > It is highly unlikely that msbp is causing this. Next time look at the > log_reuse_wait_desc column in sys.databases to see why so much log space > is > needed. Msbp utilizes the same backup architecture that SQL Server uses > so > it shouldn't be any different. One possile explaination is if you slow > down > the backup using the "rate" plugin provided with msbp. SQL Server will > keep > transaction log records until the backup completes (this is true no > matter > which backup method you use). This sounds far-fetched though since the > transaction log is over 35GB. You'd have to *really* slow down the > backup. > > There are several reasons, unrelated to backups, why transaction log > records are not purged. Definitely query that column to see what is going > on. > > On Wednesday, 14 December 2011, João C. Pinto <jc...@eu...> wrote: >> Hi, >> >> First of all, thanks for sharing a great tool that already proved to be >> very useful. >> >> >> When trying to make a backup through MSBP to a 35GB BD in simple mode I >> get the following error: >> >> 07:34:29 ------------------------ Exception #1 The transaction log for >> database 'MV.Web' is full. To find out why space in the log cannot be >> reused, see the log_reuse_wait_desc column in sys.databases BACKUP >> DATABASE is terminating abnormally. Processed 3806968 pages for database >> 'MV.Web', file 'MV.Web' on file 1. Processed 268653 pages for database >> 'MV.Web', file 'MV.Web_log' on file 1. >> System.Data.SqlClient.SqlException >> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, >> Boolean breakConnection) at >> > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject >> stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior >> runBehavior, >> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet >> bulkCopyHandler, TdsParserStateObject stateObj) at >> System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, >> RunBehavior runBehavior, String resetOptionsString) at >> System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader() at >> System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(IAsyncResult >> asyncResult) at MSBackupPipe.Common.SqlThread.EndExecute() in >> C:\Users\Clay\Documents\MSSQL Compressed\mssql >> sourceforge2\MSBackupPipe.Common\SqlThread.cs:line 492 The backup >> failed. >> Below are the commands for msbp.exe: msbp.exe help msbp.exe backup >> msbp.exe restore msbp.exe listplugins msbp.exe helpplugin msbp.exe >> version >> For more information, type msbp.exe help <command>. Process Exit Code 0. >> The step succeeded. >> >> After allowing the transaction log to auto-grow without any limit the >> backup successfully completes with the transaction log growing to near >> 12GB. However, if the backup is normally done with a maintenance plan >> through SQL Server, the transaction log never gets higher than 2 or 3GB. >> >> Is there any reason to this? Can I make a backup without transaction log >> taking so much space? >> >> >> Best regards, >> -- >> João C. Pinto <jc...@eu...> >> Eurotux Informática, S.A. >> >> > ------------------------------------------------------------------------------ >> Learn Windows Azure Live! Tuesday, Dec 13, 2011 >> Microsoft is holding a special Learn Windows Azure training event for >> developers. It will provide a great way to learn Windows Azure and what >> it >> provides. You can attend the event by watching it streamed LIVE online. >> Learn more at http://p.sf.net/sfu/ms-windowsazure >> _______________________________________________ >> Mssqlcompressed-users mailing list >> Mss...@li... >> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users >> |
|
From: João C. P. <jc...@eu...> - 2011-12-14 10:35:23
|
Hi, First of all, thanks for sharing a great tool that already proved to be very useful. When trying to make a backup through MSBP to a 35GB BD in simple mode I get the following error: 07:34:29 ------------------------ Exception #1 The transaction log for database 'MV.Web' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases BACKUP DATABASE is terminating abnormally. Processed 3806968 pages for database 'MV.Web', file 'MV.Web' on file 1. Processed 268653 pages for database 'MV.Web', file 'MV.Web_log' on file 1. System.Data.SqlClient.SqlException at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader() at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(IAsyncResult asyncResult) at MSBackupPipe.Common.SqlThread.EndExecute() in C:\Users\Clay\Documents\MSSQL Compressed\mssql sourceforge2\MSBackupPipe.Common\SqlThread.cs:line 492 The backup failed. Below are the commands for msbp.exe: msbp.exe help msbp.exe backup msbp.exe restore msbp.exe listplugins msbp.exe helpplugin msbp.exe version For more information, type msbp.exe help <command>. Process Exit Code 0. The step succeeded. After allowing the transaction log to auto-grow without any limit the backup successfully completes with the transaction log growing to near 12GB. However, if the backup is normally done with a maintenance plan through SQL Server, the transaction log never gets higher than 2 or 3GB. Is there any reason to this? Can I make a backup without transaction log taking so much space? Best regards, -- João C. Pinto <jc...@eu...> Eurotux Informática, S.A. |
|
From: Mickey N. <mn...@td...> - 2011-12-04 09:28:50
|
Hi Is it possible to use the "WITH COPY_ONLY" command with MSSQL Compressed, or could it possibly be implemented? My backupchain towards TSM breaks if I do not use copy_only Thanks, Mickey |
|
From: Mathhew J. <Mat...@tm...> - 2011-10-22 13:38:58
|
Hi, I have tried to run msbp.exe on a SQL 2000 server running windows 2000 server SP4, with .NET Framework 2.0 SP1. The following simple test was to backup the existing model database on the default instance (the system has two instances) but it errors with: J:\MDR-Prod-Backups\MSSQLCompressedBackup>msbp.exe backup "db(database=model)" "local(path=J:\testbackup.bak)" The specified module could not be found. (Exception from HRESULT: 0x8007007E) System.IO.FileNotFoundException at VdiNet.VirtualBackupDevice.Exe32Sql32.VirtualDeviceSetExe32Sql32..ctor() at VdiNet.VirtualBackupDevice.VirtualBackupDeviceFactory.NewVirtualDeviceSe t(SqlPlatform sqlP) in C:\Users\Clay\Documents\vdi.net\VdiNet.VirtualBackupDevice\VirtualBackup DeviceFactory.cs:line 18 at MSBackupPipe.Common.BackupPipeSystem.BackupOrRestore(Boolean isBackup, ConfigPair storageConfig, ConfigPair databaseConfig, List`1 pipelineConfig, IUpdateNotification updateNotifier) in C:\Users\Clay\Documents\MSSQL Compressed\mssql sourceforge2\MSBackupPipe.Common\BackupPipeSystem.cs:line 183 at MSBackupPipe.Common.BackupPipeSystem.Backup(ConfigPair databaseConfig, List`1 pipelineConfig, ConfigPair storageConfig, IUpdateNotification updateNotifier) in C:\Users\Clay\Documents\MSSQL Compressed\mssql sourceforge2\MSBackupPipe.Common\BackupPipeSystem.cs:line 51 at MSBackupPipe.Cmd.Program.Main(String[] args) in C:\Users\Clay\Documents\MSSQL Compressed\mssql sourceforge2\MSBackupPipe.Cmd\Program.cs:line 110 The backup failed. Below are the commands for msbp.exe: msbp.exe help msbp.exe backup msbp.exe restore msbp.exe listplugins msbp.exe helpplugin msbp.exe version For more information, type msbp.exe help <command> J:\MDR-Prod-Backups\MSSQLCompressedBackup> Regards, Mathhew |
|
From: Sharma, A. <Ama...@un...> - 2011-07-15 07:00:59
|
Hi, I am using MSBP compress backup utility across all SQL versions but on some of MSDE system I am getting "Request time out error". I have checked given below things- (1) .Net Fremwork 2.0 available. (2) Msbp software available. (3) Database is up and in working condition. (4) Default database instance - MSSLSERVER. OS- WINDOWS XP with SP 3 Database- MSDE 2000 8.0. Please suggest me what else could be the reason of failure of backup. Thanks Amardeep Sharma |
|
From: Sharma, A. <Ama...@un...> - 2011-07-15 06:17:37
|
Hi, I am using MSBP compress backup utility across all SQL versions but on some of MSDE system I am getting "Request time out error". I have checked given below things- (1) .Net Fremwork 2.0 available. (2) Msbp software available. (3) Database is up and in working condition. (4) Default database instance - MSSLSERVER. OS- WINDOWS XP with SP 3 Database- MSDE 2000 8.0. Please suggest me what else could be the reason of failure of backup. Thanks Amardeep Sharma |
|
From: Clay L. <cl...@le...> - 2011-05-18 21:36:40
|
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 > |
|
From: <ev...@me...> - 2011-05-16 13:23:19
|
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 >>> >> > > |
|
From: Vinko V. <el...@vi...> - 2011-05-16 13:05:18
|
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 >> > |
3 messages has been excluded from this view by a project administrator.
