Backup server (Vantage version 6.1)

Yahoo Archive
1
It worked thanks Brian!
As a final step I just had to restart the APPSERVER.

--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> You will need to change the ports in the System Agent config (under System Management/Utilities) to be appropriate for your Test database's main appserver and task agent appserver (typically 8321 and 8323 respectively).
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Christian
> Sent: Friday, January 22, 2010 4:08 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Backup server (Vantage version 6.1)
>
> Hi thanks, I used your instructions to overwrite TEST db with LIVE db (prorest).
>
> Everything seemed to go right, however no report is working.
>
> I do not get an error in the "System Monitor", they just do not come out.
>
> I've already tried:
>
> - Restarted all APPSERV's and DB
> - Changed the ODBC port # on my client
>
> Any other suggestions would be much appreciated.
>
> Have a nice weekend.
>
> --- In vantage@yahoogroups.com, Todd Caughey <caugheyt@> wrote:
> >
> > I just resotre the prior nights backup to the test DB. It (Test) has to be stopped first. I run it in a Command window but it could be a scheduled .bat file. It looks like this...(change drive, folder , etc... as needed)
> >
> > cd epicor\mfgTEST\db
> > call D:\epicor\prgs91d\bin\prorest mfgtest D:\epicor\backup\backup.1
> > It will prompt to overwrite mfgtest and then it takes about 5 minutes for our 2.5GB live DB to restore to test. After done restart the test DB with PET.
> >
> > -Todd C.
> >
> >
> > ________________________________
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of richter_clements
> > Sent: Thursday, March 19, 2009 3:11 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Backup server (Vantage version 6.1)
> >
> >
> > How do I use this to just update the test database daily (refresh it)...it's on the same physical drive in different folder....Do I have to run a backupa and restore and just procopy database from 1 folder to ther other? Does the 'live' database have to stopped first?
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Paul" <chaosavy@> wrote:
> > >
> > > VMware is indeed great. But here is what I'm doing.
> > >
> > > I bought a thousand dollar server (with everything including os license
> > > it was more like 2 thousand). I installed Vantage on it, and have daily
> > > scripts that back up the production server and populate the cheapie
> > > server.
> > >
> > >
> > > This server not only servers as a test database (refreshed daily), but
> > > also as a test of the backup process (what better way to test then to
> > > do a restore?) and as a oh crap main server is down lets limp along on
> > > this one server.
> > >
> > > Ofcourse I do backups to tape as well, and to another disk, but this
> > > way I know I'm ready for near anything.
> > >
> >
> >
> >
> >
> >
> > [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
>
2
Late last year, our Vantage Server lost its power supply. We had
redundant power supplies, but it was the controller that went out. We
were supposed to be down for a day and it ended up being a week. I had
tape backups, but installing Vantage on another Server and then copying
the database over didn't seem very feasible if we were only down a
day. As it turns out, it would have been better to copy it to another
server. I've said all this to ask this question: does anyone run
redundant servers to alleviate the down time in case the primary server
experiences a hardware failure? If so, how do you keep the secondary
database updated? Do you use a special backup program? How does it
work with Vantage licenses?
Any ideas would be appreciated.
3
We are on 5.2 and had our server fail 2 years ago. We did not have a
redundant server, but we were back up and running by the next morning
(we did work overnight though).

I am not an It person, but I know our IT person had something he called
an 'image' of the server stored elsewhere. I have no idea what this is
of how it was used.

For my part, I have batch files that run every night that copies our
database to another server. It also copies any changes reports, forms,
etc.

After he got the new server up and running within hours form Dell
support), I spent the night re-installing vantage, then just restored
the database back-up copy from the prior night, and copied over all my
'stuff' from the other server. Was not fun, but was pretty painless in
the long run.

I realize this does not answer your question about licensing, but it
seemed to work well enough and in the nearly 10 years we've been on
vantage that was the only downtime we have ever had!




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of rlunsf
Sent: Friday, February 27, 2009 3:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Backup server (Vantage version 6.1)

Late last year, our Vantage Server lost its power supply. We had
redundant power supplies, but it was the controller that went out. We
were supposed to be down for a day and it ended up being a week. I had
tape backups, but installing Vantage on another Server and then copying
the database over didn't seem very feasible if we were only down a
day. As it turns out, it would have been better to copy it to another
server. I've said all this to ask this question: does anyone run
redundant servers to alleviate the down time in case the primary server
experiences a hardware failure? If so, how do you keep the secondary
database updated? Do you use a special backup program? How does it
work with Vantage licenses?
Any ideas would be appreciated.



------------------------------------

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



<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________________________________________________________________<DIV><FONT>
4
Your situation is a perfect example of how "virtualization" can be a
huge benefit. If your server had been running as a "virtual guest"
within a host machine, then if the host-machine failed for any reason,
you could quickly deploy a new host-machine and be back up and running
within minutes (in theory). If your organization is big enough to make
the initial expense, you could actually have a configuration where you
have multiple host-machines, and if any physical host were to fail, the
system would *automatically* fail-over to another host-machine, quickly
enough that your users would likely never even know it happened! Such a
configuration requires some pretty big outlay of capital, though, and
some good admins to keep it going reliably.

Here's what I'm thinking of doing after our upgrade to v8 (which is
happening tomorrow). VMWare has a tool to make an "image" of a physical
machine (while its running) and convert it to a "virtual machine." We
make online backups of the database 3 times per day, which are kept
separate from the server on which Vantage lives. In the event of a
hardware failure, I could run the virtual-machine from the image, load
the database from the backup onto the VM, and in the worst case have
data 7:59 hours old. If I run the conversion tool on a regular basis,
it should be very easy to get a live system back online within an hour
(providing we have a host machine available).

IMHO - virtualization in a full production environment only really works
if you can separate the host machine from the device on which the VM
images are stored (which should be a fault-tolerant NAS or SAN). If the
host machine contains the storage (ie. the image-files are on a disk
internal to the host) you lose a lot of the fault-tolerance VMs can
provide. But for short-term solutions to emergency situations,
implementations like I'm considering might tide you over.

--Ari
________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of rlunsf
Sent: Friday, February 27, 2009 2:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Backup server (Vantage version 6.1)



Late last year, our Vantage Server lost its power supply. We had
redundant power supplies, but it was the controller that went out. We
were supposed to be down for a day and it ended up being a week. I had
tape backups, but installing Vantage on another Server and then copying
the database over didn't seem very feasible if we were only down a
day. As it turns out, it would have been better to copy it to another
server. I've said all this to ask this question: does anyone run
redundant servers to alleviate the down time in case the primary server
experiences a hardware failure? If so, how do you keep the secondary
database updated? Do you use a special backup program? How does it
work with Vantage licenses?
Any ideas would be appreciated.






[Non-text portions of this message have been removed]
5
VMware is indeed great. But here is what I'm doing.

I bought a thousand dollar server (with everything including os license
it was more like 2 thousand). I installed Vantage on it, and have daily
scripts that back up the production server and populate the cheapie
server.


This server not only servers as a test database (refreshed daily), but
also as a test of the backup process (what better way to test then to
do a restore?) and as a oh crap main server is down lets limp along on
this one server.

Ofcourse I do backups to tape as well, and to another disk, but this
way I know I'm ready for near anything.
6
If your question is about Licensing of Vantage/Epicor then I hope to explain
that to you now.

Epicor allows for unlimited licenses on servers, as long as you are only
using one system for production.

So you can technically have unlimited backup or testing machines.

Ned


----- Original Message -----
From: <sarah.vareschi@...>
To: <vantage@yahoogroups.com>
Sent: Friday, February 27, 2009 3:50 PM
Subject: RE: [Vantage] Backup server (Vantage version 6.1)


> We are on 5.2 and had our server fail 2 years ago. We did not have a
> redundant server, but we were back up and running by the next morning
> (we did work overnight though).
>
> I am not an It person, but I know our IT person had something he called
> an 'image' of the server stored elsewhere. I have no idea what this is
> of how it was used.
>
> For my part, I have batch files that run every night that copies our
> database to another server. It also copies any changes reports, forms,
> etc.
>
> After he got the new server up and running within hours form Dell
> support), I spent the night re-installing vantage, then just restored
> the database back-up copy from the prior night, and copied over all my
> 'stuff' from the other server. Was not fun, but was pretty painless in
> the long run.
>
> I realize this does not answer your question about licensing, but it
> seemed to work well enough and in the nearly 10 years we've been on
> vantage that was the only downtime we have ever had!
>
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of rlunsf
> Sent: Friday, February 27, 2009 3:43 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Backup server (Vantage version 6.1)
>
> Late last year, our Vantage Server lost its power supply. We had
> redundant power supplies, but it was the controller that went out. We
> were supposed to be down for a day and it ended up being a week. I had
> tape backups, but installing Vantage on another Server and then copying
> the database over didn't seem very feasible if we were only down a
> day. As it turns out, it would have been better to copy it to another
> server. I've said all this to ask this question: does anyone run
> redundant servers to alleviate the down time in case the primary server
> experiences a hardware failure? If so, how do you keep the secondary
> database updated? Do you use a special backup program? How does it
> work with Vantage licenses?
> Any ideas would be appreciated.
>
>
>
> ------------------------------------
>
> 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
>
>
>
> <DIV><font size="1.5" face="Bookman Old
> Style">__________________________________________________________________________________________________________________
>
> This email may contain material that is confidential, privileged and/or
> attorney work product for the sole use of the intended recipient. Any
> review, reliance or distribution by others or forwarding without express
> permission is strictly prohibited. If you are not the intended recipient,
> please contact the sender and delete all copies.
> __________________________________________________________________________________________________________________<DIV><FONT>
>
>
> ------------------------------------
>
> 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
>
>
>
>
7
How do I use this to just update the test database daily (refresh it)...it's on the same physical drive in different folder....Do I have to run a backupa and restore and just procopy database from 1 folder to ther other? Does the 'live' database have to stopped first?

--- In vantage@yahoogroups.com, "Paul" <chaosavy@...> wrote:
>
> VMware is indeed great. But here is what I'm doing.
>
> I bought a thousand dollar server (with everything including os license
> it was more like 2 thousand). I installed Vantage on it, and have daily
> scripts that back up the production server and populate the cheapie
> server.
>
>
> This server not only servers as a test database (refreshed daily), but
> also as a test of the backup process (what better way to test then to
> do a restore?) and as a oh crap main server is down lets limp along on
> this one server.
>
> Ofcourse I do backups to tape as well, and to another disk, but this
> way I know I'm ready for near anything.
>
8
I just resotre the prior nights backup to the test DB. It (Test) has to be stopped first. I run it in a Command window but it could be a scheduled .bat file. It looks like this...(change drive, folder , etc... as needed)

cd epicor\mfgTEST\db
call D:\epicor\prgs91d\bin\prorest mfgtest D:\epicor\backup\backup.1
It will prompt to overwrite mfgtest and then it takes about 5 minutes for our 2.5GB live DB to restore to test. After done restart the test DB with PET.

-Todd C.


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of richter_clements
Sent: Thursday, March 19, 2009 3:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Backup server (Vantage version 6.1)


How do I use this to just update the test database daily (refresh it)...it's on the same physical drive in different folder....Do I have to run a backupa and restore and just procopy database from 1 folder to ther other? Does the 'live' database have to stopped first?

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Paul" <chaosavy@...> wrote:
>
> VMware is indeed great. But here is what I'm doing.
>
> I bought a thousand dollar server (with everything including os license
> it was more like 2 thousand). I installed Vantage on it, and have daily
> scripts that back up the production server and populate the cheapie
> server.
>
>
> This server not only servers as a test database (refreshed daily), but
> also as a test of the backup process (what better way to test then to
> do a restore?) and as a oh crap main server is down lets limp along on
> this one server.
>
> Ofcourse I do backups to tape as well, and to another disk, but this
> way I know I'm ready for near anything.
>





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




________________________________
From: Todd Caughey <caugheyt@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thursday, March 19, 2009 5:01:56 PM
Subject: RE: [Vantage] Re: Backup server (Vantage version 6.1)


I just resotre the prior nights backup to the test DB. It (Test) has to be stopped first. I run it in a Command window but it could be a scheduled .bat file. It looks like this...(change drive, folder , etc... as needed)

cd epicor\mfgTEST\ db
call D:\epicor\prgs91d\ bin\prorest mfgtest D:\epicor\backup\ backup.1
It will prompt to overwrite mfgtest and then it takes about 5 minutes for our 2.5GB live DB to restore to test. After done restart the test DB with PET.

-Todd C.

____________ _________ _________ __
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of richter_clements
Sent: Thursday, March 19, 2009 3:11 PM
To: vantage@yahoogroups ..com
Subject: [Vantage] Re: Backup server (Vantage version 6.1)

How do I use this to just update the test database daily (refresh it)...it's on the same physical drive in different folder....Do I have to run a backupa and restore and just procopy database from 1 folder to ther other? Does the 'live' database have to stopped first?

--- In vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>, "Paul" <chaosavy@.. .> wrote:
>
> VMware is indeed great. But here is what I'm doing.
>
> I bought a thousand dollar server (with everything including os license
> it was more like 2 thousand). I installed Vantage on it, and have daily
> scripts that back up the production server and populate the cheapie
> server.
>
>
> This server not only servers as a test database (refreshed daily), but
> also as a test of the backup process (what better way to test then to
> do a restore?) and as a oh crap main server is down lets limp along on
> this one server.
>
> Ofcourse I do backups to tape as well, and to another disk, but this
> way I know I'm ready for near anything.
>

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



Messages in this topic (7) Reply (via web post) | Start a new topic
Messages | Files | Photos | Database | Members
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/.%c2%a0
(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
MARKETPLACE

________________________________
From kitchen basics to easy recipes - join the Group from Kraft Foods

________________________________
Are you Einstein smart? Take our Fun Quiz and get your IQ score today at Quizyou.net.

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Recent Activity
* Â 2
New FilesVisit Your Group
Find helpful tips
for Moderators
on the Yahoo!
Groups team blog.
Yahoo! Groups
Do More For Dogs Group
Join a group of dog owners
who do more.
Yahoo! Groups
Auto Enthusiast Zone
Auto Enthusiast Zone
Car groups and more!
.

__,_.._,___




[Non-text portions of this message have been removed]
10
Hi thanks, I used your instructions to overwrite TEST db with LIVE db (prorest).

Everything seemed to go right, however no report is working.

I do not get an error in the "System Monitor", they just do not come out.

I've already tried:

- Restarted all APPSERV's and DB
- Changed the ODBC port # on my client

Any other suggestions would be much appreciated.

Have a nice weekend.

--- In vantage@yahoogroups.com, Todd Caughey <caugheyt@...> wrote:
>
> I just resotre the prior nights backup to the test DB. It (Test) has to be stopped first. I run it in a Command window but it could be a scheduled .bat file. It looks like this...(change drive, folder , etc... as needed)
>
> cd epicor\mfgTEST\db
> call D:\epicor\prgs91d\bin\prorest mfgtest D:\epicor\backup\backup.1
> It will prompt to overwrite mfgtest and then it takes about 5 minutes for our 2.5GB live DB to restore to test. After done restart the test DB with PET.
>
> -Todd C.
>
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of richter_clements
> Sent: Thursday, March 19, 2009 3:11 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Backup server (Vantage version 6.1)
>
>
> How do I use this to just update the test database daily (refresh it)...it's on the same physical drive in different folder....Do I have to run a backupa and restore and just procopy database from 1 folder to ther other? Does the 'live' database have to stopped first?
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Paul" <chaosavy@> wrote:
> >
> > VMware is indeed great. But here is what I'm doing.
> >
> > I bought a thousand dollar server (with everything including os license
> > it was more like 2 thousand). I installed Vantage on it, and have daily
> > scripts that back up the production server and populate the cheapie
> > server.
> >
> >
> > This server not only servers as a test database (refreshed daily), but
> > also as a test of the backup process (what better way to test then to
> > do a restore?) and as a oh crap main server is down lets limp along on
> > this one server.
> >
> > Ofcourse I do backups to tape as well, and to another disk, but this
> > way I know I'm ready for near anything.
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
11
You will need to change the ports in the System Agent config (under System Management/Utilities) to be appropriate for your Test database's main appserver and task agent appserver (typically 8321 and 8323 respectively).

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Christian
Sent: Friday, January 22, 2010 4:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Backup server (Vantage version 6.1)

Hi thanks, I used your instructions to overwrite TEST db with LIVE db (prorest).

Everything seemed to go right, however no report is working.

I do not get an error in the "System Monitor", they just do not come out.

I've already tried:

- Restarted all APPSERV's and DB
- Changed the ODBC port # on my client

Any other suggestions would be much appreciated.

Have a nice weekend.

--- In vantage@yahoogroups.com, Todd Caughey <caugheyt@...> wrote:
>
> I just resotre the prior nights backup to the test DB. It (Test) has to be stopped first. I run it in a Command window but it could be a scheduled .bat file. It looks like this...(change drive, folder , etc... as needed)
>
> cd epicor\mfgTEST\db
> call D:\epicor\prgs91d\bin\prorest mfgtest D:\epicor\backup\backup.1
> It will prompt to overwrite mfgtest and then it takes about 5 minutes for our 2.5GB live DB to restore to test. After done restart the test DB with PET.
>
> -Todd C.
>
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of richter_clements
> Sent: Thursday, March 19, 2009 3:11 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Backup server (Vantage version 6.1)
>
>
> How do I use this to just update the test database daily (refresh it)...it's on the same physical drive in different folder....Do I have to run a backupa and restore and just procopy database from 1 folder to ther other? Does the 'live' database have to stopped first?
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Paul" <chaosavy@> wrote:
> >
> > VMware is indeed great. But here is what I'm doing.
> >
> > I bought a thousand dollar server (with everything including os license
> > it was more like 2 thousand). I installed Vantage on it, and have daily
> > scripts that back up the production server and populate the cheapie
> > server.
> >
> >
> > This server not only servers as a test database (refreshed daily), but
> > also as a test of the backup process (what better way to test then to
> > do a restore?) and as a oh crap main server is down lets limp along on
> > this one server.
> >
> > Ofcourse I do backups to tape as well, and to another disk, but this
> > way I know I'm ready for near anything.
> >
>
>
>
>
>
> [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