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.

load database with different size

2 posts in Backup and Recovery Last posting was on 2001-03-14 11:42:38.0Z
wee_min Posted on 2001-03-14 03:06:04.0Z
From: wee_min
Date: Tue, 13 Mar 2001 22:06:04 -0500
Newsgroups: sybase.public.sqlserver.backup+recovery
Subject: load database with different size
Message-ID: <463E408FBBC3F72B0011091E85256A0F.0011092C85256A0F@webforums>
Lines: 12
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:405
Article PK: 1060924

Hi,

I would like to restore a database, with the total log and data size of
3GB, from a dump which actuall database size is about 200MB but the total
size for the log and data is 4GB. When I execute load database command,
system prompt me that I have to have 4GB data space to perform the
restoration. Any help to perform the restore. Thank

Regards,

wee min
weemin.goh@aigsi.com


Anthony Mandic <amandic Posted on 2001-03-14 11:42:38.0Z
Date: Wed, 14 Mar 2001 21:42:38 +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: load database with different size
References: <463E408FBBC3F72B0011091E85256A0F.0011092C85256A0F@webforums>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <t2S6j8HrAHA.302@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 14
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:402
Article PK: 1060920


wee_min wrote:

> I would like to restore a database, with the total log and data size of
> 3GB, from a dump which actuall database size is about 200MB but the total
> size for the log and data is 4GB. When I execute load database command,
> system prompt me that I have to have 4GB data space to perform the
> restoration. Any help to perform the restore. Thank

The load database target has to be at least the same size.
So you should make it 1GB larger. Basically, you can't
shrink a database thru dump and load.

-am © 2001