Sybase Philippines

Hello again,

I'm trying to restore a backup (dump dbase) on my backup server. In my primary server, I successfully backup my dbase using the backup method/command with the option "backup entire database". As I restore it in my backup server, an error eccoured stating that the dump dbase uses 75000MB of space! So I recreated my devices to allocate enough space. But when I recreate the dbase, it takes me almost forever! Why??

Ff. are the parameters of my dbase and server:

Server specs: Intel Quad Core, 2.4 Ghz speed; 4GB of RAM; RAID configured w/ 500+ GB on all hard drives.

Sybase: ver 12.0;
master.dat -> 100MB
sybprocs.dat -> 150MB
Devices:
dbase_dev00.dat -> 30000 MB
dbase_dev01.dat -> 30000 MB
dbase_dev02.dat -> 20000 MB
dbase_log00.dat -> 20000 MB
dbase_log01.dat -> 20000 MB

Why does it take too long for the creation of my dbase? IS there something wrong with my configuration or server?

1. Have you configured your database cache, memory, no of engines?
sp_configure 'max memory',<inpages>
sp_cacheconfig 'default data cache', '####m'
sp_configure 'max online engine',##

2. Your deviced size are too large, make it in a chunk of at least 5g each.
Make it in stages:
Create database mydb --- 5gb data 2gb log
alter database mydb ---- 5gb data --- etc
...
Until you reach the target size

3. Create your database with a FOR LOAD to make it faster.

4. Your OS may have some limitations on the maximum memory you
can configure

-A 32bit Windows can have a max of 1.75GB memory
-You should have the Windows data center edition

-You can increase memory using:
imagecfg sqlsrvr.exe

Read the Manual
http://sybooks.sybase.com/nav/summary.d ... &archive=0

Sir Ed, if it isn't too much bother, can you teach me how to do all you've said? As I have said, I'm new to Sybase. For instance:

1. Have you configured your database cache, memory, no of engines?
sp_configure 'max memory',<inpages>
sp_cacheconfig 'default data cache', '####m'
sp_configure 'max online engine',##

--> where and how can I check on these?


2. Your deviced size are too large, make it in a chunk of at least 5g each.
Make it in stages:
Create database mydb --- 5gb data 2gb log
alter database mydb ---- 5gb data --- etc
...
Until you reach the target size

--> I tried creating my devices on several chunks but after the 9th device, I can no longer add another..

3. Create your database with a FOR LOAD to make it faster.
--> Ok this I can try

4. Your OS may have some limitations on the maximum memory you
can configure

-A 32bit Windows can have a max of 1.75GB memory
-You should have the Windows data center edition --> I'm using Windows 2000 Advanced Server SP4. I increased the RAM at 2GB

-You can increase memory using:
imagecfg sqlsrvr.exe --> where will I run this?

I really appreciate your help. Thanks!