Having DB on a Different Drive

Yahoo Archive
1
Hi Troy,

Do you have a suggestion solution to fix the database > 2GB? Our
database is about 2 GB.

Thanks,

Nam

--- In vantage@yahoogroups.com, "Troy Funte" <tfunte@e...> wrote:
> Dina,
> You might want to call support on this one to walk you through
it, but... here's what I would do.
> The Vantage.st file is the pointer for all of your database files.
Mine looks like this...
>
> #
> b .\vantage.b1
> #
> d "Schema Area":6,32 .\vantage.d1
>
> Use Prorest to unpack a Vantage backup to the new location for your
database. This causes the Vantage.st file to correctly relate to
your current path. Now open your vantage.st file in Notepad. To
move the .b1 file, you would add the NEW path in front of the
\vantage.b1 line, replacing the period there. For instance: b
d:\epic51\vantagebi\vantage.b1
> Then add the path to the .d1 file as well (which may be in another
location): d "Schema Area":6,32 c:\epic51\vantagedb\vantage.d1
>
> We don't use After Image, but you could probably do the same thing
with that line in your vantage.st file. (Oh, by the way, make a
backup of your current vantage.st file just in case).
>
> Now copy your Vantage.b1 file and vantage.d1 file (and your after
image) to the place you specified in the vantage.st.
>
> Go to a command prompt and get to the directory where your new
vantage.st file is located. Type DLC=C:\EPIC51\PROGRESS. Then type
c:\epic51\progress\bin\PROSTRCT REPAIR VANTAGE.
>
> This will set your Vantage.st file in the correct format and make
sure your files are in the right place. If you have pointed your
progress explorer to the same directory where your Vantage.st file
is, then everything should fly.
>
> NOTE: This is all from memory, so I would still encourage you to
work with Epicor support in this process, unless you're confident
with the trial and error approach. If you're working in a test
environment as I usually do, trial and error works fine. The above
method may have left out a step or two that I haven't thought of on
spur of the moment.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Dina Hieber
> To: vantage@yahoogroups.com
> Sent: Thursday, November 21, 2002 9:17 AM
> Subject: [Vantage] Having DB on a Different Drive
>
>
> Hello Everyone,
>
>
>
> Well I am making the big jump to 5.2 onto our new server. But
before I
> do this I need the expertise of the group. Because of our raid
> stripping/mirroring I want to put the database on a different
drive. I
> thought I read something before from the group that said how to
do this.
> But I can not locate the email. Does anyone have a copy of this
or can
> tell me what I need to do. Also, I thought I read where the
After and
> Before Image files going on different drives would optimize the
> performance.
>
>
>
> Any recommendations/help would be greatly appreciated.
>
>
>
>
>
> Dina
>
>
> [Non-text portions of this message have been removed]
2
Hello Everyone,



Well I am making the big jump to 5.2 onto our new server. But before I
do this I need the expertise of the group. Because of our raid
stripping/mirroring I want to put the database on a different drive. I
thought I read something before from the group that said how to do this.
But I can not locate the email. Does anyone have a copy of this or can
tell me what I need to do. Also, I thought I read where the After and
Before Image files going on different drives would optimize the
performance.



Any recommendations/help would be greatly appreciated.





Dina





[Non-text portions of this message have been removed]
3
Dina,
I think what your looking for is in the answerbook document #:
546MPS called "Securing files in Vantage 4 and 3 using NT security". It
says to do a procopy of the db to the new location and then modify the
properties of the DB in progress explorer to point to the new location. I
do have my database set up this way and I also have my AI and BI files each
on separate disks. I also have each disk set up on a different channel on
my SCSI card.

-----Original Message-----
From: Dina Hieber [mailto:dhieber@...]
Sent: Thursday, November 21, 2002 9:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Having DB on a Different Drive


Hello Everyone,



Well I am making the big jump to 5.2 onto our new server. But before I
do this I need the expertise of the group. Because of our raid
stripping/mirroring I want to put the database on a different drive. I
thought I read something before from the group that said how to do this.
But I can not locate the email. Does anyone have a copy of this or can
tell me what I need to do. Also, I thought I read where the After and
Before Image files going on different drives would optimize the
performance.



Any recommendations/help would be greatly appreciated.





Dina





[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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



[Non-text portions of this message have been removed]
4
Dina,
You might want to call support on this one to walk you through it, but... here's what I would do.
The Vantage.st file is the pointer for all of your database files. Mine looks like this...

#
b .\vantage.b1
#
d "Schema Area":6,32 .\vantage.d1

Use Prorest to unpack a Vantage backup to the new location for your database. This causes the Vantage.st file to correctly relate to your current path. Now open your vantage.st file in Notepad. To move the .b1 file, you would add the NEW path in front of the \vantage.b1 line, replacing the period there. For instance: b d:\epic51\vantagebi\vantage.b1
Then add the path to the .d1 file as well (which may be in another location): d "Schema Area":6,32 c:\epic51\vantagedb\vantage.d1

We don't use After Image, but you could probably do the same thing with that line in your vantage.st file. (Oh, by the way, make a backup of your current vantage.st file just in case).

Now copy your Vantage.b1 file and vantage.d1 file (and your after image) to the place you specified in the vantage.st.

Go to a command prompt and get to the directory where your new vantage.st file is located. Type DLC=C:\EPIC51\PROGRESS. Then type c:\epic51\progress\bin\PROSTRCT REPAIR VANTAGE.

This will set your Vantage.st file in the correct format and make sure your files are in the right place. If you have pointed your progress explorer to the same directory where your Vantage.st file is, then everything should fly.

NOTE: This is all from memory, so I would still encourage you to work with Epicor support in this process, unless you're confident with the trial and error approach. If you're working in a test environment as I usually do, trial and error works fine. The above method may have left out a step or two that I haven't thought of on spur of the moment.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Dina Hieber
To: vantage@yahoogroups.com
Sent: Thursday, November 21, 2002 9:17 AM
Subject: [Vantage] Having DB on a Different Drive


Hello Everyone,



Well I am making the big jump to 5.2 onto our new server. But before I
do this I need the expertise of the group. Because of our raid
stripping/mirroring I want to put the database on a different drive. I
thought I read something before from the group that said how to do this.
But I can not locate the email. Does anyone have a copy of this or can
tell me what I need to do. Also, I thought I read where the After and
Before Image files going on different drives would optimize the
performance.



Any recommendations/help would be greatly appreciated.





Dina


[Non-text portions of this message have been removed]