MRMS 2.0 - BACKUP

Posted by RK on November 30, 2008, 12:30 am

Please log in for more thread options

Hi All,

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

Thanks in Advance

RK

Posted by Michael on November 30, 2008, 4:54 pm

Please log in for more thread options

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

--
Disclaimer:

Always test any queries that modify data on a test database prior to running
on your live data to ensure the desired results.

Always back-up prior to running any SQL delete queries on your live data.

--

Regards
Michael
(Brisbane, Australia)

> Hi All,

> Is there a way to schedule and take backups of outlets (Store Manager) in

> MRMS 2.0 automatically.

> Thanks in Advance

> RK

Posted by Mirek/ Slowey S on December 2, 2008, 6:39 am

Please log in for more thread options

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:backupsbackup.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:backupsDATA-%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:

> Hi All,

> Is there a way to schedule and take backups of outlets (Store Manager) in

> MRMS 2.0 automatically.

> Thanks in Advance

> RK