MRMS 2.0 - BACKUP

Hi All,

Is there a way to schedule and take backups of outlets (Store Manager) in MRMS 2.0 automatically.

Thanks in Advance

RK

Reply to
RK
Loading thread data ...

Do a search in the newsgroup for Backup and you will find plenty of information that has been posted previously.

Reply to
Michael

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:

Reply to
Mirek/ Slowey S

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.