We are using MS POS in conjunction with MS Office Accounting Pro and we would like to automatically back up our POS database nightly after the shop closes (say midnight).
Is this possible?
M Kalmus
- posted
16 years ago
MS POS (Not RMS) How to backup db automatically?
Loading thread data ...
- Vote on answer
- posted
16 years ago
- Vote on answer
- posted
16 years ago
- Open Notepad and enter the following: (also backup master database)
osql -U sa -P -S ServerName -Q "BACKUP DATABASE databasename TO DISK 'e:\backup\back1.bck'" osql -U sa -P test -S Robbert\TEST -Q "BACKUP DATABASE TESTDB TO DISK = 'C:\TESTDB.bck'"
- If you have a password for the sa user you will need to enter the password after the -P parameter in the above statement.
- Replace ServerName with the name of your server which can be found in the SQL Server Service Manager.
- Replace databasename with the actual name of your store or HQ database.
- Replace 'e:\backup\back1.bck' with the valid path to the directory and drive of your choice.
- Use Windows Scheduled Tasks to run this file (after you save it as .bat file) from the Server whenever you would like. Scheduled Tasks is found on most Windows machines under Start | Programs | Accessories | System Tools.
- Move the backup file to another location once the backup has completed or before the backup is scheduled to run again.
NOTE - Each time this is run the filename will be the same name entered for the path and filename within the Backup statement. You should also add a delete line in the batch file before the backup. Otherwise you backup will just keep doubling in size.