Automating backup in RMS

Posted by Moe on June 7, 2005, 5:18 pm

Please log in for more thread options

Or just create a .bat file with notepad and include the following:

OSQL -U sa -P dakota -S HomeOffice -q "RESTORE DATABASE horsin_around
FROM DISK = 'H:horsin_around.bck' WITH REPLACE, STATS = 5"

Of course change the parameters to match your system and database name.

Rob wrote:

> Mark,

> This is from the Store Operations Adminstrator Online Help - Restoring a

> database'.

> 1. On the Database menu, click Create. The Create Database Wizard

> appears.

> 2. On the Welcome screen, click Next.

> 3. In the Database Name box, enter the name of the database you are

> creating.

> 4. In the Initial Size (MB) box, enter the amount of space, in

> megabytes (MB), to allocate on that device for the database, and then click

> Next.

> 5. Specify how the database file should grow, and then click Next. In

> most cases, you can accept the defaults.

> 6. Click the Browse icon to locate the backup file.

> 7. On the Open window, select the backup file from which you want to

> restore. The backup file should have *.bck as the file extension. Then click

> Open.

> 8. On the wizard screen, click Next.

> 9. To create the new database with the information from the backup

> file, click Finish.

> 10. Store Operations should notify you that the restore is complete. Click

> OK.

> Rob

> > Rob, I have my backup working now based on your instructions, but now my

> > stupid question is if I have a need to do a restore from this backup how

> > do

> > do that? I want to be prepared.

> >

> > Thanks

> >

> > "Rob" wrote:

> >

> >> 1.. In Notepad, paste the following text in the new batch file:

> >>

> >> osql -U sa -P -S server name -Q "BACKUP DATABASE database name TO DISK =

> >> 'e:backupback1.bck'"a.. If you have a password for the system

> >> administrator user, you must enter the password after the -P parameter.

> >> For

> >> example, insert -P password.

> >> b.. Replace server name with the name of your server. You can see the

> >> name of your server in the SQL Server Service Manager.

> >> c.. Replace database name with the actual name of your Store

> >> Operations

> >> database or Headquarters database.

> >> d.. Replace e:backupback1.bck with the actual path of the drive and

> >> the directory where you want to save the backup and the actual name that

> >> you

> >> want for the backup file.

> >> 2.. Save the file.

> >> 3.. Click Start, point to All Programs, point to Accessories, point to

> >> System Tools, and then click Scheduled Tasks.

> >>

> >> Use Task Scheduler to run your batch file from the server. See Windows

> >> Help for more information about how to set up and how to run Task

> >> Scheduler.

> >> Important Every time that you use Task Scheduler to run your batch file,

> >> the

> >> backup file name that the batch file generates is the same file name that

> >> you entered for the path and file name when you created the batch file.

> >> Therefore, if you want to maintain a series of backup files, use one of

> >> the

> >> following methods before or after you run the backup:

> >>

> >> a.. Move the backup file to another location.

> >> b.. Rename the backup file.

> >> Otherwise, the backup file will be appended every time that you use Task

> >> Scheduler to run the batch file. This may make the backup file unusable.

> >>

> >> > root - what would the command line need to be in the .bat file to

> >> > initiate

> >> > the backup process?

> >> >

> >> > thanks,

> >> > kevin

> >> >

> >> > "root" wrote:

> >> >

> >> >> Larry,

> >> >>

> >> >> You can do a .bat file and schedule it to run in the scheduled tasks

> >> >> OR

> >> >> you

> >> >> can download the SQL trial and only install the Enterprise Manager

> >> >> part.

> >> >> Enterprise Manager will give you the GUI for MSDE and enable you to do

> >> >> a

> >> >> scheduled maintenance plan with backup, shrink, and other tasks...

> >> >>

> >> >> message

> >> >> > Does anyone have an easy solution for automatically backing up the

> >> >> > database

> >> >> > for RMS? Our clerks seem to be unable to remember to do it daily.

> >> >> >

> >> >> > Thanks for any help.

> >> >> >

> >> >> > Larry

> >> >>

> >>

Posted by Andrewø ÝìŠÇ.²È¨žÉ¢rº,¡û\¢ on June 29, 2005, 12:16 pm

Please log in for more thread options

Based off of all of the great ideas here, I created a small .bat file to
backup the database with a 3 day alternating backup scheme and copying the
database to a backroom computer as well, providing some redudant storage.

I just schedule it as a task to run at a certain time on the backroom
computer (right after closing time) and it keeps the last three backups
automatically. To tell what date the backup was made, just look at the file
info and look at the timestamp. So far seems to work well.

Just replace the database name as well as the computer names/backup
directories with what you you need (making sure the directory you're trying
to save to is shared on the network).

BATCH FILE START:

::RMS Auto-backup with redundant storage

:: Checks if the other backups exist on ONE (main server) and renames them,
deleting the oldest backup
IF EXIST \ONEcRMSBackupsRMSbackup3.bck DEL
\ONEcRMSBackupsRMSbackup3.bck
IF EXIST \ONEcRMSBackupsRMSbackup2.bck REN
\ONEcRMSBackupsRMSbackup2.bck RMSbackup3.bck
IF EXIST \ONEcRMSBackupsRMSbackup1.bck REN
\ONEcRMSBackupsRMSbackup1.bck RMSbackup2.bck

:: Creates the newest backup on ONE (main server) from SQL query
OSQL -U sa -P 4050 -S one -Q "BACKUP DATABASE [61604] TO DISK =
'\ONEcRMSBackupsRMSbackup1.bck'"

:: Checks if the other backups exist on Backroom (redundant storage) and
renames them, deleting the oldest backup
IF EXIST "\BackroomC on BackofficeRMSBackupsRMSbackup3.bck" DEL
"\BackroomC on BackofficeRMSBackupsRMSbackup3.bck"
IF EXIST "\BackroomC on BackofficeRMSBackupsRMSbackup2.bck" REN
"\BackroomC on BackofficeRMSBackupsRMSbackup2.bck" RMSbackup3.bck
IF EXIST "\BackroomC on BackofficeRMSBackupsRMSbackup1.bck" REN
"\BackroomC on BackofficeRMSBackupsRMSbackup1.bck" RMSbackup2.bck

:: Copies the newest backup from ONE (main server) to Backroom (redundant
storage)
COPY /Y \ONEcRMSBackupsRMSbackup1.bck "\BackroomC on
BackofficeRMSBackupsRMSbackup1.bck"

END OF BATCH FILE:

Also, you could just use the first half which calls the sql and have it run
as a task on your register machine, which would prevent the need for the
backroom computer to be on in order for the backup to initiate.

Don't know if it's useful to anyone else or not, but there it is.

~Andrew Reinartz
Wayne & Mary's Nutrition Center

"Moe" wrote:

> Or just create a .bat file with notepad and include the following:

> OSQL -U sa -P dakota -S HomeOffice -q "RESTORE DATABASE horsin_around

> FROM DISK = 'H:horsin_around.bck' WITH REPLACE, STATS = 5"

> Of course change the parameters to match your system and database name.

> Rob wrote:

> > Mark,

> >

> > This is from the Store Operations Adminstrator Online Help - Restoring a

> > database'.

> > 1. On the Database menu, click Create. The Create Database Wizard

> > appears.

> >

> > 2. On the Welcome screen, click Next.

> >

> > 3. In the Database Name box, enter the name of the database you are

> > creating.

> >

> > 4. In the Initial Size (MB) box, enter the amount of space, in

> > megabytes (MB), to allocate on that device for the database, and then click

> > Next.

> >

> > 5. Specify how the database file should grow, and then click Next. In

> > most cases, you can accept the defaults.

> >

> > 6. Click the Browse icon to locate the backup file.

> >

> > 7. On the Open window, select the backup file from which you want to

> > restore. The backup file should have *.bck as the file extension. Then click

> > Open.

> >

> > 8. On the wizard screen, click Next.

> >

> > 9. To create the new database with the information from the backup

> > file, click Finish.

> >

> > 10. Store Operations should notify you that the restore is complete. Click

> > OK.

> >

> > Rob

> >

> > > Rob, I have my backup working now based on your instructions, but now my

> > > stupid question is if I have a need to do a restore from this backup how

> > > do

> > > do that? I want to be prepared.

> > >

> > > Thanks

> > >

> > > "Rob" wrote:

> > >

> > >> 1.. In Notepad, paste the following text in the new batch file:

> > >>

> > >> osql -U sa -P -S server name -Q "BACKUP DATABASE database name TO DISK =

> > >> 'e:backupback1.bck'"a.. If you have a password for the system

> > >> administrator user, you must enter the password after the -P parameter.

> > >> For

> > >> example, insert -P password.

> > >> b.. Replace server name with the name of your server. You can see the

> > >> name of your server in the SQL Server Service Manager.

> > >> c.. Replace database name with the actual name of your Store

> > >> Operations

> > >> database or Headquarters database.

> > >> d.. Replace e:backupback1.bck with the actual path of the drive and

> > >> the directory where you want to save the backup and the actual name that

> > >> you

> > >> want for the backup file.

> > >> 2.. Save the file.

> > >> 3.. Click Start, point to All Programs, point to Accessories, point to

> > >> System Tools, and then click Scheduled Tasks.

> > >>

> > >> Use Task Scheduler to run your batch file from the server. See Windows

> > >> Help for more information about how to set up and how to run Task

> > >> Scheduler.

> > >> Important Every time that you use Task Scheduler to run your batch file,

> > >> the

> > >> backup file name that the batch file generates is the same file name that

> > >> you entered for the path and file name when you created the batch file.

> > >> Therefore, if you want to maintain a series of backup files, use one of

> > >> the

> > >> following methods before or after you run the backup:

> > >>

> > >> a.. Move the backup file to another location.

> > >> b.. Rename the backup file.

> > >> Otherwise, the backup file will be appended every time that you use Task

> > >> Scheduler to run the batch file. This may make the backup file unusable.

> > >>

> > >> > root - what would the command line need to be in the .bat file to

> > >> > initiate

> > >> > the backup process?

> > >> >

> > >> > thanks,

> > >> > kevin

> > >> >

> > >> > "root" wrote:

> > >> >

> > >> >> Larry,

> > >> >>

> > >> >> You can do a .bat file and schedule it to run in the scheduled tasks

> > >> >> OR

> > >> >> you

> > >> >> can download the SQL trial and only install the Enterprise Manager

> > >> >> part.

> > >> >> Enterprise Manager will give you the GUI for MSDE and enable you to do

> > >> >> a

> > >> >> scheduled maintenance plan with backup, shrink, and other tasks...

> > >> >>

> > >> >> message

> > >> >> > Does anyone have an easy solution for automatically backing up the

> > >> >> > database

> > >> >> > for RMS? Our clerks seem to be unable to remember to do it daily.

> > >> >> >

> > >> >> > Thanks for any help.

> > >> >> >

> > >> >> > Larry

> > >> >>

> > >>

Posted by Andy Miller - T on September 11, 2006, 3:05 pm

Please log in for more thread options

I've been running backup scripts very similar to these RMS Store Ops
scripts... However, they do not work for Microsoft POS. Does anyone know
what batch code to use to auto backup a Microsoft POS database?

this is what I am currently using... (works fine with RMS Store Ops)
del C:BACKUPFriday_POS.bck
osql -U sa -P -Q "BACKUP DATABASE StoreDB TO DISK='C:BACKUPFriday_POS.bck'"
xcopy c:BACKUPFriday_POS.bck "\BackOfficeBACKUP" /Y

this is what it says when i try to run this script using Microsoft POS
[SHared memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

"Rob" wrote:

> 1.. In Notepad, paste the following text in the new batch file:

> osql -U sa -P -S server name -Q "BACKUP DATABASE database name TO DISK =

> 'e:backupback1.bck'"a.. If you have a password for the system

> administrator user, you must enter the password after the -P parameter. For

> example, insert -P password.

> b.. Replace server name with the name of your server. You can see the

> name of your server in the SQL Server Service Manager.

> c.. Replace database name with the actual name of your Store Operations

> database or Headquarters database.

> d.. Replace e:backupback1.bck with the actual path of the drive and

> the directory where you want to save the backup and the actual name that you

> want for the backup file.

> 2.. Save the file.

> 3.. Click Start, point to All Programs, point to Accessories, point to

> System Tools, and then click Scheduled Tasks.

> Use Task Scheduler to run your batch file from the server. See Windows

> Help for more information about how to set up and how to run Task Scheduler.

> Important Every time that you use Task Scheduler to run your batch file, the

> backup file name that the batch file generates is the same file name that

> you entered for the path and file name when you created the batch file.

> Therefore, if you want to maintain a series of backup files, use one of the

> following methods before or after you run the backup:

> a.. Move the backup file to another location.

> b.. Rename the backup file.

> Otherwise, the backup file will be appended every time that you use Task

> Scheduler to run the batch file. This may make the backup file unusable.

> > root - what would the command line need to be in the .bat file to initiate

> > the backup process?

> >

> > thanks,

> > kevin

> >

> > "root" wrote:

> >

> >> Larry,

> >>

> >> You can do a .bat file and schedule it to run in the scheduled tasks OR

> >> you

> >> can download the SQL trial and only install the Enterprise Manager part.

> >> Enterprise Manager will give you the GUI for MSDE and enable you to do a

> >> scheduled maintenance plan with backup, shrink, and other tasks...

> >>

> >> message

> >> > Does anyone have an easy solution for automatically backing up the

> >> > database

> >> > for RMS? Our clerks seem to be unable to remember to do it daily.

> >> >

> >> > Thanks for any help.

> >> >

> >> > Larry

> >>

Posted by Jeff on September 11, 2006, 5:04 pm

Please log in for more thread options

: quoted-printable

Andy,

Haven't played too much with MSPOS, but I do know that it installs a =
MSDE Instance, I've forgotten what its called (MSPOSIntance, maybe) that =
you probably need to reference. RMS uses the default instance (not =
named).

Change to something like;

osql -U sa -P -S (servernameinstancename) -Q "BACKUP DATABASE StoreDB =
TO DISK=3D'C:BACKUPFriday_POS.bck'

You could use .instancename also.

I _think_ you can just move your mouse over the SQL service icon in the =
system tray to find the servernameinstancename

Also, I see you didn't enter a password after the -P. I hope that was a =
mistake and that you _are_ using a password for your SQL Server for =
security reasons.

--=20
*
Get Secure! - www.microsoft.com/security

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment. If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz

**********

"Andy Miller - Teknor, Inc." =
I've been running backup scripts very similar to these RMS Store Ops=20
scripts... However, they do not work for Microsoft POS. Does anyone =
know=20
what batch code to use to auto backup a Microsoft POS database?

this is what I am currently using... (works fine with RMS Store Ops)
del C:BACKUPFriday_POS.bck
osql -U sa -P -Q "BACKUP DATABASE StoreDB TO =
DISK=3D'C:BACKUPFriday_POS.bck'"
xcopy c:BACKUPFriday_POS.bck "\BackOfficeBACKUP" /Y

this is what it says when i try to run this script using Microsoft POS
[SHared memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

"Rob" wrote:

> 1.. In Notepad, paste the following text in the new batch file:
>=20
>=20
> osql -U sa -P -S server name -Q "BACKUP DATABASE database name TO =
DISK =3D=20
> 'e:backupback1.bck'"a.. If you have a password for the system=20
> administrator user, you must enter the password after the -P =
parameter. For=20
> example, insert -P password.
> b.. Replace server name with the name of your server. You can =
see the=20
> name of your server in the SQL Server Service Manager.
> c.. Replace database name with the actual name of your Store =
Operations=20
> database or Headquarters database.
> d.. Replace e:backupback1.bck with the actual path of the =
drive and=20
> the directory where you want to save the backup and the actual name =
that you=20
> want for the backup file.
> 2.. Save the file.
> 3.. Click Start, point to All Programs, point to Accessories, =
point to=20
> System Tools, and then click Scheduled Tasks.
>=20
> Use Task Scheduler to run your batch file from the server. See =
Windows=20
> Help for more information about how to set up and how to run Task =
Scheduler.
> Important Every time that you use Task Scheduler to run your batch =
file, the=20
> backup file name that the batch file generates is the same file name =
that=20
> you entered for the path and file name when you created the batch =
file.=20
> Therefore, if you want to maintain a series of backup files, use one =
of the=20
> following methods before or after you run the backup:
>=20
> a.. Move the backup file to another location.
> b.. Rename the backup file.
> Otherwise, the backup file will be appended every time that you use =
Task=20
> Scheduler to run the batch file. This may make the backup file =
unusable.
>=20
>=20
> > root - what would the command line need to be in the .bat file to =
initiate
> > the backup process?
> >
> > thanks,
> > kevin
> >
> > "root" wrote:
> >
> >> Larry,
> >>
> >> You can do a .bat file and schedule it to run in the scheduled =
tasks OR=20
> >> you
> >> can download the SQL trial and only install the Enterprise =
Manager part.
> >> Enterprise Manager will give you the GUI for MSDE and enable you =
to do a
> >> scheduled maintenance plan with backup, shrink, and other =
tasks...
> >>
> >>
> >>
in=20
> >> message
> >> > Does anyone have an easy solution for automatically backing up =
the
> >> > database
> >> > for RMS? Our clerks seem to be unable to remember to do it =
daily.
> >> >
> >> > Thanks for any help.
> >> >
> >> > Larry
> >>
> >>
> >>=20
>=20
>=20
>
------=_NextPart_000_0449_01C6D5AB.2E8CEF70
Content-Type: text/html;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Andy,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Haven't played too much with MSPOS, but I do =
know that=20
it installs a MSDE Instance, I've forgotten what its called =
(MSPOSIntance,=20
maybe) that you probably need to reference.  RMS uses the default =
instance=20
(not named).</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Change to something like;</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV>osql -U sa -P -S (servernameinstancename)  -Q "BACKUP =
DATABASE=20
StoreDB TO DISK=3D'C:BACKUPFriday_POS.bck'</DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>You could use .instancename =
also.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>I _think_ you can just move your mouse over =
the SQL=20
service icon in the system tray to find the =
servernameinstancename</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Also, I see you didn't enter a password after =
the=20
-P.  I hope that was a mistake and that you _are_ using a password =
for your=20
SQL Server for security reasons.</FONT></DIV>
<DIV><BR>-- <BR>*<BR>Get Secure! - <A=20
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>=
</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment.  If you are not using a =
reader,=20
follow<BR>the link below to setup Outlook Express.  Click on "Open =
with=20
newsreader"<BR>under the MS Retail Management System on the right.</DIV>
<DIV> </DIV>
<DIV><A =
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV> </DIV>
<DIV>**********<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Andy Miller - Teknor, Inc." <<A=20
=
eknorInc@discussions.microsoft.com</A>>=20
wrote in message <A=20
=
FB34D-6004-4416-87F3-9C0FB2AA1BAA@microsoft.com</A>...</DIV>I've=20
been running backup scripts very similar to these RMS Store Ops =
<BR>scripts...=20
However, they do not work for Microsoft POS.  Does anyone know =
<BR>what=20
batch code to use to auto backup a Microsoft POS database?<BR><BR>this =
is what=20
I am currently using... (works fine with RMS Store Ops)<BR>del=20
C:BACKUPFriday_POS.bck<BR>osql -U sa -P -Q "BACKUP DATABASE StoreDB =
TO=20
DISK=3D'C:BACKUPFriday_POS.bck'"<BR>xcopy c:BACKUPFriday_POS.bck =
"<A=20
href=3D"file://\BackOfficeBACKUP">\BackOfficeBACKUP</A>" =
/Y<BR><BR>this is=20
what it says when i try to run this script using Microsoft =
POS<BR>[SHared=20
memory]SQL Server does not exist or access denied.<BR>[Shared=20
Memory]ConnectionOpen (Connect()).<BR><BR>"Rob" =
wrote:<BR><BR>>  =20
1.. In Notepad, paste the following text in the new batch =
file:<BR>>=20
<BR>> <BR>> osql -U sa -P -S server name -Q "BACKUP DATABASE =
database=20
name TO DISK =3D <BR>> 'e:backupback1.bck'"a.. If you have a =
password for=20
the system <BR>> administrator user, you must enter the password =
after the=20
-P parameter. For <BR>> example, insert -P=20
password.<BR>>     b.. Replace server name with =
the=20
name of your server. You can see the <BR>> name of your server in =
the SQL=20
Server Service Manager.<BR>>     c.. Replace =
database=20
name with the actual name of your Store Operations <BR>> database =
or=20
Headquarters database.<BR>>     d.. Replace=20
e:backupback1.bck with the actual path of the drive and <BR>> the =

directory where you want to save the backup and the actual name that =
you=20
<BR>> want for the backup file.<BR>>   2.. Save the=20
file.<BR>>   3.. Click Start, point to All Programs, =
point to=20
Accessories, point to <BR>> System Tools, and then click Scheduled=20
Tasks.<BR>> <BR>>   Use Task Scheduler to run your =
batch file=20
from the server. See Windows <BR>> Help for more information about =
how to=20
set up and how to run Task Scheduler.<BR>> Important Every time =
that you=20
use Task Scheduler to run your batch file, the <BR>> backup file =
name that=20
the batch file generates is the same file name that <BR>> you =
entered for=20
the path and file name when you created the batch file. <BR>> =
Therefore, if=20
you want to maintain a series of backup files, use one of the <BR>> =

following methods before or after you run the backup:<BR>>=20
<BR>>   a.. Move the backup file to another=20
location.<BR>>   b.. Rename the backup file.<BR>> =
Otherwise,=20
the backup file will be appended every time that you use Task <BR>> =

Scheduler to run the batch file. This may make the backup file=20
unusable.<BR>> <BR>> "kskinne" <<A=20
=
rosoft.com</A>>=20
wrote in message <BR>> <A=20
=
FA011-B61E-44A9-9216-AAB9C0376803@microsoft.com</A>...<BR>>=20
<BR>> > root - what would the command line need to be in the =
.bat file=20
to initiate<BR>> > the backup process?<BR>> ><BR>> > =

thanks,<BR>> > kevin<BR>> ><BR>> > "root" =
wrote:<BR>>=20
><BR>> >> Larry,<BR>> >><BR>> >> You can =
do a=20
.bat file and schedule it to run in the scheduled tasks OR <BR>> =
>>=20
you<BR>> >> can download the SQL trial and only install the=20
Enterprise Manager part.<BR>> >> Enterprise Manager will give =
you the=20
GUI for MSDE and enable you to do a<BR>> >> scheduled =
maintenance=20
plan with backup, shrink, and other tasks...<BR>> >><BR>>=20
>><BR>> >><BR>> >> "Larry Jenuwine" <<A=20
=
cussions.microsoft.com</A>>=20
wrote in <BR>> >> message<BR>> >> <A=20
=
40F1B-3B0A-445A-B641-03D2487A7180@microsoft.com</A>...<BR>>=20
>> > Does anyone have an easy solution for automatically =
backing up=20
the<BR>> >> > database<BR>> >> > for =
RMS?  Our=20
clerks seem to be unable to remember to do it daily.<BR>> >>=20
><BR>> >> > Thanks for any help.<BR>> >> =
><BR>>=20
>> > Larry<BR>> >><BR>> >><BR>> >> =

<BR>> <BR>> <BR>></BLOCKQUOTE></BODY></HTML>

------=

Posted by Jason on September 24, 2006, 5:23 pm

Please log in for more thread options

Let's take it another step. How an I compress the backup file to a .zip file
using the command line to save space and make it faster to copy over a VPN?

Jason