60
Greetings,
Just registered and thanks for any and all help.
We are currently using the RMS programs for our stores and I'm looking to update the backup process for some of my lazier employees.
Specifically, I'd like to do a PS Script that would run the Backup for the RMS program. Optimally, I'd like it to auotpopulate with the $Date.
I'll start off by asking if anyone is aware of a command line prompt to run the Backup Utility?
*This post is locked for comments
If you get confused, or it doesn't work right for you, just post back and I'll help you fix it.
It's important that you don't just save it to the hard drive, but copy it to an external drive, and then to the cloud. Adding the external drive would make the file look something like this:
osql -U sa -P type_password_here -S type_server_name_have -Q "BACKUP DATABASE type_database_name_here TO DISK = 'c:\RMSbackup.bck'"
copy c:\RMSbackup.bck f:\Backup\RMSbackup.bck
exit
Note that F: is your external drive - modify as necessary. Also, create your folders before running the command - it won't create the folders, just the file. Also, I have a separate folder for each day of the week, therefore a different batch file for each day, e.g. C:\Backup\Monday\RMSbackup.bck, C:\Backup\Tuesday\RMSbackup.bck, etc.
Maybe this can get you started. Create a file called backup.bat and use scheduled tasks for it to run at a specified time. I also create subfolders for each day of the week and a mid-day backup. Also, I modify the script to copy the backup from the hard drive to an external drive. The mid-day backup should be uploaded to the cloud on a daily basis.
*****************************************************************************************************
--Enter the password, without quotes, the server name, without quotes (e.g., TONY-PC or TONY-PC\SQLEXPRESS), and database name, without quotes
--Personally, I would backup the data to C:\Backup or D:\Backup. But you have to create a folder called Backup FIRST!
osql -U sa -P type_password_here -S type_server_name_have -Q "BACKUP DATABASE type_database_name_here TO DISK = 'c:\RMSbackup.bck'"
exit
Ron Rahhal
Best POS Sales
We use this application... its excellent. http://sqlbackupandftp.com/
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (