Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Cannot restore more than 2 user databases please help.

6 posts in Backup and Recovery Last posting was on 2001-03-22 08:22:41.0Z
Shaun Chanthery Posted on 2001-03-20 11:39:53.0Z
From: "Shaun Chanthery" <sonics@paramed.com.au>
Subject: Cannot restore more than 2 user databases please help.
Date: Tue, 20 Mar 2001 21:39:53 +1000
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <UG87wxSsAHA.301@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
NNTP-Posting-Host: 210.15.231.144
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:379
Article PK: 1060896

Hi everyone,

I have installed ASE-12_0 with SWR 9314 on Windows 2000 Server successful.
However when i restore the dumps of 12.0 from another server to this server,
i only can restore 2 users databases. When i begin to restore the third
database, the backup server began to load , it then crash the whole server
during the loading. I have to switch off the server in order to reboot it.
Once rebooted i had to drop the database is it was corrupted and in process
of restoring or something. I can duplicate this scenario everytime. Is there
a setting on the database server that only allowed to restore two databases
only.

The weird thing is that i can always restore the first two databases again
and again without any problem.

Please help. Thank you

--
SC


Anthony Mandic <amandic Posted on 2001-03-20 12:14:55.0Z
Date: Tue, 20 Mar 2001 22:14:55 +1000
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Cannot restore more than 2 user databases please help.
References: <UG87wxSsAHA.301@forums.sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <1OiuPITsAHA.199@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 30
NNTP-Posting-Host: CPE-208-111-111-203.syd.dav.net.au 203.111.111.208
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:378
Article PK: 1060895


Shaun Chanthery wrote:

> I have installed ASE-12_0 with SWR 9314 on Windows 2000 Server successful.
> However when i restore the dumps of 12.0 from another server to this server,
> i only can restore 2 users databases. When i begin to restore the third
> database, the backup server began to load , it then crash the whole server
> during the loading. I have to switch off the server in order to reboot it.
> Once rebooted i had to drop the database is it was corrupted and in process
> of restoring or something. I can duplicate this scenario everytime. Is there
> a setting on the database server that only allowed to restore two databases
> only.

No. There are no restrictions. Can you describe the crash in
more descriptive detail? What actually happens? How large is the
dump? How large is the database? Does the tape have a physical error?

> The weird thing is that i can always restore the first two databases again
> and again without any problem.

Are there any messages in the backup server's log or the server's
log related to the problem (or about the time the crash occurs)?
What is the version of the backup server (its in its log)?

-am © 2001


Shaun Chanthery Posted on 2001-03-22 04:16:47.0Z
From: "Shaun Chanthery" <sonics@paramed.com.au>
References: <UG87wxSsAHA.301@forums.sybase.com> <1OiuPITsAHA.199@forums.sybase.com>
Subject: Re: Cannot restore more than 2 user databases please help.
Date: Thu, 22 Mar 2001 14:16:47 +1000
Lines: 96
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <sD$1PLosAHA.53@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
NNTP-Posting-Host: 210.15.231.144
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:371
Article PK: 1060888

Hi AM, Thanks for the response:

"Anthony Mandic" <amandic@*t.com.au> wrote in message
news:1OiuPITsAHA.199@forums.sybase.com...
> Shaun Chanthery wrote:
>
> > I have installed ASE-12_0 with SWR 9314 on Windows 2000 Server
successful.
> > However when i restore the dumps of 12.0 from another server to this
server,
> > i only can restore 2 users databases. When i begin to restore the third
> > database, the backup server began to load , it then crash the whole
server
> > during the loading. I have to switch off the server in order to reboot
it.
> > Once rebooted i had to drop the database is it was corrupted and in
process
> > of restoring or something. I can duplicate this scenario everytime. Is
there
> > a setting on the database server that only allowed to restore two
databases
> > only.
>
> No. There are no restrictions. Can you describe the crash in
> more descriptive detail? What actually happens? How large is the
> dump? How large is the database? Does the tape have a physical error?

Two scenarios i've tried: (Assumption: dbase3= 'stoccaprdaudit')

The dump file is about 2MB to be restore into a 60MB database (50MB data and
10MB-log). Dump file reside on harddisk with RAID 5 configuration.


1: Restored user databases (dbase1), and (dbase2) from dbase1.dmp and
dbase2.dmp dump files respectively, and i loaded successfully. When i tried
to restore the third database (dbase3) from dbase3.dmp dump file, it began
the restore and then it stopped (see below from backup.log file).

Mar 20 18:48:45 2001: Backup Server: 1.70.1.1: Configuring the maximum
shared memory usage to 48 MB.
Mar 20 18:48:45 2001: Backup Server: 1.69.1.2: Configuring the number of
service threads to 48.
Mar 20 18:48:45 2001: Backup Server: 1.70.1.3: Configuring the shared memory
per stripe to 1048576 bytes.
Mar 20 18:50:47 2001: Backup Server: 6.28.1.1: Dumpfile name
'rdaudit010790F9E4' section number 1 mounted on disk file
'D:\SybaseDB\Backup\stoccaprdaudit.dmp'
Mar 20 18:50:48 2001: Backup Server: 4.58.1.1: Database stoccaprdaudit: 2456
kilobytes LOADed.
Mar 20 18:50:49 2001: Backup Server: 4.58.1.1: Database stoccaprdaudit: 5366
kilobytes LOADed.
Mar 20 18:50:50 2001: Backup Server: 4.58.1.1: Database stoccaprdaudit: 8300
kilobytes LOADed.
Mar 20 18:56:06 2001: Backup Server/12.0.0.2/P/SWR 9314 ROLLUP/NT (IX86)/OS
4.0/1473/32bit/OPT/Wed Dec 13 18:36:08 2000

It then froze the whole server and the only option left for me was to hit
the RESET button on the server. And of course when the server is booted and
trying to bring all the user databases online it had problem with database
dbase3 as it cannot recover from the failed restore. I then had to drop the
database and recreated again.


2: This time i just created some tables on the database (dbase3), backup the
database to file dbase3.dmp. When i tried to restore the dump file back the
problem occurs again but this time earlier on the load process. (see below)

Mar 22 08:42:57 2001: Backup Server: 1.70.1.1: Configuring the maximum
shared memory usage to 48 MB.
Mar 22 08:42:57 2001: Backup Server: 1.69.1.2: Configuring the number of
service threads to 48.
Mar 22 08:42:57 2001: Backup Server: 1.70.1.3: Configuring the shared memory
per stripe to 1048576 bytes.

>
> > The weird thing is that i can always restore the first two databases
again
> > and again without any problem.
>
> Are there any messages in the backup server's log or the server's
> log related to the problem (or about the time the crash occurs)?

> What is the version of the backup server (its in its log)?

Mar 20 18:56:06 2001: Backup Server/12.0.0.2/P/SWR 9314 ROLLUP/NT (IX86)/OS
4.0/1473/32bit/OPT/Wed Dec 13 18:36:08 2000


Thanks in advance.

--SC

>
> -am © 2001


Anthony Mandic <amandic Posted on 2001-03-22 06:23:18.0Z
Date: Thu, 22 Mar 2001 17:23:18 +1100
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Cannot restore more than 2 user databases please help.
References: <UG87wxSsAHA.301@forums.sybase.com> <1OiuPITsAHA.199@forums.sybase.com> <sD$1PLosAHA.53@forums.sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <uNRTNrpsAHA.301@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 32
NNTP-Posting-Host: 210.9.51.46
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:369
Article PK: 1060886


Shaun Chanthery wrote:

> Two scenarios i've tried: (Assumption: dbase3= 'stoccaprdaudit')
>
> The dump file is about 2MB to be restore into a 60MB database (50MB data and
> 10MB-log). Dump file reside on harddisk with RAID 5 configuration.
>
> 1: Restored user databases (dbase1), and (dbase2) from dbase1.dmp and
> dbase2.dmp dump files respectively, and i loaded successfully. When i tried
> to restore the third database (dbase3) from dbase3.dmp dump file, it began
> the restore and then it stopped (see below from backup.log file).

What happens if you load it without the other two? Or load it
first etc.?

> It then froze the whole server and the only option left for me was to hit
> the RESET button on the server. And of course when the server is booted and
> trying to bring all the user databases online it had problem with database
> dbase3 as it cannot recover from the failed restore. I then had to drop the
> database and recreated again.

Are you sure it actually froze it or has the CPU usage just gone high?
You are loading a 2MB dump into a 60MB db. It would have to clear the
other 58MB. This shouldn't take too long but it will shoot the CPU up.
Try letting it run and then see if it comes back.

-am © 2001


Shaun Chanthery Posted on 2001-03-22 08:22:41.0Z
From: "Shaun Chanthery" <sonics@paramed.com.au>
References: <UG87wxSsAHA.301@forums.sybase.com> <1OiuPITsAHA.199@forums.sybase.com> <sD$1PLosAHA.53@forums.sybase.com> <uNRTNrpsAHA.301@forums.sybase.com>
Subject: Re: Cannot restore more than 2 user databases please help.
Date: Thu, 22 Mar 2001 18:22:41 +1000
Lines: 58
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <$ABOENqsAHA.199@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
NNTP-Posting-Host: 210.15.231.144
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:368
Article PK: 1060885

Thanks for the help.

"Anthony Mandic" <amandic@*t.com.au> wrote in message
news:uNRTNrpsAHA.301@forums.sybase.com...
> Shaun Chanthery wrote:
>
> > Two scenarios i've tried: (Assumption: dbase3= 'stoccaprdaudit')
> >
> > The dump file is about 2MB to be restore into a 60MB database (50MB data
and
> > 10MB-log). Dump file reside on harddisk with RAID 5 configuration.
> >
> > 1: Restored user databases (dbase1), and (dbase2) from dbase1.dmp and
> > dbase2.dmp dump files respectively, and i loaded successfully. When i
tried
> > to restore the third database (dbase3) from dbase3.dmp dump file, it
began
> > the restore and then it stopped (see below from backup.log file).
>
> What happens if you load it without the other two? Or load it
> first etc.?

I stopped the server remove it from registry. Then unload the software and
rebuilt it again. Run my user database creation script and restore the
database in different order (ie dbase3 first and then dbase1) when i did
dbase2 it failed.(weird)

>
> > It then froze the whole server and the only option left for me was to
hit
> > the RESET button on the server. And of course when the server is booted
and
> > trying to bring all the user databases online it had problem with
database
> > dbase3 as it cannot recover from the failed restore. I then had to drop
the
> > database and recreated again.
>
> Are you sure it actually froze it or has the CPU usage just gone high?
> You are loading a 2MB dump into a 60MB db. It would have to clear the
> other 58MB. This shouldn't take too long but it will shoot the CPU up.
> Try letting it run and then see if it comes back.

I left it running for at least an half hour and still no response. When i
tried to bring up task manager, it never came at all and it left it running
for at least an hour. As usual the only option left is hit the RESET button.

I might open a case with Sybase support. ( sorry to say, but i have doubt
if it is resolvable, unless i reinstall Windows 2000 again and Sybase ASE 1
2.0 again)

Regards
-SC

>
> -am © 2001


Anthony Mandic <amandic Posted on 2001-03-22 07:34:15.0Z
Date: Thu, 22 Mar 2001 18:34:15 +1100
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Cannot restore more than 2 user databases please help.
References: <UG87wxSsAHA.301@forums.sybase.com> <1OiuPITsAHA.199@forums.sybase.com> <sD$1PLosAHA.53@forums.sybase.com> <uNRTNrpsAHA.301@forums.sybase.com> <$ABOENqsAHA.199@forums.sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <QrlI1SqsAHA.199@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 30
NNTP-Posting-Host: 210.9.51.46
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:367
Article PK: 1060884


Shaun Chanthery wrote:

> I stopped the server remove it from registry. Then unload the software and
> rebuilt it again. Run my user database creation script and restore the
> database in different order (ie dbase3 first and then dbase1) when i did
> dbase2 it failed.(weird)

What was recorded in the server logs?

> I left it running for at least an half hour and still no response. When i
> tried to bring up task manager, it never came at all and it left it running
> for at least an hour. As usual the only option left is hit the RESET button.
>
> I might open a case with Sybase support. ( sorry to say, but i have doubt
> if it is resolvable, unless i reinstall Windows 2000 again and Sybase ASE 1
> 2.0 again)

OK. It could be a bug. The first thing I usually do is go to the
support section of Sybase's web site and read the coverletter of
the latest EBF for the versio in question to see if a bug has been
fixed. Try this and if you don't see anything obvious, then its
either hasn't been fixed (which is likely for something like this)
or its not a bug within ASE but something to do with your own
environment.

-am © 2001