|
|
RMS automated Backup
Hello,
How can Rms Backup be automated. I tried
OSQL -U sa -P useradmin -S user -Q "BACKUP DATABASE [sample] TO DISK =
'\\user\c:\Backup\RMSbackup1.bck'"
but it did not work I have no file in Backup
What password has to come after -P (Administrator or sql)
User is the Name of my pc and
sample is the name of my database
What I'm I doing wrong
|
|
0
|
|
|
|
Reply
|
 Utf
|
4/28/2010 7:54:01 PM |
|
you want to use SQL authentication. this would be the user and password that
you use in Store Administrator > File > Configuration.
What I do with my batch files is I backup to the local C:\POS_Backup
directory. then i do a xcopy command to copy the backupfile to a network
drive.
The following script assumes the following...
User: sa
Password: Password1
Database: RMS
del C:\POS_BACKUP\Database\Friday_POS.bck
osql -U sa -P Password1 -Q "BACKUP DATABASE RMS TO
DISK='C:\POS_BACKUP\Database\Friday_POS.bck'"
xcopy c:\POS_BACKUP\Database\Friday_POS.bck "e:\" /Y
xcopy c:\POS_BACKUP\Database\Friday_POS.bck "\\POS02\POS_BACKUP" /Y
xcopy c:\POS_BACKUP\Database\Friday_POS.bck "\\BackOffice01\POS_BACKUP" /Y
exit
--
Regards,
Andy Miller
DirectPOS - Boise, Idaho
(208) 376-8121 x244
www.directpos.com
"Trinidave" wrote:
> Hello,
> How can Rms Backup be automated. I tried
> OSQL -U sa -P useradmin -S user -Q "BACKUP DATABASE [sample] TO DISK =
> '\\user\c:\Backup\RMSbackup1.bck'"
> but it did not work I have no file in Backup
>
> What password has to come after -P (Administrator or sql)
> User is the Name of my pc and
> sample is the name of my database
>
> What I'm I doing wrong
|
|
|
0
|
|
|
|
Reply
|
Utf
|
5/4/2010 8:38:13 PM
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0044_01CAEDDE.05DEF1A0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
TriniDave,
You must backup to a local drive. Then you can move it using a batch =
file.
--=20
Jeff=20
Check Point Software
Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS)
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s). 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
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
"Trinidave" <Trinidave@discussions.microsoft.com> wrote in message =
news:402225D2-246A-42EC-88E3-218651C0FE2B@microsoft.com...
Hello,
How can Rms Backup be automated. I tried=20
OSQL -U sa -P useradmin -S user -Q "BACKUP DATABASE [sample] TO DISK =
=3D=20
'\\user\c:\Backup\RMSbackup1.bck'"
but it did not work I have no file in Backup
What password has to come after -P (Administrator or sql)
User is the Name of my pc and=20
sample is the name of my database
What I'm I doing wrong
------=_NextPart_000_0044_01CAEDDE.05DEF1A0
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3Dtext/html;charset=3Dutf-8 http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.7600.16535"></HEAD>
<BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: =
15px"=20
id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 =
CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT color=3D#008000>TriniDave,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>You must backup to a local drive. Then =
you can=20
move it using a batch file.</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>Search this newsgroup -- <A=20
href=3D"http://tinyurl.com/2lmk4w">http://tinyurl.com/2lmk4w</A> =
(Stolen=20
from =
DRS)<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s). If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express. =20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #008000 2px solid; PADDING-LEFT: 5px; =
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV>"Trinidave" <<A=20
=
href=3D"mailto:Trinidave@discussions.microsoft.com">Trinidave@discussions=
..microsoft.com</A>>=20
wrote in message <A=20
=
href=3D"news:402225D2-246A-42EC-88E3-218651C0FE2B@microsoft.com">news:402=
225D2-246A-42EC-88E3-218651C0FE2B@microsoft.com</A>...</DIV>Hello,<BR>&nb=
sp; =20
How can Rms Backup be automated. I tried <BR>OSQL -U sa -P useradmin =
-S user=20
-Q "BACKUP DATABASE [sample] TO DISK =3D=20
<BR>'\\user\c:\Backup\RMSbackup1.bck'"<BR>but it did not work I have =
no file=20
in Backup<BR><BR>What password has to come after -P (Administrator or=20
sql)<BR>User is the Name of my pc and <BR>sample is the name of my=20
database<BR><BR>What I'm I doing wrong</BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0044_01CAEDDE.05DEF1A0--
|
|
|
0
|
|
|
|
Reply
|
Jeff
|
5/7/2010 7:08:37 PM
|
|
|
2 Replies
286 Views
(page loaded in 1.298 seconds)
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
14236 articles. 
1 followers. 