[6.1] Test Database on USB Disk

Yahoo Archive
1
Thanks Cliff and Chris. This will be the hot project for tomorrow and I didn't want to spend all day struggling with something impossible. Goal is to have a snapshot of month-end that we can restore over and over and play with having costs hit the G/L.
-Todd

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Cliff Drumeller
Sent: Thursday, March 30, 2006 4:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1] Test Database on USB Disk


Todd
The DB can be on any drive attached to the machine. Yes, if you
use the online backup it must save to the same drive. I would say set up
a training db. Use Procopy to move it to the new USB drive. That will do
all of your editing for you and set it up in PET. Then use a Prorest to
pull your full db in replacing the training db on the USB . Might be a
little convoluted but your editing will be minimal, The db path in PET.

Cliff

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Thursday, March 30, 2006 2:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Test Database on USB Disk

I need to setup a test database for testing some G/L settings. It's
been a long time since we had a sandbox to play in. Since then we have
become disk space constrained on the server. I have added a 250GB USB
drive and would like to put the test database there. But I have this
nagging feeling I heard somewhere that backing up or restoring to a
drive other than where the original DB is has issues. Is this true? If
not and I can proceed are there any gotchas involved or handy tips? Our
regular DB is in the usual MFGSYS61 folder tree. I was thinking to make
a new folder for the test DB and then change new versions the related
.mfg and .ini files as needed to point there.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[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
Yahoo! Groups Links









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



_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]
2
I need to setup a test database for testing some G/L settings. It's been a long time since we had a sandbox to play in. Since then we have become disk space constrained on the server. I have added a 250GB USB drive and would like to put the test database there. But I have this nagging feeling I heard somewhere that backing up or restoring to a drive other than where the original DB is has issues. Is this true? If not and I can proceed are there any gotchas involved or handy tips? Our regular DB is in the usual MFGSYS61 folder tree. I was thinking to make a new folder for the test DB and then change new versions the related .mfg and .ini files as needed to point there.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]
3
When restoring a backup into a location different from the source:

Start\Programs\your-progress\proenv
prompt
cd your-db-directory
prostrct repair mfgsys
exit

----- Original Message -----
From: "Todd Caughey" <caugheyt@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, March 30, 2006 2:02 PM
Subject: [Vantage] [6.1] Test Database on USB Disk


I need to setup a test database for testing some G/L settings. It's been a long time since we had a sandbox to play in. Since then we have become disk space constrained on the server. I have added a 250GB USB drive and would like to put the test database there. But I have this nagging feeling I heard somewhere that backing up or restoring to a drive other than where the original DB is has issues. Is this true? If not and I can proceed are there any gotchas involved or handy tips? Our regular DB is in the usual MFGSYS61 folder tree. I was thinking to make a new folder for the test DB and then change new versions the related .mfg and .ini files as needed to point there.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[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
Yahoo! Groups Links








[Non-text portions of this message have been removed]
4
Todd
The DB can be on any drive attached to the machine. Yes, if you
use the online backup it must save to the same drive. I would say set up
a training db. Use Procopy to move it to the new USB drive. That will do
all of your editing for you and set it up in PET. Then use a Prorest to
pull your full db in replacing the training db on the USB . Might be a
little convoluted but your editing will be minimal, The db path in PET.

Cliff

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Thursday, March 30, 2006 2:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Test Database on USB Disk

I need to setup a test database for testing some G/L settings. It's
been a long time since we had a sandbox to play in. Since then we have
become disk space constrained on the server. I have added a 250GB USB
drive and would like to put the test database there. But I have this
nagging feeling I heard somewhere that backing up or restoring to a
drive other than where the original DB is has issues. Is this true? If
not and I can proceed are there any gotchas involved or handy tips? Our
regular DB is in the usual MFGSYS61 folder tree. I was thinking to make
a new folder for the test DB and then change new versions the related
.mfg and .ini files as needed to point there.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[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
Yahoo! Groups Links