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.

Problems Loading a database using Sybase 11

2 posts in Windows NT Last posting was on 2000-01-10 20:46:07.0Z
Wayne Posted on 2000-01-10 18:21:09.0Z
Reply-To: "Wayne" <Wayne@Quodata.com>
From: "Wayne" <Wayne@Quodata.com>
Subject: Problems Loading a database using Sybase 11
Date: Mon, 10 Jan 2000 13:21:09 -0500
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <KVy0hf5W$GA.177@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 208.216.22.229
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2721
Article PK: 1090193

I'm having problems when I try to load a database which is larger in size
than the original.

For example:


I have a dump which is coming from a database which is 190
megs in size.

150 data, and 40 log


When I try to load this dump into a much larger database,
the devices get screwed up.

They start off as (2000 data, and 80
log) in megs

After the load I get:

1810 data,150 data, 40 log, and 80 log

It breaks up my 2000 megs data into what
it wants.


Has anyone else ran into this problem???

Is there a fix???? Please don't tell me that all I need to
do is upgrade.


Jason Froebe Posted on 2000-01-10 20:46:07.0Z
Message-ID: <387A450F.3FC3952D@sybase.com>
Date: Mon, 10 Jan 2000 14:46:07 -0600
From: Jason Froebe <jfroebe@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Wayne <Wayne@Quodata.com>
Subject: Re: Problems Loading a database using Sybase 11
References: <KVy0hf5W$GA.177@forums.sybase.com>
Content-Type: multipart/mixed; boundary="------------56121020B87F62775B250EEC"
Newsgroups: sybase.public.sqlserver.nt
Lines: 45
NNTP-Posting-Host: jfroebe-desktop.sybase.com 157.133.46.52
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2720
Article PK: 1090194


Wayne wrote:

> I'm having problems when I try to load a database which is larger in size
> than the original.
>
> For example:
>
> I have a dump which is coming from a database which is 190
> megs in size.
>
> 150 data, and 40 log
>
> When I try to load this dump into a much larger database,
> the devices get screwed up.
>
> They start off as (2000 data, and 80
> log) in megs
>
> After the load I get:
>
> 1810 data,150 data, 40 log, and 80 log
>
> It breaks up my 2000 megs data into what
> it wants.
>
> Has anyone else ran into this problem???
>
> Is there a fix???? Please don't tell me that all I need to
> do is upgrade.

Hi Wayne,

Take a look at "Segment Remapping with load database When Moving a Database"
http://techinfo.sybase.com/css/techinfo.nsf/DocID/ID=1324

Jason


Download VCard jfroebe.vcf