Hi All,
Is there a way to schedule and take backups of outlets (Store Manager) in MRMS 2.0 automatically.
Thanks in Advance
RK
Hi All,
Is there a way to schedule and take backups of outlets (Store Manager) in MRMS 2.0 automatically.
Thanks in Advance
RK
Do a search in the newsgroup for Backup and you will find plenty of information that has been posted previously.
Hi Try this: Create *.bat file like below
osql -U sa -P database_password -S server_name -Q "BACKUP DATABASE database_nam TO DISK = 'c:\backups\backup.bck' WITH FORMAT, STATS
Then go to windows scheduler and simply add this to be run every day, hour or like you want.
You can also play a little bit with automatic names for files using something like: .... TO DISK = 'c:\backups\DATA-%date%.bck' WITH FORMAT, STATS what should give you filename: DATA-02/12/2008.bck ofcourse windows doesn't like "/" sign in names so you can go to regional settings and change date separator from "/" to "-".
Regards Mirek Wieclawski Slowey Systems Ireland
"RK" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.