--- In firebird-support@yahoogroups.com, "Maurice Ling"
<beldin79@y...> wrote:

>
> Hi Helen,
>
> Thanks for the pointers. This works:
>
> zmling2:~/MyProjects/Muscorian/BioDatabases mauriceling$ gbak -R -

user

> mouse -password mouse muscopedia.311005.1 muscopedia.311005.2
> muscopedia.fdb 500000 muscopedia.fd2 500000 muscopedia.fd3 500000
> muscopedia.fd4 500000 muscopedia.fd5 500000 muscopedia.fd6 500000
> muscopedia.fd7 500000 muscopedia.fd8 500000 muscopedia.fd9
>
> In my SQL that creates the database, I've specified the page size to
> be 4096, so gbak somehow reads that page size and multiply it by
> 500000 to give a max file size of 2GB?

Well it limits the number of pages created in each file anyway. You
specify to put 500000 pages in each file, and at 4K that just happens
to give 2GB (if your calcs are correct, I didn't check).

>
> My database creation DDLs are as follows:
> create database 'muscopedia.fdb'
> user 'mouse' password 'mouse'
> page_size 4096
> length 500000;
> alter database add file 'muscopedia.fb2' starting at page 500001
> length 500000;
> alter database add file 'muscopedia.fb3' starting at page 1000001
> length 500000;
> alter database add file 'muscopedia.fb4' starting at page 1500001
> length 500000;
> alter database add file 'muscopedia.fb5' starting at page 2000001
> length 500000;
> alter database add file 'muscopedia.fb6' starting at page 2500001
> length 500000;
> alter database add file 'muscopedia.fb7' starting at page 3000001
> length 500000;
> alter database add file 'muscopedia.fb8' starting at page 3500001
> length 500000;
> alter database add file 'muscopedia.fb9' starting at page 4000001
> length 500000;
> commit;
>
> Also Helen, why is -C[reate database] more desirable than -R[estore]
> switch?
>

A restore can fail. Many reasons, normally because there is something
wrong with the backup file itself. If you use -C and restore the file
elsewhere, then if it fails then at least you have the old database
still.

Obviously once the restore is validated by you as successful, you can
transfer it in or adjust the alias to point at the new location.

I think that is the calmest I have ever seen Helen when someone
proposed to use -R. Most of us have had "never use -R" tattooed to
our face :)

Adam