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
>