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

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

[Vinko V. <el...@vi...>]

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

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

[<ev...@me...>]

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

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

[<ev...@me...>]

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
>

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

[Shah, H. <Hem...@un...>]

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

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

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

The msbp command looks correct to me.  I don't know enough about batch files
to say whether it is correct.

On 13 May 2011 13:01, <ev...@me...> wrote:

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

[Mssqlcompressed-users] Batch-backup. How?

[<ev...@me...>]

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

Re: [Mssqlcompressed-users] Need to backup, compress & Restore SQL Server 2005 backup files

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

There are some basic examples here:

http://mssqlcompressed.sourceforge.net/doc_started.shtml

All the options (except STATS) are available. The documentation is here:
http://mssqlcompressed.sourceforge.net/doc_plugins_db.shtml

STATS isn't available, b/c the tool provides its own stats feedback.

An example would be:
msbp restore "local(path=\\server\share\file.bak.zip)" zip64
"db(database=name;move='logical file name'TO'S:\file.mdf';move='logical
filename ldf'TO'T:\file.ldf';NORECOVERY)"




On 18 February 2011 11:10, Mandar Alawani <man...@gm...> wrote:

> Hi All,
>
>  I am in the middle of some Database restore which are huge in size and
> need to be moved over low bandwidth...
>
> Has anyone used this *mssqlcompressed *utility to backup, compress &
> Restore SQL Server 2005 backup files??
>
> I need to include parameters such as WITH RECOVERY, MOVE, STATS etc. in the
> RESTORE command, is this possible ??...
>
> if so, can someone please guide me through some examples...??
>
> any help is highly appreciated!!!....
>
> thanks in advance,
> mandar
>
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> Mssqlcompressed-users mailing list
> Mss...@li...
> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users
>
>

[Mssqlcompressed-users] Need to backup, compress & Restore SQL Server 2005 backup files

[Mandar A. <man...@gm...>]

Hi All,

 I am in the middle of some Database restore which are huge in size and need
to be moved over low bandwidth...

Has anyone used this *mssqlcompressed *utility to backup, compress & Restore
SQL Server 2005 backup files??

I need to include parameters such as WITH RECOVERY, MOVE, STATS etc. in the
RESTORE command, is this possible ??...

if so, can someone please guide me through some examples...??

any help is highly appreciated!!!....

thanks in advance,
mandar

[Mssqlcompressed-users] Old Backup Files

[<Dav...@pc...>]

Hello,


Can SQL Compressed Backup be configured to delete all backup files older
than a specified number of days?  I like to use it to backup 5 days of
zip64 files and then on the 6th day, I want it to be able to delete the
oldest file.  Please let me know if this can be done.


Thank you,


David

[Mssqlcompressed-users] Backup database name

[Nathan D. <Nat...@Ce...>]

Hi

As you name the zip, can the backup be named the same?

============================================================================

IMPORTANT NOTICE:

Cenduit Ltd registered in England (registered number 04140495)

Registered office Langhurstwood Road, Horsham, West Sussex, RH12 4QD.

Telephone: +44 1403 212700

Website: www.Cenduit.com

This message is subject to and does not create or vary any contractual relationship between Cenduit, its subsidiaries or affiliates and you. No contracts may be concluded on behalf of Cenduit by means of email communications. Please note that neither Cenduit nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Any view or opinion expressed are those of the author.

Dissemination, distribution or copying of this e-mail or the information herein by anyone other than the intended recipient, or an employee or agent of a system responsible or delivering the message to the intended recipient, is prohibited. If you are not the intended recipient, please inform the sender and delete all copies.

============================================================================

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________

Re: [Mssqlcompressed-users] MSBP is not starting to backup

[Vinko V. <vin...@fo...>]

Clay Lenhart wrote:
> There are scenerios within SQL Server that can block a backup.  I'd 
> look at the processes in SQL Server to see if there is any blocking.

That was indeed the case, one backup to virtual device process was hung. 
I killed it and I can now backup the database.

So, this leads me to ask, can MSBP realize that it's not making progress 
and terminate reporting error instead of waiting forever?

(A secondary question is why/when such a backup process stops 
progressing, but that is probably dependent on my specific setup and load)

Thanks,
V.

Re: [Mssqlcompressed-users] MSBP is not starting to backup

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

There are scenerios within SQL Server that can block a backup.  I'd look at
the processes in SQL Server to see if there is any blocking.

On 11 October 2010 16:50, Vinko Vrsalovic <vin...@fo...> wrote:

> On a specific database, msbp running as specified below never starts.
>
> C:\MSBP>msbp.exe backup [dbname] zip64(filename=dbname.bak)
> file://C:\test.bak
> local:
>        path=C:\test.bak
> zip64: level = 7, filename=dbname.bak
> ^C
>
> After a few minutes I break the command (in fact it hang for 72 hours as
> the scheduled
> task I have running it killed the task and there were three days without
> backups).
> msbp starts the backup instantly on other databases so this is a
> database specific
> problem. I have many copies of this database schema (from a single
> master source)
> running which can be backed up, so it doesn't look like it's the schema.
>
> dbcc checkdb ended with
>
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'dbname'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
> So, before I setup a development environment to test this I wanted to
> know if you can
> think of a scenario that would hang msbp right before starting the backup.
>
> Debugging guidelines would be helpful as well.
>
> Thanks for any input
>
> --
> Vinko Vrsalovic Bolte
> vin...@fo...
> Fonetic Solutions S.L.
> +34 917433326
> +34 608976970
>
>
>
> ------------------------------------------------------------------------------
> Beautiful is writing same markup. Internet Explorer 9 supports
> standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
> Spend less time writing and  rewriting code and more time creating great
> experiences on the web. Be a part of the beta today.
> http://p.sf.net/sfu/beautyoftheweb
> _______________________________________________
> Mssqlcompressed-users mailing list
> Mss...@li...
> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users
>

[Mssqlcompressed-users] MSBP is not starting to backup

[Vinko V. <vin...@fo...>]

On a specific database, msbp running as specified below never starts.

C:\MSBP>msbp.exe backup [dbname] zip64(filename=dbname.bak) 
file://C:\test.bak
local:
        path=C:\test.bak
zip64: level = 7, filename=dbname.bak
^C

After a few minutes I break the command (in fact it hang for 72 hours as 
the scheduled
task I have running it killed the task and there were three days without 
backups).
msbp starts the backup instantly on other databases so this is a 
database specific
problem. I have many copies of this database schema (from a single 
master source)
running which can be backed up, so it doesn't look like it's the schema.

dbcc checkdb ended with

CHECKDB found 0 allocation errors and 0 consistency errors in database 
'dbname'.
DBCC execution completed. If DBCC printed error messages, contact your 
system administrator.

So, before I setup a development environment to test this I wanted to 
know if you can
think of a scenario that would hang msbp right before starting the backup.

Debugging guidelines would be helpful as well.

Thanks for any input

-- 
Vinko Vrsalovic Bolte
vin...@fo...
Fonetic Solutions S.L.
+34 917433326
+34 608976970

Re: [Mssqlcompressed-users] restore verifyonly

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

Definitely!  It's on the todo list:
http://sourceforge.net/tracker/?func=detail&aid=2922404&group_id=229242&atid=1076259


On Wednesday, March 17, 2010, Antonio Ruiz Zwollo
<Ant...@me...> wrote:
> Hi,
>
> I was having a look at the Documentation and couldn't figure out if there is an option to do a "RESTORE VERIFYONLY".
>
> I.e.: I have 5 huge .bak files. So before doing a restore, to verify whether the .bak files are fine, I execute:
> ---
> RESTORE VERIFYONLY FROM BDVmyDb1, BDVmyDb2, BDVmyDb3, BDVmyDb4, BDVmyDb5
> ---
> If they are not, I don't attempt to drop & restore the database.
>
> Cheers,
>
>
> Antonio
>
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> Mssqlcompressed-users mailing list
> Mss...@li...
> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users
>

[Mssqlcompressed-users] restore verifyonly

[Antonio R. Z. <Ant...@me...>]

Hi,

I was having a look at the Documentation and couldn't figure out if there is an option to do a "RESTORE VERIFYONLY".

I.e.: I have 5 huge .bak files. So before doing a restore, to verify whether the .bak files are fine, I execute:
---
RESTORE VERIFYONLY FROM BDVmyDb1, BDVmyDb2, BDVmyDb3, BDVmyDb4, BDVmyDb5
---
If they are not, I don't attempt to drop & restore the database.

Cheers,


Antonio

Re: [Mssqlcompressed-users] norecovery, replace and move?

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

I'm glad it worked. :)

I think it important to use standard bak and compression file formats.
For example if there is file corruption on the backup medium, there
will be tools to address this.  I don't want to leave a DBA stuck in a
tight situation.

Clay

On Tuesday, March 16, 2010, Antonio Ruiz Zwollo
<Ant...@me...> wrote:
> Hi Clay,
>
> Thanks for your help. Just to let you know it worked flawlessly. Last night I restored a 127 GB database from 10 .bak.gz files (2.5 GB each). It only took 50 minutes:
> -------------
> Restore has started
>   0.00% Complete. Estimated End: 16/11/2073 16:50:17
>  11.12% Complete. Estimated End: 16/03/2010 01:44:20
>  25.64% Complete. Estimated End: 16/03/2010 00:52:29
>  45.47% Complete. Estimated End: 16/03/2010 00:35:36
>  77.45% Complete. Estimated End: 16/03/2010 00:24:21
> Completed Successfully. 00:50:47.0770990
> -------------
>
> The bak files were created by a traditional MSSQL backup job and then used gzip to compress them (thus the .bak.gz files had not been created by msbp); it's nice to see it works perfectly with third party .bak.gz files too.
>
> Cheers,
>
>
> Antonio
>
> Clay Lenhart wrote:
>> It is possible. An example would be:
>>
>> msbp.exe restore "local(path=c:\model.bak.gz)" gzip()
>> "db(database=model;filegroup=primary;checksum;MOVE='modeldev'TO'c:\model.mdf';MOVE='modellog'TO'c:\model.ldf';NORECOVERY;REPLACE;)"
>>
>>
>> You can find all the options here:
>>
>> http://mssqlcompressed.sourceforge.net/doc_plugins_db.shtml
>>
>>
>>
>> On 12 March 2010 16:56, Antonio Ruiz Zwollo
>> <Ant...@me...
>> <mailto:Ant...@me...>> wrote:
>>
>>     Hi,
>>
>>     Is it possible to use the NORECOVERY, REPLACE AND MOVE restore
>>     commands with msbp?
>>
>>     For example, currently I have a job setup which restores a database
>>     using this command:
>>     ------------------
>>     RESTORE DATABASE myDatabase
>>     FROM BDVmyDatabase1,BDVmyDatabase2,BDVmyDatabase3
>>     with
>>     move 'mydb_primary_data' to 'd:\myDatabase\mydb_primary_data.mdf',
>>     move 'mydb_daily_data1' to 'd:\myDatabase\mydb_daily_data1.ndf',
>>     move 'mydb_daily_data2' to 'd:\myDatabase\mydb_daily_data2.ndf',
>>     move 'mydb_daily_data3' to 'd:\myDatabase\mydb_daily_data3.ndf',
>>     move 'mydb_daily_data4' to 'd:\myDatabase\mydb_daily_data4.ndf',
>>     move 'mydb_rare_data20' to 'd:\myDatabase\mydb_rare_data20.ndf',
>>     move 'mydb_indx' to 'd:\myDatabase\mydb_indx.ndf',
>>     move 'mydb_log' to 'd:\myDatabase\mydb_log.ldf',
>>     REPLACE,
>>     NORECOVERY
>>     ------------------
>>
>>     The database uses three Backup devices:
>>     ------------------
>>     BDVmyDatabase1 D:\backup_files\BDVmyDatabase1.bak
>>     BDVmyDatabase2 D:\backup_files\BDVmyDatabase2.bak
>>     BDVmyDatabase3 D:\backup_files\BDVmyDatabase3.bak
>>     ------------------
>>
>>     Those backup devices are getting pretty big, so I would prefer to
>>     keep them compressed as .bak.gz files, and use msbp to restore the
>>     database directly from the compressed files.
>>
>>     However, I have not been able to figure out how the restore command
>>     would look like. I.e.
>>     -------------------------
>>     msbp.exe restore
>>     "local(path=D:\backup_files\BDVmyDatabase1.bak.gz;path=D:\backup_files\BDVmyDatabase2.bak.gz;path=D:\backup_files\BDVmyDatabase3.bak.gz;)"
>>     "gzip()" "db(database=myDatabase)"
>>     -------------------------
>>     but where do I state the MOVE, REPLACE and NORECOVERY options?
>>
>>     Thanks for your time!
>>
>>     Cheers,
>>
>>
>>     Antonio
>>
>>
>>
>>
>>
>>
>>     ------------------------------------------------------------------------------
>>     Download Intel&#174; Parallel Studio Eval
>>     Try the new software tools for yourself. Speed compiling, find bugs
>>     proactively, and fine-tune applications for parallel performance.
>>     See why Intel Parallel Studio got high marks during beta.
>>     http://p.sf.net/sfu/intel-sw-dev
>>     _______________________________________________
>>     Mssqlcompressed-users mailing list
>>     Mss...@li...
>>     <mailto:Mss...@li...>
>>     https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users
>>
>>
>

Re: [Mssqlcompressed-users] norecovery, replace and move?

[Antonio R. Z. <Ant...@me...>]

Hi Clay,

Thanks for your help. Just to let you know it worked flawlessly. Last night I restored a 127 GB database from 10 .bak.gz files (2.5 GB each). It only took 50 minutes:
-------------
Restore has started
  0.00% Complete. Estimated End: 16/11/2073 16:50:17 
 11.12% Complete. Estimated End: 16/03/2010 01:44:20 
 25.64% Complete. Estimated End: 16/03/2010 00:52:29 
 45.47% Complete. Estimated End: 16/03/2010 00:35:36 
 77.45% Complete. Estimated End: 16/03/2010 00:24:21 
Completed Successfully. 00:50:47.0770990
-------------

The bak files were created by a traditional MSSQL backup job and then used gzip to compress them (thus the .bak.gz files had not been created by msbp); it's nice to see it works perfectly with third party .bak.gz files too.

Cheers,


Antonio

Clay Lenhart wrote:
> It is possible. An example would be:
> 
> msbp.exe restore "local(path=c:\model.bak.gz)" gzip()
> "db(database=model;filegroup=primary;checksum;MOVE='modeldev'TO'c:\model.mdf';MOVE='modellog'TO'c:\model.ldf';NORECOVERY;REPLACE;)"
> 
> 
> You can find all the options here:
> 
> http://mssqlcompressed.sourceforge.net/doc_plugins_db.shtml
> 
> 
> 
> On 12 March 2010 16:56, Antonio Ruiz Zwollo
> <Ant...@me...
> <mailto:Ant...@me...>> wrote:
> 
>     Hi,
> 
>     Is it possible to use the NORECOVERY, REPLACE AND MOVE restore
>     commands with msbp?
> 
>     For example, currently I have a job setup which restores a database
>     using this command:
>     ------------------
>     RESTORE DATABASE myDatabase
>     FROM BDVmyDatabase1,BDVmyDatabase2,BDVmyDatabase3
>     with
>     move 'mydb_primary_data' to 'd:\myDatabase\mydb_primary_data.mdf',
>     move 'mydb_daily_data1' to 'd:\myDatabase\mydb_daily_data1.ndf',
>     move 'mydb_daily_data2' to 'd:\myDatabase\mydb_daily_data2.ndf',
>     move 'mydb_daily_data3' to 'd:\myDatabase\mydb_daily_data3.ndf',
>     move 'mydb_daily_data4' to 'd:\myDatabase\mydb_daily_data4.ndf',
>     move 'mydb_rare_data20' to 'd:\myDatabase\mydb_rare_data20.ndf',
>     move 'mydb_indx' to 'd:\myDatabase\mydb_indx.ndf',
>     move 'mydb_log' to 'd:\myDatabase\mydb_log.ldf',
>     REPLACE,
>     NORECOVERY
>     ------------------
> 
>     The database uses three Backup devices:
>     ------------------
>     BDVmyDatabase1 D:\backup_files\BDVmyDatabase1.bak
>     BDVmyDatabase2 D:\backup_files\BDVmyDatabase2.bak
>     BDVmyDatabase3 D:\backup_files\BDVmyDatabase3.bak
>     ------------------
> 
>     Those backup devices are getting pretty big, so I would prefer to
>     keep them compressed as .bak.gz files, and use msbp to restore the
>     database directly from the compressed files.
> 
>     However, I have not been able to figure out how the restore command
>     would look like. I.e.
>     -------------------------
>     msbp.exe restore
>     "local(path=D:\backup_files\BDVmyDatabase1.bak.gz;path=D:\backup_files\BDVmyDatabase2.bak.gz;path=D:\backup_files\BDVmyDatabase3.bak.gz;)"
>     "gzip()" "db(database=myDatabase)"
>     -------------------------
>     but where do I state the MOVE, REPLACE and NORECOVERY options?
> 
>     Thanks for your time!
> 
>     Cheers,
> 
> 
>     Antonio
> 
> 
> 
> 
> 
> 
>     ------------------------------------------------------------------------------
>     Download Intel&#174; Parallel Studio Eval
>     Try the new software tools for yourself. Speed compiling, find bugs
>     proactively, and fine-tune applications for parallel performance.
>     See why Intel Parallel Studio got high marks during beta.
>     http://p.sf.net/sfu/intel-sw-dev
>     _______________________________________________
>     Mssqlcompressed-users mailing list
>     Mss...@li...
>     <mailto:Mss...@li...>
>     https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users
> 
> 

Re: [Mssqlcompressed-users] norecovery, replace and move?

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

It is possible. An example would be:

msbp.exe restore "local(path=c:\model.bak.gz)" gzip()
"db(database=model;filegroup=primary;checksum;MOVE='modeldev'TO'c:\model.mdf';MOVE='modellog'TO'c:\model.ldf';NORECOVERY;REPLACE;)"


You can find all the options here:

http://mssqlcompressed.sourceforge.net/doc_plugins_db.shtml



On 12 March 2010 16:56, Antonio Ruiz Zwollo <
Ant...@me...> wrote:

> Hi,
>
> Is it possible to use the NORECOVERY, REPLACE AND MOVE restore commands
> with msbp?
>
> For example, currently I have a job setup which restores a database using
> this command:
> ------------------
> RESTORE DATABASE myDatabase
> FROM BDVmyDatabase1,BDVmyDatabase2,BDVmyDatabase3
> with
> move 'mydb_primary_data' to 'd:\myDatabase\mydb_primary_data.mdf',
> move 'mydb_daily_data1' to 'd:\myDatabase\mydb_daily_data1.ndf',
> move 'mydb_daily_data2' to 'd:\myDatabase\mydb_daily_data2.ndf',
> move 'mydb_daily_data3' to 'd:\myDatabase\mydb_daily_data3.ndf',
> move 'mydb_daily_data4' to 'd:\myDatabase\mydb_daily_data4.ndf',
> move 'mydb_rare_data20' to 'd:\myDatabase\mydb_rare_data20.ndf',
> move 'mydb_indx' to 'd:\myDatabase\mydb_indx.ndf',
> move 'mydb_log' to 'd:\myDatabase\mydb_log.ldf',
> REPLACE,
> NORECOVERY
> ------------------
>
> The database uses three Backup devices:
> ------------------
> BDVmyDatabase1 D:\backup_files\BDVmyDatabase1.bak
> BDVmyDatabase2 D:\backup_files\BDVmyDatabase2.bak
> BDVmyDatabase3 D:\backup_files\BDVmyDatabase3.bak
> ------------------
>
> Those backup devices are getting pretty big, so I would prefer to keep them
> compressed as .bak.gz files, and use msbp to restore the database directly
> from the compressed files.
>
> However, I have not been able to figure out how the restore command would
> look like. I.e.
> -------------------------
> msbp.exe restore
> "local(path=D:\backup_files\BDVmyDatabase1.bak.gz;path=D:\backup_files\BDVmyDatabase2.bak.gz;path=D:\backup_files\BDVmyDatabase3.bak.gz;)"
> "gzip()" "db(database=myDatabase)"
> -------------------------
> but where do I state the MOVE, REPLACE and NORECOVERY options?
>
> Thanks for your time!
>
> Cheers,
>
>
> Antonio
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> Mssqlcompressed-users mailing list
> Mss...@li...
> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users
>

[Mssqlcompressed-users] norecovery, replace and move?

[Antonio R. Z. <Ant...@me...>]

Hi,

Is it possible to use the NORECOVERY, REPLACE AND MOVE restore commands with msbp?

For example, currently I have a job setup which restores a database using this command:
------------------
RESTORE DATABASE myDatabase 
FROM BDVmyDatabase1,BDVmyDatabase2,BDVmyDatabase3
with 
move 'mydb_primary_data' to 'd:\myDatabase\mydb_primary_data.mdf',
move 'mydb_daily_data1' to 'd:\myDatabase\mydb_daily_data1.ndf',
move 'mydb_daily_data2' to 'd:\myDatabase\mydb_daily_data2.ndf',
move 'mydb_daily_data3' to 'd:\myDatabase\mydb_daily_data3.ndf',
move 'mydb_daily_data4' to 'd:\myDatabase\mydb_daily_data4.ndf',
move 'mydb_rare_data20' to 'd:\myDatabase\mydb_rare_data20.ndf',
move 'mydb_indx' to 'd:\myDatabase\mydb_indx.ndf',
move 'mydb_log' to 'd:\myDatabase\mydb_log.ldf',
REPLACE,
NORECOVERY
------------------

The database uses three Backup devices:
------------------
BDVmyDatabase1 D:\backup_files\BDVmyDatabase1.bak
BDVmyDatabase2 D:\backup_files\BDVmyDatabase2.bak
BDVmyDatabase3 D:\backup_files\BDVmyDatabase3.bak
------------------

Those backup devices are getting pretty big, so I would prefer to keep them compressed as .bak.gz files, and use msbp to restore the database directly from the compressed files.

However, I have not been able to figure out how the restore command would look like. I.e.
-------------------------
msbp.exe restore "local(path=D:\backup_files\BDVmyDatabase1.bak.gz;path=D:\backup_files\BDVmyDatabase2.bak.gz;path=D:\backup_files\BDVmyDatabase3.bak.gz;)" "gzip()" "db(database=myDatabase)" 
-------------------------
but where do I state the MOVE, REPLACE and NORECOVERY options?

Thanks for your time!

Cheers,


Antonio

[Mssqlcompressed-users] norecovery, replace and move?

[Antonio R. Z. <Ant...@me...>]

Hi,

Is it possible to use the NORECOVERY, REPLACE AND MOVE restore commands with msbp?

For example, currently I have a job setup which restores a database using this command:
------------------
RESTORE DATABASE myDatabase 
FROM BDVmyDatabase1,BDVmyDatabase2,BDVmyDatabase3
with 
move 'mydb_primary_data' to 'd:\myDatabase\mydb_primary_data.mdf',
move 'mydb_daily_data1' to 'd:\myDatabase\mydb_daily_data1.ndf',
move 'mydb_daily_data2' to 'd:\myDatabase\mydb_daily_data2.ndf',
move 'mydb_daily_data3' to 'd:\myDatabase\mydb_daily_data3.ndf',
move 'mydb_daily_data4' to 'd:\myDatabase\mydb_daily_data4.ndf',
move 'mydb_rare_data20' to 'd:\myDatabase\mydb_rare_data20.ndf',
move 'mydb_indx' to 'd:\myDatabase\mydb_indx.ndf',
move 'mydb_log' to 'd:\myDatabase\mydb_log.ldf',
REPLACE,
NORECOVERY
------------------

The database uses three Backup devices:
------------------
BDVmyDatabase1 D:\backup_files\BDVmyDatabase1.bak
BDVmyDatabase2 D:\backup_files\BDVmyDatabase2.bak
BDVmyDatabase3 D:\backup_files\BDVmyDatabase3.bak
------------------

Those backup devices are getting pretty big, so I would prefer to keep them compressed as .bak.gz files, and use msbp to restore the database directly from the compressed files.

However, I have not been able to figure out how the restore command would look like. I.e.
-------------------------
msbp.exe restore "local(path=D:\backup_files\BDVmyDatabase1.bak.gz;path=D:\backup_files\BDVmyDatabase2.bak.gz;path=D:\backup_files\BDVmyDatabase3.bak.gz;)" "gzip()" "db(database=myDatabase)" 
-------------------------
but where do I state the MOVE, REPLACE and NORECOVERY options?

Thanks for your time!

Cheers,


Antonio

Re: [Mssqlcompressed-users] Problem with SQL 2008 backup

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

This means that the VDI DLL is not installed, or not installed properly.
The DLL (for all versions of SQL Server) is located here:

C:\Program Files\Microsoft SQL Server\80\COM\vdi.dll

This location can vary if you have the 64-bit edition of SQL Server, but it
is in <sql server folder>\80\COM\vdi.dll

I'd check that the file exists, and if not, find a way to install it.  I
wouldn't be surprised if uninstalling an older version of SQL Server removed
it even though 2008 is installed.

-Clay

On 1 February 2010 23:38, Ben Whaley <be...@at...> wrote:

> All,
>
> I'm having a problem using msbp with a 2008 server. This worked before
> on a 2005 system but now I get the following error:
>
> c:\>msbp.exe backup "db(database=mydb)" "local(path=c:\backups\backup.bak)"
> local:
>        path=c:\backups\backup.bak
> ------------------------
> Exception #1
> VDS::Create failed: x80070005
>
> System.InvalidProgramException
>   at MSBackupPipe.VirtualBackupDevice.VirtualDeviceSet.CreateEx(String
> instance
> Name, String deviceSetName, VirtualDeviceSetConfig config) in
> c:\documents and s
> ettings\clay.lenhart\my
> documents\personal\hg\mssqlcompressed\msbackuppipe.virtu
> albackupdevice\virtualdeviceset.cpp:line 93
>   at MSBackupPipe.Common.BackupPipeSystem.BackupOrRestore(Boolean
> isBackup, Con
> figPair storageConfig, ConfigPair databaseConfig, List`1 pipelineConfig,
> IUpdate
> Notification updateNotifier) in C:\Documents and
> Settings\clay.lenhart\My Docume
>
> nts\personal\Hg\mssqlcompressed\MSBackupPipe.Common\BackupPipeSystem.cs:line
> 104
>
>
>
> 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>
>
> Any ideas on this one?
>
> - Ben
>
>
> --
> Ben Whaley, RHCE, CISSP
> Applied Trust Engineering - www.atrust.com - 303.245.4521
> Security, Performance, Availability, and Incident Management
>  ---- visit our blog at http://www.barkingseal.com ----
>
>
> ------------------------------------------------------------------------------
> The Planet: dedicated and managed hosting, cloud storage, colocation
> Stay online with enterprise data centers and the best network in the
> business
> Choose flexible plans and management services without long-term contracts
> Personal 24x7 support from experience hosting pros just a phone call away.
> http://p.sf.net/sfu/theplanet-com
> _______________________________________________
> Mssqlcompressed-users mailing list
> Mss...@li...
> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users
>

[Mssqlcompressed-users] Problem with SQL 2008 backup

[Ben W. <be...@at...>]

All,

I'm having a problem using msbp with a 2008 server. This worked before
on a 2005 system but now I get the following error:

c:\>msbp.exe backup "db(database=mydb)" "local(path=c:\backups\backup.bak)"
local:
        path=c:\backups\backup.bak
------------------------
Exception #1
VDS::Create failed: x80070005

System.InvalidProgramException
   at MSBackupPipe.VirtualBackupDevice.VirtualDeviceSet.CreateEx(String
instance
Name, String deviceSetName, VirtualDeviceSetConfig config) in
c:\documents and s
ettings\clay.lenhart\my
documents\personal\hg\mssqlcompressed\msbackuppipe.virtu
albackupdevice\virtualdeviceset.cpp:line 93
   at MSBackupPipe.Common.BackupPipeSystem.BackupOrRestore(Boolean
isBackup, Con
figPair storageConfig, ConfigPair databaseConfig, List`1 pipelineConfig,
IUpdate
Notification updateNotifier) in C:\Documents and
Settings\clay.lenhart\My Docume
nts\personal\Hg\mssqlcompressed\MSBackupPipe.Common\BackupPipeSystem.cs:line
104



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>

Any ideas on this one?

- Ben


-- 
Ben Whaley, RHCE, CISSP
Applied Trust Engineering - www.atrust.com - 303.245.4521
Security, Performance, Availability, and Incident Management
  ---- visit our blog at http://www.barkingseal.com ----

Re: [Mssqlcompressed-users] Multithreaded compression

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

Louie,

Whoops!  I've missed documenting the multithread option on the website.

Each destination file has its own thread (including the pipeline to the file
such as compression), so you can specify multiple files with multiple "path"
parameters in the "local" storage plugin:

msbp.exe backup "db(database=model)" zip64
"local(path=c:\model1.bak.zip;path=c:\model2.bak.zip)"

The reason it was done this way is that some compression file formats, like
gzip, do not allow for multithreaded compression very easily, and I didn't
want to make a custom file formats that similar products have done so that
the backups msbp.exe produces is easy to restore without any proprietary
software.

I originally (before this project) played around with backing up to a
Windows compressed folder, but it kept locking up for larger backups (over
32 GB I think), which lead to this project.  I don't know if Windows files
compression is multicore.  I would suspect that it is single-core for one
file, but if you back up to multiple files you could achieve multicore
compression.

Cheers,
Clay


2009/12/15 Louie Gregg <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
>
> 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.
>
>
> ------------------------------------------------------------------------------
> Return on Information:
> Google Enterprise Search pays you back
> Get the facts.
> http://p.sf.net/sfu/google-dev2dev
>
> _______________________________________________
> Mssqlcompressed-users mailing list
> Mss...@li...
> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users
>
>

Re: [Mssqlcompressed-users] mssqlcompressed with powershellscript

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

Thanks Otis!

[Mssqlcompressed-users] mssqlcompressed with powershellscript

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

Hi all,
now i have integrated the msbp.exe in a litle powershellscript, which
the taskplaner starts every night:
powershell.exe  D:\DB-Dumps\MSSQLCompressedBackup\BackupScriptForDBs.ps1

- so, that i have a backupserie from a whole week, maybe, that
somebody could make use of this litle script.


function BackupFolder
{
    param( [object] $objSrcFolder, [object] $objDstFolder)
    $strSrcFolder = $objSrcFolder.Path
    $strDstFolder = $objDstFolder.Path
    $colSrcFiles = $objSrcFolder.Files
    $colDstFiles = $objDstFolder.Files

    $ActualDay =    (get-date).dayofweek.toString() + "_"

       #after backing up the database - rename the logfile and db-zip
with the actual days
       foreach ($objSrcFile in $colSrcFiles)
        {
              Rename-Item ($strSrcFolder + "\"  +  $objSrcFile.Name)
-NewName ($ActualDay  + $objSrcFile.Name )
        }
       #move it from the db-server to another storagelocation in the intranet
       foreach ($objSrcFile in $colSrcFiles)
        {
            move-item ($strSrcFolder + "\" +  $objSrcFile.Name )
$strDstFolder  -force
        }

    }


# -----------------------------------------------------
# main
#backup the db and rename it with the actual day and move it to another location

$strSourceFolder      = "D:\DB-Dumps\MSSQLCompressedBackup\BackupsTmp"
$strDestinationFolder = "\\Test-sqlb01\NVinity\RepositoryBackups_Test-EntwDB01"
$FSO = New-Object -COM Scripting.FileSystemObject
$objSourceFolder = $FSO.GetFolder($strSourceFolder)
$objDestinationFolder = $FSO.GetFolder($strDestinationFolder)

#backing up the db
invoke-expression -command "D:\DB-Dumps\MSSQLCompressedBackup\msbp.exe
 backup  `"db(database=NV_REP_ENTWICKLUNG)`"
`"zip64(level=3;filename=NV_REP_ENTWICKLUNG.bak)`"
`"local(path=d:\db-Dumps\MSSQLCompressedBackup\BackupsTmp\NV_REP_ENTWICKLUNG.bak.zip)`"
>> d:\db-Dumps\MSSQLCompressedBackup\BackupsTmp\NV_REP_ENTW_BACKUP_LOG.txt
"

#after running the msbp.exe, i backup the logfile and dbbackupfile to
another place in the intranet
BackupFolder $objSourceFolder $objDestinationFolder

best regards!
Otis