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