DB Backup Blank Title 57363

Yahoo Archive
1
From your example I am assuming that you are running version 6.1. If you are using the batch file that came from Epicor/Progress, then all the files you need to restore your database have been backed up. The batch file uses the Progress utility to make a copy of your database...the file with the .1 extension is created. You would then use the Progress utility PROREST to restore your database using that file. I've restored from backup many times and this process is pretty solid.

Hope this helps,

Claudia Stone
Aspacia Systems Inc
866-566-9600

cstone@...
www.aspacia.com

This email, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this email, you are hereby notified that any dissemination, distribution or copying of this email, and any attachments thereto, is strictly prohibited. If you have received this email in error, please immediately notify me by telephone and permanently delete the original and any copy of any email and any printout thereof.


[Non-text portions of this message have been removed]
2
Hi All,

I have been backing up our servers on a daily basis, but I need to
know that I have Vantage backed up properly. A batch file runs every
night to backup the database to a separate file.

That file is called backup61.1 (a .1 file). It is the full size of
our database. This file is then being backed up on the backup tapes.
I don't back up several other files because Veritas states that they
are in use.

In case of a real emergency, will I only need that main db backup file
to get up and running? Or are there other files I should be backing
up as well.

Thanks in advance!
Ben
3
Ben,



Typically, you will need to get the entire contents of the mfgsys
directory - minus the DB folder because those files are in use.



To restore completely, you will need:



CD or DVDs for Progress and Vantage

Backup tape.



Make a vanilla install of Progress, Progress SP, and Vantage 6.1 to set
all the registry values etc - it is recommended that you make this the
same path to eliminate any issues that occur. Next, rename the vanilla
install MFGSYS61 directory (note you may not want to remove this just
yet). Insert backup tape and restore the mfgsys61 directory. Finally,
restore your database from the tape to a temporary directory. Run the
prorest command to create the database and the necessary files.



Start the databases and this should be all you need to do.



Thanks,



Jason Claggett

Microsoft Small Business Specialist

MCP #3856159

2W Technologies, LLC

317.578.2393

jason@...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bbelzer42
Sent: Tuesday, June 05, 2007 7:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] DB Backup



Hi All,

I have been backing up our servers on a daily basis, but I need to
know that I have Vantage backed up properly. A batch file runs every
night to backup the database to a separate file.

That file is called backup61.1 (a .1 file). It is the full size of
our database. This file is then being backed up on the backup tapes.
I don't back up several other files because Veritas states that they
are in use.

In case of a real emergency, will I only need that main db backup file
to get up and running? Or are there other files I should be backing
up as well.

Thanks in advance!
Ben





[Non-text portions of this message have been removed]
4
I bought a IBM M Pro workstation with 64 bit XP pro on it.
The vanatge client will not install has anyone else had this problem?


Regards,





Mark Howard
Financial Controller
Jaws Buckets & Attachments
Ph- 07-32777499
10 Willingdon st
Archerfield 4108


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jason Claggett
Sent: Wednesday, 6 June 2007 12:58 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] DB Backup



Ben,

Typically, you will need to get the entire contents of the mfgsys
directory - minus the DB folder because those files are in use.

To restore completely, you will need:

CD or DVDs for Progress and Vantage

Backup tape.

Make a vanilla install of Progress, Progress SP, and Vantage 6.1 to set
all the registry values etc - it is recommended that you make this the
same path to eliminate any issues that occur. Next, rename the vanilla
install MFGSYS61 directory (note you may not want to remove this just
yet). Insert backup tape and restore the mfgsys61 directory. Finally,
restore your database from the tape to a temporary directory. Run the
prorest command to create the database and the necessary files.

Start the databases and this should be all you need to do.

Thanks,

Jason Claggett

Microsoft Small Business Specialist

MCP #3856159

2W Technologies, LLC

317.578.2393

jason@... <mailto:jason%402wtech.com>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of bbelzer42
Sent: Tuesday, June 05, 2007 7:18 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] DB Backup

Hi All,

I have been backing up our servers on a daily basis, but I need to
know that I have Vantage backed up properly. A batch file runs every
night to backup the database to a separate file.

That file is called backup61.1 (a .1 file). It is the full size of
our database. This file is then being backed up on the backup tapes.
I don't back up several other files because Veritas states that they
are in use.

In case of a real emergency, will I only need that main db backup file
to get up and running? Or are there other files I should be backing
up as well.

Thanks in advance!
Ben

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






[Non-text portions of this message have been removed]
5
Best bet if you can't get it working. Install Virtual PC and run the
32-bit XP version...should allow you to work.



Thanks,



Jason Claggett

Microsoft Small Business Specialist

MCP #3856159

2W Technologies, LLC

317.578.2393

jason@...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Howard
Sent: Wednesday, June 06, 2007 2:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 64bit install on Version 6



I bought a IBM M Pro workstation with 64 bit XP pro on it.
The vanatge client will not install has anyone else had this problem?


Regards,

Mark Howard
Financial Controller
Jaws Buckets & Attachments
Ph- 07-32777499
10 Willingdon st
Archerfield 4108


________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Jason Claggett
Sent: Wednesday, 6 June 2007 12:58 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] DB Backup

Ben,

Typically, you will need to get the entire contents of the mfgsys
directory - minus the DB folder because those files are in use.

To restore completely, you will need:

CD or DVDs for Progress and Vantage

Backup tape.

Make a vanilla install of Progress, Progress SP, and Vantage 6.1 to set
all the registry values etc - it is recommended that you make this the
same path to eliminate any issues that occur. Next, rename the vanilla
install MFGSYS61 directory (note you may not want to remove this just
yet). Insert backup tape and restore the mfgsys61 directory. Finally,
restore your database from the tape to a temporary directory. Run the
prorest command to create the database and the necessary files.

Start the databases and this should be all you need to do.

Thanks,

Jason Claggett

Microsoft Small Business Specialist

MCP #3856159

2W Technologies, LLC

317.578.2393

jason@... <mailto:jason%402wtech.com>
<mailto:jason%402wtech.com>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of bbelzer42
Sent: Tuesday, June 05, 2007 7:18 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] DB Backup

Hi All,

I have been backing up our servers on a daily basis, but I need to
know that I have Vantage backed up properly. A batch file runs every
night to backup the database to a separate file.

That file is called backup61.1 (a .1 file). It is the full size of
our database. This file is then being backed up on the backup tapes.
I don't back up several other files because Veritas states that they
are in use.

In case of a real emergency, will I only need that main db backup file
to get up and running? Or are there other files I should be backing
up as well.

Thanks in advance!
Ben

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

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





[Non-text portions of this message have been removed]
6
The progress utility Probkup will generate one backup file if that is
what you are using. This is the file that Veritas should be backing
up.



If you do not have a test database, I would create one and restore the
backup to test on a regular schedule (Weekly, Monthly, Quarterly?).

The Progress utility Prorest will restore the backup file to the Test
database. Go into the test database do some inquiries and run some
reports.



This is the best way to validate your backup file that I know of. It
keeps someone up to date on the restore procedure and it also gives you
a test bed

with up to date data to experiment on.



I use Window CMD (DOS bat) files for the backup and the restore routines
so they are always consistent.



Hope this helps,



Dale



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bbelzer42
Sent: Tuesday, June 05, 2007 6:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] DB Backup



Hi All,

I have been backing up our servers on a daily basis, but I need to
know that I have Vantage backed up properly. A batch file runs every
night to backup the database to a separate file.

That file is called backup61.1 (a .1 file). It is the full size of
our database. This file is then being backed up on the backup tapes.
I don't back up several other files because Veritas states that they
are in use.

In case of a real emergency, will I only need that main db backup file
to get up and running? Or are there other files I should be backing
up as well.

Thanks in advance!
Ben




########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


[Non-text portions of this message have been removed]
7
I do the same. Here is my batch file to restore the live database to my
test database:

c:
cd c:\epicor\test61\db
c:\epicor\prgs91d\bin\prorest mfgsys c:\backup\backup.1

After I verify it completed successfully, I run the following batch file
to allow the database to run in the new location:

c:
cd c:\epicor\test61\db
c:\epicor\prgs91d\bin\prostrct repair mfgsys

Butch

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dale Schuerman
Sent: Wednesday, June 06, 2007 8:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] DB Backup



The progress utility Probkup will generate one backup file if that is
what you are using. This is the file that Veritas should be backing
up.

If you do not have a test database, I would create one and restore the
backup to test on a regular schedule (Weekly, Monthly, Quarterly?).

The Progress utility Prorest will restore the backup file to the Test
database. Go into the test database do some inquiries and run some
reports.

This is the best way to validate your backup file that I know of. It
keeps someone up to date on the restore procedure and it also gives you
a test bed

with up to date data to experiment on.

I use Window CMD (DOS bat) files for the backup and the restore routines
so they are always consistent.

Hope this helps,

Dale

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of bbelzer42
Sent: Tuesday, June 05, 2007 6:18 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] DB Backup

Hi All,

I have been backing up our servers on a daily basis, but I need to
know that I have Vantage backed up properly. A batch file runs every
night to backup the database to a separate file.

That file is called backup61.1 (a .1 file). It is the full size of
our database. This file is then being backed up on the backup tapes.
I don't back up several other files because Veritas states that they
are in use.

In case of a real emergency, will I only need that main db backup file
to get up and running? Or are there other files I should be backing
up as well.

Thanks in advance!
Ben

########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com <http://www.ramsys.com>

########################################################################

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






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

I'm a new customer, just purchased back in Dec 2006. My orginal server that I bought had the 64-bit of the windows 2003. After I bought it, I had to return it. I was told that the 64-bit version of Windows Server was not supported. I never researched it any further, but it might be the same for the Client side.

Installing a 32-bit VM of Windows might be the only option.

Joe



----- Original Message ----
From: Mark Howard <mhoward@...>
To: vantage@yahoogroups.com
Sent: Wednesday, June 6, 2007 1:40:02 AM
Subject: [Vantage] Vantage 64bit install on Version 6

I bought a IBM M Pro workstation with 64 bit XP pro on it.
The vanatge client will not install has anyone else had this problem?


Regards,

Mark Howard
Financial Controller
Jaws Buckets & Attachments
Ph- 07-32777499
10 Willingdon st
Archerfield 4108


____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Jason Claggett
Sent: Wednesday, 6 June 2007 12:58 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] DB Backup

Ben,

Typically, you will need to get the entire contents of the mfgsys
directory - minus the DB folder because those files are in use.

To restore completely, you will need:

CD or DVDs for Progress and Vantage

Backup tape.

Make a vanilla install of Progress, Progress SP, and Vantage 6.1 to set
all the registry values etc - it is recommended that you make this the
same path to eliminate any issues that occur. Next, rename the vanilla
install MFGSYS61 directory (note you may not want to remove this just
yet). Insert backup tape and restore the mfgsys61 directory. Finally,
restore your database from the tape to a temporary directory. Run the
prorest command to create the database and the necessary files.

Start the databases and this should be all you need to do.

Thanks,

Jason Claggett

Microsoft Small Business Specialist

MCP #3856159

2W Technologies, LLC

317.578.2393

jason@2wtech. com <mailto:jason% 402wtech. com>

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of bbelzer42
Sent: Tuesday, June 05, 2007 7:18 PM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: [Vantage] DB Backup

Hi All,

I have been backing up our servers on a daily basis, but I need to
know that I have Vantage backed up properly. A batch file runs every
night to backup the database to a separate file.

That file is called backup61.1 (a .1 file). It is the full size of
our database. This file is then being backed up on the backup tapes.
I don't back up several other files because Veritas states that they
are in use.

In case of a real emergency, will I only need that main db backup file
to get up and running? Or are there other files I should be backing
up as well.

Thanks in advance!
Ben

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

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





___________________________________________________________________________________
You snooze, you lose. Get messages ASAP with AutoCheck
in the all-new Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/newmail_html.html

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