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.

Huge transaction log

2 posts in Windows NT Last posting was on 1997-08-04 22:41:19.0Z
Earl Brown Posted on 1997-08-04 16:51:02.0Z
Message-ID: <33E60876.8A5B5DE9@cdsinc.net>
Date: Mon, 04 Aug 1997 10:51:02 -0600
From: Earl Brown <ebrown@cdsinc.net>
X-Mailer: Mozilla 4.01 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Huge transaction log
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 10
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5581
Article PK: 1081658

After a month and a half of building my DB application, I'm ready to
build the database clean. I'd rather not do a re-create until the
product is finalized, but looking at my transaction log, it shows to
take up 28 megs of a 50 meg database.

How can I free up all of this space? I don't want to keep any of the
log, since I'm recreating the database...

Thanks
Earl


Bret Halford Posted on 1997-08-04 22:41:19.0Z
Message-ID: <33E65A8E.41C67EA6@sybase.com>
Date: Mon, 04 Aug 1997 15:41:19 -0700
From: Bret Halford <bret@sybase.com>
Organization: Customer Service & Support
X-Mailer: Mozilla 3.0 (X11; U; SunOS 4.1.3_U1 sun4m)
MIME-Version: 1.0
To: Earl Brown <ebrown@cdsinc.net>
Subject: Re: Huge transaction log
References: <33E60876.8A5B5DE9@cdsinc.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 29
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5580
Article PK: 1081657

"dump tran <dbname> with truncate_only" perhaps?

My personal opinion is that if you are doing things "the right way",
you should currently have a script that will recreate all the objects
in your database. Dropping the database and recreating it with
the script would then be a trivial task.

Earl Brown wrote:
>
> After a month and a half of building my DB application, I'm ready to
> build the database clean. I'd rather not do a re-create until the
> product is finalized, but looking at my transaction log, it shows to
> take up 28 megs of a 50 meg database.
>
> How can I free up all of this space? I don't want to keep any of the
> log, since I'm recreating the database...
>
> Thanks
> Earl

---------------------------------------------------------------------
| Bret Halford Imagine my disappointment __|
| Sybase Technical Support in learning the true nature __|
| 6400 S. Fiddlers Green Circle of rec.humor.oracle... __|
| Englewood, CO 80111-4954 USA |
============================================================