Automate end of day procedures?

Also don't forget to "settle" your credit cards.

All of this is stuff "within" RMS to do - and as stated before, are really procedures to follow - no automation possible. Then after that you can do automation to do backups. You could either have one icon you click on to kick off the commands, or have it scheduled with windows task scheduler.

I have an icon they click (life boat) that kicks off a .bat file that does an SQL backup of the RMS database; then zips the backup for size reasons, then copies the zip file to 2 other networked systems as backup.

John,

Would you mind sharing the .bat file that you use to automate backups?

Thanks, John

"John M." wrote:

Pretty simple. Put this in a batch file:

DEL "F:\BACKUPRMS.BCK"

osql -U loginid -P mypassword -S databasename -Q "BACKUP DATABASE databasename TO DISK = 'F:\BACKUPRMS.BCK'"

xcopy "F:\BACKUPRMS.BCK" "\\SERVER\RMSBACKUPS\*.*" /Y

Change variables and adapt to your situation...

That's pretty much what I have. Only difference is that I also call a compression routine to compress "F:\BACKUPRMS.BCK" before I do the xcopy.

I also have "with format,stats" in the osql statement.