110
Hello everyone,
I am looking to find information on how everyone is handling their RMS DB Backups with SQL Express. All information is welcomed.
Thank you,
Wesley
*This post is locked for comments
The Best and easiest way i have found is to use
SQLBackupAndFTP utility
Its free for basic single store operations
It will backup and transfer / upload to network driver offsite servers, ftp etc.
Hello Wesley,
Thank you for your question.
Microsoft recommends that you make routine, scheduled backups of your SQL database. There is a Knowledge base article that describes setting up an automated scheduled backup of your SQL database.
Although it is written for the Microsoft Dynamics GP product, it applies to the backup of SQL 2005 Express, which is included with Microsoft Dynamics GP the same way it is with RMS.
You may read the Knowledge Base article here:
mbs2.microsoft.com/.../kbdisplay.aspx
Thank you,
Scott Wardzinski
Microsoft Dynamics RMS Support Engineer
Wesley, I found the simplest solution to work the best for us, that is a script (bat file) for the hq backup, then a script to upload it to Amazon S3. It has been very successful. I put the scripts on each POS. Then task manager to schedule it after hours.
Craig, is this possible on a machine that has both Store Operations and HQ installed?
I am assuming so and the second line would read :
osql -U sa -P Password1 -Q "BACKUP DATABASE store db name TO DISK='C:\BACKUP\Monday_POS.bck'"
for the store operations db
and
osql -U sa -P Password1 -Q "BACKUP DATABASE hq db name TO DISK='C:\BACKUP\Monday_POS.bck'"
for HQ.
So in the end I would have 14 batch files. Unless it's possible to do both Store Operations and HQ in the same batch file. ie:
del C:\BACKUP\Store_Monday_POS.bck
osql -U sa -P Password1 -Q "BACKUP DATABASE store db name TO DISK='C:\BACKUP\Monday_POS.bck'"
xcopy c:\BACKUP\Monday_POS.bck "\\BackOffice\BACKUP" /Y
del C:\BACKUP\HQ_Monday_POS.bck
osql -U sa -P Password1 -Q "BACKUP DATABASE hq db name TO DISK='C:\BACKUP\Monday_POS.bck'"
xcopy c:\BACKUP\Monday_POS.bck "\\BackOffice\BACKUP" /Y
Sorry my knowledge of batch files is fairly limited. Your help is appreciated.
Devon
Create a batch file with the following:
del C:\BACKUP\Monday_POS.bck
osql -U sa -P Password1 -Q "BACKUP DATABASE RMS TO DISK='C:\BACKUP\Monday_POS.bck'"
xcopy c:\BACKUP\Monday_POS.bck "\\BackOffice\BACKUP" /Y
Monday_POS.bck is the name of your backup for Monday. When you run the backup for a Monday you delete last Mondays backup first. The first line does this for you.
The second line specifies your sql password, name of your database, and where to back it up to.
The third line copies the file to another computer on your network.
Change all the values to whatever is appropriate for your installation.
Use Task scheduler to run each backup on the appropriate day. Create one for each day of the week.
Craig
I created a .cmd file that I set to run nightly through the Task Scheduler.
The .cmd file did the following:
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE" -U backup -P backup -i "C:\RMS_Scripts\database_bkup.sql"
And the .sql file was C:\RMS_Scripts\database_bkup.sql and did this:
BACKUP DATABASE [RMSDB] TO DISK = N'D:\Backups\RMSDB.bak' WITH NOFORMAT, INIT, NAME = N'RMSDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS=10
GO
Hope this helps!
To add to this. Are there any good references out there for RMS backup best practices?
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,401
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
