Progress DB Backup

system · July 15, 2009, 1:49pm

If you titled it MSSQL for Overachieving Dummies id probably buy it..

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Wednesday, July 15, 2009 12:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress DB Backup

I should write a crash course in MSSQL book and sell it for thousands!

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Wednesday, July 15, 2009 12:47 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Progress DB Backup

Thanks guys!!

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, July 15, 2009 11:39 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Progress DB Backup

As far as SQL goes the one thing to watch is the size of the t-log
(*.ldf)
files if you have a massive amount of transactions in one day (a service
connect that up 100000000000 new parts for example) your t-log will
become
pretty big and then your t-log back up is going to clear the contents of
the
t-log but the file will not release that free space until you tell it
to.
Right click the database go to all task select shrink db. In there you
should have an option in there for files open that up and specify how
big
you want your t-log to be. I would recommend a full backup before and
after
doing this. If you want detailed instructions I can put some together
for
you.

I managed about 500 separate SQL Servers with about 3K databases in a
former
job all I thought about was SQL for 1.5 years..

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Wednesday, July 15, 2009 12:22 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Progress DB Backup

Those sound like some feasible options, obviously I don't know a whole
lot about database administration. Are there some things we should be
doing to our SQL database to maintain it from a size standpoint? From
my access days I know that those used to get huge then you would compact
them and they would be much smaller and run much faster. Is there a
similar concept with SQL as well? Were a single company, single site,
with 30 users and 15 MES stations, with all the variables I'm sure its
not realistic to even try and estimate how big a database should be
after running for 14 months. What are others seeing with their
databases?

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Ned
Sent: Wednesday, July 15, 2009 11:11 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: Re: [Vantage] Progress DB Backup

Don't use Veritas?

I have always had good luck using the built in backup system within MS
SQL
itself, you can schedule a backup to a flat file, and then your Veritas
can
just scoop up that flat file and back it up onto tape or whatever media
you
are using.

I then keep a script on the server that runs daily and deletes any files
in
the auto backup directory that are more than 2 days old so I don't end
up
with dozens of leftover backup files, and in the short term I don't need
to
go to tape to do a restore of a DB.

----- Original Message -----
From: "Rob Bucek" <rbucek@dsmfg. <mailto:rbucek%40dsmfg.com> com
<mailto:rbucek%40dsmfg.com> >
To: <vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> >
Sent: Wednesday, July 15, 2009 12:02 PM
Subject: RE: [Vantage] Progress DB Backup

> Ok since vic was asking about backing up DB's, were using SQL, when we
> started a year ago our database was 300mb...since then were now at
> 11GB..using veritas..its taking an enormous amount of time to back up.
> How can we shorten this time?
>
>
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Charlie Wilson
> Sent: Wednesday, July 15, 2009 9:57 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Progress DB Backup
>
>
>
>
>
> c:
>
> cd \epicor\oe101b\bin
>
> probkup online c:\epicor\mfgsys803\db\mfgsys c:\backup\production.1
>
> then backup the production.1 file. I also backup
> c:\epicor\mfgsys803\server\reports.
>
> That script is different if you are on progress 10.0
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Vic Drecchio
> Sent: Wednesday, July 15, 2009 10:52 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Progress DB Backup
>
> For all the Progress database users out there, do you exclude the
> c:\epicor\mfgsys803\db folder from your nightly backup? For example,
> using Backup Exec I've read and been told (even by Epicor) to exclude
> the *entire* c:\epicor folder and subfolders.
>
> How are you dumping your Progress database to another folder to make
it
> available for nightly backup?
>
> Thank you in advance.
>
> Vic
>
> [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]
>
>
>
> ------------------------------------
>
> 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. <http://groups.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
<http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>

[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]

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

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

system · July 15, 2009, 10:53am

For all the Progress database users out there, do you exclude the
c:\epicor\mfgsys803\db folder from your nightly backup? For example,
using Backup Exec I've read and been told (even by Epicor) to exclude
the *entire* c:\epicor folder and subfolders.

How are you dumping your Progress database to another folder to make it
available for nightly backup?

Thank you in advance.

Vic

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

system · July 15, 2009, 10:57am

Vic,
when you use the back up utility it will do just that, avoid all Epicor
files. What it backs up are the files in the 'db' folder. It makes one
flat file (the .1 file). Then back up this file through Veritas or
whatever backup program you use for all of your files.

M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Wednesday, July 15, 2009 9:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress DB Backup

For all the Progress database users out there, do you exclude the
c:\epicor\mfgsys803\db folder from your nightly backup? For example,
using Backup Exec I've read and been told (even by Epicor) to exclude
the *entire* c:\epicor folder and subfolders.

How are you dumping your Progress database to another folder to make it
available for nightly backup?

Thank you in advance.

Vic

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

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

system · July 15, 2009, 10:58am

c:

cd \epicor\oe101b\bin

probkup online c:\epicor\mfgsys803\db\mfgsys c:\backup\production.1

then backup the production.1 file. I also backup
c:\epicor\mfgsys803\server\reports.

That script is different if you are on progress 10.0

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Vic Drecchio
Sent: Wednesday, July 15, 2009 10:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress DB Backup

For all the Progress database users out there, do you exclude the
c:\epicor\mfgsys803\db folder from your nightly backup? For example,
using Backup Exec I've read and been told (even by Epicor) to exclude
the *entire* c:\epicor folder and subfolders.

How are you dumping your Progress database to another folder to make it
available for nightly backup?

Thank you in advance.

Vic

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

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

system · July 15, 2009, 12:02pm

Ok since vic was asking about backing up DB's, were using SQL, when we
started a year ago our database was 300mb...since then were now at
11GB..using veritas..its taking an enormous amount of time to back up.
How can we shorten this time?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Wednesday, July 15, 2009 9:57 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress DB Backup

c:

cd \epicor\oe101b\bin

probkup online c:\epicor\mfgsys803\db\mfgsys c:\backup\production.1

then backup the production.1 file. I also backup
c:\epicor\mfgsys803\server\reports.

That script is different if you are on progress 10.0

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Vic Drecchio
Sent: Wednesday, July 15, 2009 10:52 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Progress DB Backup

For all the Progress database users out there, do you exclude the
c:\epicor\mfgsys803\db folder from your nightly backup? For example,
using Backup Exec I've read and been told (even by Epicor) to exclude
the *entire* c:\epicor folder and subfolders.

How are you dumping your Progress database to another folder to make it
available for nightly backup?

Thank you in advance.

Vic

[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]

system · July 15, 2009, 12:10pm

Don't use Veritas?

I have always had good luck using the built in backup system within MS SQL
itself, you can schedule a backup to a flat file, and then your Veritas can
just scoop up that flat file and back it up onto tape or whatever media you
are using.

I then keep a script on the server that runs daily and deletes any files in
the auto backup directory that are more than 2 days old so I don't end up
with dozens of leftover backup files, and in the short term I don't need to
go to tape to do a restore of a DB.

----- Original Message -----
From: "Rob Bucek" <rbucek@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, July 15, 2009 12:02 PM
Subject: RE: [Vantage] Progress DB Backup

> Ok since vic was asking about backing up DB's, were using SQL, when we
> started a year ago our database was 300mb...since then were now at
> 11GB..using veritas..its taking an enormous amount of time to back up.
> How can we shorten this time?
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Charlie Wilson
> Sent: Wednesday, July 15, 2009 9:57 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Progress DB Backup
>
>
>
>
>
> c:
>
> cd \epicor\oe101b\bin
>
> probkup online c:\epicor\mfgsys803\db\mfgsys c:\backup\production.1
>
> then backup the production.1 file. I also backup
> c:\epicor\mfgsys803\server\reports.
>
> That script is different if you are on progress 10.0
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Vic Drecchio
> Sent: Wednesday, July 15, 2009 10:52 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Progress DB Backup
>
> For all the Progress database users out there, do you exclude the
> c:\epicor\mfgsys803\db folder from your nightly backup? For example,
> using Backup Exec I've read and been told (even by Epicor) to exclude
> the *entire* c:\epicor folder and subfolders.
>
> How are you dumping your Progress database to another folder to make it
> available for nightly backup?
>
> Thank you in advance.
>
> Vic
>
> [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]
>
>
>
> ------------------------------------
>
> 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
>
>
>

system · July 15, 2009, 12:25pm

Those sound like some feasible options, obviously I don't know a whole
lot about database administration. Are there some things we should be
doing to our SQL database to maintain it from a size standpoint? From
my access days I know that those used to get huge then you would compact
them and they would be much smaller and run much faster. Is there a
similar concept with SQL as well? Were a single company, single site,
with 30 users and 15 MES stations, with all the variables I'm sure its
not realistic to even try and estimate how big a database should be
after running for 14 months. What are others seeing with their
databases?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ned
Sent: Wednesday, July 15, 2009 11:11 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Progress DB Backup

Don't use Veritas?

I have always had good luck using the built in backup system within MS
SQL
itself, you can schedule a backup to a flat file, and then your Veritas
can
just scoop up that flat file and back it up onto tape or whatever media
you
are using.

I then keep a script on the server that runs daily and deletes any files
in
the auto backup directory that are more than 2 days old so I don't end
up
with dozens of leftover backup files, and in the short term I don't need
to
go to tape to do a restore of a DB.

----- Original Message -----
From: "Rob Bucek" <rbucek@... <mailto:rbucek%40dsmfg.com> >
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Sent: Wednesday, July 15, 2009 12:02 PM
Subject: RE: [Vantage] Progress DB Backup

> Ok since vic was asking about backing up DB's, were using SQL, when we
> started a year ago our database was 300mb...since then were now at
> 11GB..using veritas..its taking an enormous amount of time to back up.
> How can we shorten this time?
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Charlie Wilson
> Sent: Wednesday, July 15, 2009 9:57 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Progress DB Backup
>
>
>
>
>
> c:
>
> cd \epicor\oe101b\bin
>
> probkup online c:\epicor\mfgsys803\db\mfgsys c:\backup\production.1
>
> then backup the production.1 file. I also backup
> c:\epicor\mfgsys803\server\reports.
>
> That script is different if you are on progress 10.0
>
> ~Charlie
>
> _____
>
> 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
> Vic Drecchio
> Sent: Wednesday, July 15, 2009 10:52 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Progress DB Backup
>
> For all the Progress database users out there, do you exclude the
> c:\epicor\mfgsys803\db folder from your nightly backup? For example,
> using Backup Exec I've read and been told (even by Epicor) to exclude
> the *entire* c:\epicor folder and subfolders.
>
> How are you dumping your Progress database to another folder to make
it
> available for nightly backup?
>
> Thank you in advance.
>
> Vic
>
> [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]
>
>
>
> ------------------------------------
>
> 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/.
<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
>
>
>

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

system · July 15, 2009, 12:34pm

My SQL .BAK files have went from 560MB when we went live Aug 26 of last
year to 4.4GB today. We have 40 Vantage users and 20 MES, Service
Connect and the PLM product with another 50 or so users.

I use SQL Job Manager and dump the database(s) nightly like Ned said. I
keep a rolling backup of 7 days on the disk and nightly tape backups. I
use the NT "forfiles" command to delete any .bak files older than 7
days.

Backing up a file vs a live SQL database is much faster.

My Progress backup question was for a distraught colleague. :) Thanks
to everyone who helped.

If interested I can share my SQL scripts for ideas.

Vic

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Wednesday, July 15, 2009 12:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress DB Backup

Those sound like some feasible options, obviously I don't know a whole
lot about database administration. Are there some things we should be
doing to our SQL database to maintain it from a size standpoint? From
my access days I know that those used to get huge then you would compact
them and they would be much smaller and run much faster. Is there a
similar concept with SQL as well? Were a single company, single site,
with 30 users and 15 MES stations, with all the variables I'm sure its
not realistic to even try and estimate how big a database should be
after running for 14 months. What are others seeing with their
databases?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ned
Sent: Wednesday, July 15, 2009 11:11 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Progress DB Backup

Don't use Veritas?

I have always had good luck using the built in backup system within MS
SQL
itself, you can schedule a backup to a flat file, and then your Veritas
can
just scoop up that flat file and back it up onto tape or whatever media
you
are using.

I then keep a script on the server that runs daily and deletes any files
in
the auto backup directory that are more than 2 days old so I don't end
up
with dozens of leftover backup files, and in the short term I don't need
to
go to tape to do a restore of a DB.

----- Original Message -----
From: "Rob Bucek" <rbucek@... <mailto:rbucek%40dsmfg.com> >
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Sent: Wednesday, July 15, 2009 12:02 PM
Subject: RE: [Vantage] Progress DB Backup

> Ok since vic was asking about backing up DB's, were using SQL, when we
> started a year ago our database was 300mb...since then were now at
> 11GB..using veritas..its taking an enormous amount of time to back up.
> How can we shorten this time?
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Charlie Wilson
> Sent: Wednesday, July 15, 2009 9:57 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Progress DB Backup
>
>
>
>
>
> c:
>
> cd \epicor\oe101b\bin
>
> probkup online c:\epicor\mfgsys803\db\mfgsys c:\backup\production.1
>
> then backup the production.1 file. I also backup
> c:\epicor\mfgsys803\server\reports.
>
> That script is different if you are on progress 10.0
>
> ~Charlie
>
> _____
>
> 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
> Vic Drecchio
> Sent: Wednesday, July 15, 2009 10:52 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Progress DB Backup
>
> For all the Progress database users out there, do you exclude the
> c:\epicor\mfgsys803\db folder from your nightly backup? For example,
> using Backup Exec I've read and been told (even by Epicor) to exclude
> the *entire* c:\epicor folder and subfolders.
>
> How are you dumping your Progress database to another folder to make
it
> available for nightly backup?
>
> Thank you in advance.
>
> Vic
>
> [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]
>
>
>
> ------------------------------------
>
> 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/.
<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
>
>
>

[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

system · July 15, 2009, 12:34pm

Ned,

Part of SQLs backup utility allows you to setup a clean up routine. I'm not
sure if it's on backup setup or maintenance setup.

We always did full backup on Sunday t-log backup all other days of the week,
and kept two weeks around local on the server. Our tape system kept
everything for two months back.

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ned
Sent: Wednesday, July 15, 2009 12:11 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Progress DB Backup

Don't use Veritas?

I have always had good luck using the built in backup system within MS SQL
itself, you can schedule a backup to a flat file, and then your Veritas can
just scoop up that flat file and back it up onto tape or whatever media you
are using.

I then keep a script on the server that runs daily and deletes any files in
the auto backup directory that are more than 2 days old so I don't end up
with dozens of leftover backup files, and in the short term I don't need to
go to tape to do a restore of a DB.

----- Original Message -----
From: "Rob Bucek" <rbucek@dsmfg. <mailto:rbucek%40dsmfg.com> com>
To: <vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com>
Sent: Wednesday, July 15, 2009 12:02 PM
Subject: RE: [Vantage] Progress DB Backup

> Ok since vic was asking about backing up DB's, were using SQL, when we
> started a year ago our database was 300mb...since then were now at
> 11GB..using veritas..its taking an enormous amount of time to back up.
> How can we shorten this time?
>
>
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
> Of Charlie Wilson
> Sent: Wednesday, July 15, 2009 9:57 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Progress DB Backup
>
>
>
>
>
> c:
>
> cd \epicor\oe101b\bin
>
> probkup online c:\epicor\mfgsys803\db\mfgsys c:\backup\production.1
>
> then backup the production.1 file. I also backup
> c:\epicor\mfgsys803\server\reports.
>
> That script is different if you are on progress 10.0
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Vic Drecchio
> Sent: Wednesday, July 15, 2009 10:52 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Progress DB Backup
>
> For all the Progress database users out there, do you exclude the
> c:\epicor\mfgsys803\db folder from your nightly backup? For example,
> using Backup Exec I've read and been told (even by Epicor) to exclude
> the *entire* c:\epicor folder and subfolders.
>
> How are you dumping your Progress database to another folder to make it
> available for nightly backup?
>
> Thank you in advance.
>
> Vic
>
> [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]
>
>
>
> ------------------------------------
>
> 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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>

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

system · July 15, 2009, 12:39pm

As far as SQL goes the one thing to watch is the size of the t-log (*.ldf)
files if you have a massive amount of transactions in one day (a service
connect that up 100000000000 new parts for example) your t-log will become
pretty big and then your t-log back up is going to clear the contents of the
t-log but the file will not release that free space until you tell it to.
Right click the database go to all task select shrink db. In there you
should have an option in there for files open that up and specify how big
you want your t-log to be. I would recommend a full backup before and after
doing this. If you want detailed instructions I can put some together for
you.

I managed about 500 separate SQL Servers with about 3K databases in a former
job all I thought about was SQL for 1.5 years..

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rob Bucek
Sent: Wednesday, July 15, 2009 12:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress DB Backup

Those sound like some feasible options, obviously I don't know a whole
lot about database administration. Are there some things we should be
doing to our SQL database to maintain it from a size standpoint? From
my access days I know that those used to get huge then you would compact
them and they would be much smaller and run much faster. Is there a
similar concept with SQL as well? Were a single company, single site,
with 30 users and 15 MES stations, with all the variables I'm sure its
not realistic to even try and estimate how big a database should be
after running for 14 months. What are others seeing with their
databases?

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Ned
Sent: Wednesday, July 15, 2009 11:11 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: Re: [Vantage] Progress DB Backup

Don't use Veritas?

I have always had good luck using the built in backup system within MS
SQL
itself, you can schedule a backup to a flat file, and then your Veritas
can
just scoop up that flat file and back it up onto tape or whatever media
you
are using.

I then keep a script on the server that runs daily and deletes any files
in
the auto backup directory that are more than 2 days old so I don't end
up
with dozens of leftover backup files, and in the short term I don't need
to
go to tape to do a restore of a DB.

----- Original Message -----
From: "Rob Bucek" <rbucek@dsmfg. <mailto:rbucek%40dsmfg.com> com
<mailto:rbucek%40dsmfg.com> >
To: <vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> >
Sent: Wednesday, July 15, 2009 12:02 PM
Subject: RE: [Vantage] Progress DB Backup

> Ok since vic was asking about backing up DB's, were using SQL, when we
> started a year ago our database was 300mb...since then were now at
> 11GB..using veritas..its taking an enormous amount of time to back up.
> How can we shorten this time?
>
>
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Charlie Wilson
> Sent: Wednesday, July 15, 2009 9:57 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Progress DB Backup
>
>
>
>
>
> c:
>
> cd \epicor\oe101b\bin
>
> probkup online c:\epicor\mfgsys803\db\mfgsys c:\backup\production.1
>
> then backup the production.1 file. I also backup
> c:\epicor\mfgsys803\server\reports.
>
> That script is different if you are on progress 10.0
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Vic Drecchio
> Sent: Wednesday, July 15, 2009 10:52 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Progress DB Backup
>
> For all the Progress database users out there, do you exclude the
> c:\epicor\mfgsys803\db folder from your nightly backup? For example,
> using Backup Exec I've read and been told (even by Epicor) to exclude
> the *entire* c:\epicor folder and subfolders.
>
> How are you dumping your Progress database to another folder to make
it
> available for nightly backup?
>
> Thank you in advance.
>
> Vic
>
> [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]
>
>
>
> ------------------------------------
>
> 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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>

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

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

system · July 15, 2009, 12:47pm

Rob,

With 45 users and 14 months processing under your belt it would be
virtually impossible to grow the DB from 300MB to 11GB processing
ordinary transactions alone. There are two scenarios where this rate
of growth might occur. First, are you configured to be logging
changes to a ton of fields in the DB? If so, you may have to evaluate
the relative value of tracking those changes and/or remove some of the
logging. Second, and perhaps more likely, is that you may not be
regularly truncating the SQL Server transaction log. You can check
for an inordinately large (well above the size of the .mdf file) .ldf
file in the data directory. If that file is large, you can manually
truncate it to reduce the size.

Regards,

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

On Jul 15, 2009, at 9:21 AM, Rob Bucek wrote:

>
>
> Those sound like some feasible options, obviously I don't know a whole
> lot about database administration. Are there some things we should be
> doing to our SQL database to maintain it from a size standpoint? From
> my access days I know that those used to get huge then you would
> compact
> them and they would be much smaller and run much faster. Is there a
> similar concept with SQL as well? Were a single company, single site,
> with 30 users and 15 MES stations, with all the variables I'm sure its
> not realistic to even try and estimate how big a database should be
> after running for 14 months. What are others seeing with their
> databases?
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> Of Ned
> Sent: Wednesday, July 15, 2009 11:11 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Progress DB Backup
>
> Don't use Veritas?
>
> I have always had good luck using the built in backup system within MS
> SQL
> itself, you can schedule a backup to a flat file, and then your
> Veritas
> can
> just scoop up that flat file and back it up onto tape or whatever
> media
> you
> are using.
>
> I then keep a script on the server that runs daily and deletes any
> files
> in
> the auto backup directory that are more than 2 days old so I don't end
> up
> with dozens of leftover backup files, and in the short term I don't
> need
> to
> go to tape to do a restore of a DB.
>
> ----- Original Message -----
> From: "Rob Bucek" <rbucek@... <mailto:rbucek%40dsmfg.com> >
> To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
> Sent: Wednesday, July 15, 2009 12:02 PM
> Subject: RE: [Vantage] Progress DB Backup
>
> > Ok since vic was asking about backing up DB's, were using SQL,
> when we
> > started a year ago our database was 300mb...since then were now at
> > 11GB..using veritas..its taking an enormous amount of time to back
> up.
> > How can we shorten this time?
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]
> On
> Behalf
> > Of Charlie Wilson
> > Sent: Wednesday, July 15, 2009 9:57 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Progress DB Backup
> >
> >
> >
> >
> >
> > c:
> >
> > cd \epicor\oe101b\bin
> >
> > probkup online c:\epicor\mfgsys803\db\mfgsys c:\backup\production.1
> >
> > then backup the production.1 file. I also backup
> > c:\epicor\mfgsys803\server\reports.
> >
> > That script is different if you are on progress 10.0
> >
> > ~Charlie
> >
> > _____
> >
> > 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
> > Vic Drecchio
> > Sent: Wednesday, July 15, 2009 10:52 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Progress DB Backup
> >
> > For all the Progress database users out there, do you exclude the
> > c:\epicor\mfgsys803\db folder from your nightly backup? For example,
> > using Backup Exec I've read and been told (even by Epicor) to
> exclude
> > the *entire* c:\epicor folder and subfolders.
> >
> > How are you dumping your Progress database to another folder to make
> it
> > available for nightly backup?
> >
> > Thank you in advance.
> >
> > Vic
> >
> > [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]
> >
> >
> >
> > ------------------------------------
> >
> > 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/.
> <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
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
>

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

system · July 15, 2009, 12:48pm

Thanks guys!!

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Wednesday, July 15, 2009 11:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress DB Backup

As far as SQL goes the one thing to watch is the size of the t-log
(*.ldf)
files if you have a massive amount of transactions in one day (a service
connect that up 100000000000 new parts for example) your t-log will
become
pretty big and then your t-log back up is going to clear the contents of
the
t-log but the file will not release that free space until you tell it
to.
Right click the database go to all task select shrink db. In there you
should have an option in there for files open that up and specify how
big
you want your t-log to be. I would recommend a full backup before and
after
doing this. If you want detailed instructions I can put some together
for
you.

I managed about 500 separate SQL Servers with about 3K databases in a
former
job all I thought about was SQL for 1.5 years..

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Wednesday, July 15, 2009 12:22 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Progress DB Backup

Those sound like some feasible options, obviously I don't know a whole
lot about database administration. Are there some things we should be
doing to our SQL database to maintain it from a size standpoint? From
my access days I know that those used to get huge then you would compact
them and they would be much smaller and run much faster. Is there a
similar concept with SQL as well? Were a single company, single site,
with 30 users and 15 MES stations, with all the variables I'm sure its
not realistic to even try and estimate how big a database should be
after running for 14 months. What are others seeing with their
databases?

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Ned
Sent: Wednesday, July 15, 2009 11:11 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: Re: [Vantage] Progress DB Backup

Don't use Veritas?

I have always had good luck using the built in backup system within MS
SQL
itself, you can schedule a backup to a flat file, and then your Veritas
can
just scoop up that flat file and back it up onto tape or whatever media
you
are using.

I then keep a script on the server that runs daily and deletes any files
in
the auto backup directory that are more than 2 days old so I don't end
up
with dozens of leftover backup files, and in the short term I don't need
to
go to tape to do a restore of a DB.

----- Original Message -----
From: "Rob Bucek" <rbucek@dsmfg. <mailto:rbucek%40dsmfg.com> com
<mailto:rbucek%40dsmfg.com> >
To: <vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> >
Sent: Wednesday, July 15, 2009 12:02 PM
Subject: RE: [Vantage] Progress DB Backup

> Ok since vic was asking about backing up DB's, were using SQL, when we
> started a year ago our database was 300mb...since then were now at
> 11GB..using veritas..its taking an enormous amount of time to back up.
> How can we shorten this time?
>
>
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Charlie Wilson
> Sent: Wednesday, July 15, 2009 9:57 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Progress DB Backup
>
>
>
>
>
> c:
>
> cd \epicor\oe101b\bin
>
> probkup online c:\epicor\mfgsys803\db\mfgsys c:\backup\production.1
>
> then backup the production.1 file. I also backup
> c:\epicor\mfgsys803\server\reports.
>
> That script is different if you are on progress 10.0
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Vic Drecchio
> Sent: Wednesday, July 15, 2009 10:52 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Progress DB Backup
>
> For all the Progress database users out there, do you exclude the
> c:\epicor\mfgsys803\db folder from your nightly backup? For example,
> using Backup Exec I've read and been told (even by Epicor) to exclude
> the *entire* c:\epicor folder and subfolders.
>
> How are you dumping your Progress database to another folder to make
it
> available for nightly backup?
>
> Thank you in advance.
>
> Vic
>
> [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]
>
>
>
> ------------------------------------
>
> 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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>

[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]

system · July 15, 2009, 1:33pm

I should write a crash course in MSSQL book and sell it for thousands!

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rob Bucek
Sent: Wednesday, July 15, 2009 12:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress DB Backup

Thanks guys!!

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Wednesday, July 15, 2009 11:39 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Progress DB Backup

As far as SQL goes the one thing to watch is the size of the t-log
(*.ldf)
files if you have a massive amount of transactions in one day (a service
connect that up 100000000000 new parts for example) your t-log will
become
pretty big and then your t-log back up is going to clear the contents of
the
t-log but the file will not release that free space until you tell it
to.
Right click the database go to all task select shrink db. In there you
should have an option in there for files open that up and specify how
big
you want your t-log to be. I would recommend a full backup before and
after
doing this. If you want detailed instructions I can put some together
for
you.

I managed about 500 separate SQL Servers with about 3K databases in a
former
job all I thought about was SQL for 1.5 years..

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Wednesday, July 15, 2009 12:22 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Progress DB Backup

Those sound like some feasible options, obviously I don't know a whole
lot about database administration. Are there some things we should be
doing to our SQL database to maintain it from a size standpoint? From
my access days I know that those used to get huge then you would compact
them and they would be much smaller and run much faster. Is there a
similar concept with SQL as well? Were a single company, single site,
with 30 users and 15 MES stations, with all the variables I'm sure its
not realistic to even try and estimate how big a database should be
after running for 14 months. What are others seeing with their
databases?

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Ned
Sent: Wednesday, July 15, 2009 11:11 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: Re: [Vantage] Progress DB Backup

Don't use Veritas?

I have always had good luck using the built in backup system within MS
SQL
itself, you can schedule a backup to a flat file, and then your Veritas
can
just scoop up that flat file and back it up onto tape or whatever media
you
are using.

I then keep a script on the server that runs daily and deletes any files
in
the auto backup directory that are more than 2 days old so I don't end
up
with dozens of leftover backup files, and in the short term I don't need
to
go to tape to do a restore of a DB.

----- Original Message -----
From: "Rob Bucek" <rbucek@dsmfg. <mailto:rbucek%40dsmfg.com> com
<mailto:rbucek%40dsmfg.com> >
To: <vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> >
Sent: Wednesday, July 15, 2009 12:02 PM
Subject: RE: [Vantage] Progress DB Backup

> Ok since vic was asking about backing up DB's, were using SQL, when we
> started a year ago our database was 300mb...since then were now at
> 11GB..using veritas..its taking an enormous amount of time to back up.
> How can we shorten this time?
>
>
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Charlie Wilson
> Sent: Wednesday, July 15, 2009 9:57 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Progress DB Backup
>
>
>
>
>
> c:
>
> cd \epicor\oe101b\bin
>
> probkup online c:\epicor\mfgsys803\db\mfgsys c:\backup\production.1
>
> then backup the production.1 file. I also backup
> c:\epicor\mfgsys803\server\reports.
>
> That script is different if you are on progress 10.0
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Vic Drecchio
> Sent: Wednesday, July 15, 2009 10:52 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Progress DB Backup
>
> For all the Progress database users out there, do you exclude the
> c:\epicor\mfgsys803\db folder from your nightly backup? For example,
> using Backup Exec I've read and been told (even by Epicor) to exclude
> the *entire* c:\epicor folder and subfolders.
>
> How are you dumping your Progress database to another folder to make
it
> available for nightly backup?
>
> Thank you in advance.
>
> Vic
>
> [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]
>
>
>
> ------------------------------------
>
> 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. <http://groups.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
<http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>

[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]

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