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.

more data and log problems

3 posts in Backup and Recovery Last posting was on 2001-03-12 17:50:36.0Z
jbuhl Posted on 2001-03-09 02:51:19.0Z
From: "jbuhl" <jbuhl@peerdigital>
Subject: more data and log problems
Date: Thu, 8 Mar 2001 19:51:19 -0700
Lines: 15
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: <7Z5JbZEqAHA.199@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
NNTP-Posting-Host: 12.41.162.201
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:436
Article PK: 1060983

Hello,

It does not look like my other post made it so im doing another one.

Is it true that if I have a 2GB database and I create a 20GB database with
the same device order with only bigger devices that when I load the 2GB db
into the 20GB db that it will mix log and data devices every time?

Thanks
Joe Buhl


Anthony Mandic <amandic Posted on 2001-03-09 05:48:55.0Z
Date: Fri, 09 Mar 2001 16:48:55 +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: more data and log problems
References: <7Z5JbZEqAHA.199@forums.sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <MqRbr7FqAHA.80@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 22
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:435
Article PK: 1061009


jbuhl wrote:

> It does not look like my other post made it so im doing another one.

Which other one? The one I replied to?

> Is it true that if I have a 2GB database and I create a 20GB database with
> the same device order with only bigger devices that when I load the 2GB db
> into the 20GB db that it will mix log and data devices every time?

You only need to ensure that the first 2GB of the 20GB db matches
the original layout in the dump from the 2GB db. After that, you
can make the layout whichever way you want (more or less). So, from
what you are saying, you'll see fragmentation since the layouts
(and their exact sizes) for the original 2GB doesn't match in the
new 20GB db. The new devices can be bigger, but the device fragments
(that is, the allocations on those devices) haveto be the same.

-am © 2001


jbuhl Posted on 2001-03-12 17:50:36.0Z
From: "jbuhl" <jbuhl@peerdigital>
References: <7Z5JbZEqAHA.199@forums.sybase.com> <MqRbr7FqAHA.80@forums.sybase.com>
Subject: Re: more data and log problems
Date: Mon, 12 Mar 2001 10:50:36 -0700
Lines: 19
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: <fp3TA#xqAHA.301@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
NNTP-Posting-Host: 12.41.162.201
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:416
Article PK: 1060933


"Anthony Mandic" <amandic@*t.com.au> wrote in message
news:MqRbr7FqAHA.80@forums.sybase.com...
> jbuhl wrote:
>
> > It does not look like my other post made it so im doing another one.
>
> Which other one? The one I replied to?

Yes. Actually it looks like the post did make it but they were regarding
the same thing.

Thats good information about the device allocation though and will give it a
try. The other thing I thought of was makiing them the same size, load the
data in, alter the db to 20gb and then dumping that out. Then im set.

Joe