Just to follow this up, it's best to enter into the PROENV command prompt
before running this, as well as having the DB stopped.
then type prompt to get to a standard prompt like: e:\epicor\oe101b_wrk>
then browse to your DB location via DOS CD commands
then run the command proutil mfgsys -C truncate bi
where mfgsys is the file name of your DB, assuming you never changed it it
will be mfgsys, no file extentions are needed.
You can work this into a batch file if you want to, but be sure you are
aware these are basically transaction logs you are truncating.
before running this, as well as having the DB stopped.
then type prompt to get to a standard prompt like: e:\epicor\oe101b_wrk>
then browse to your DB location via DOS CD commands
then run the command proutil mfgsys -C truncate bi
where mfgsys is the file name of your DB, assuming you never changed it it
will be mfgsys, no file extentions are needed.
You can work this into a batch file if you want to, but be sure you are
aware these are basically transaction logs you are truncating.
----- Original Message -----
From: "Blake Clemens" <blake.clemens@...>
To: <vantage@yahoogroups.com>
Sent: Friday, July 24, 2009 10:00 AM
Subject: RE: [Vantage] Large Backup/B1 file
> Yep, truncate it.
>
>
>
> \\server\epicor\mfgsys803\db\proutil mfgsys -C truncate bi
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Ken Williams
> Sent: Friday, July 24, 2009 9:51 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Large Backup/B1 file
>
>
>
>
>
> I'm not sure what happened, but our backup file recently went from about
> 1.2gb to 2.1gb. When I look, it appears the .b1 file has grown from a
> ~100mb to 900mb.
>
> Any suggestions on how to resolve this? Is this done by the truncate bi
> command I have floating around somewhere?
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>