Skip to main content

Notifications

Microsoft Dynamics RMS forum

RMS 2.0 Offline mode

Posted on by 145

We are in the process of testing RMS 2.0 with a view to deployment late summer. This will consist of a number of POS terminals connecting back to a SQL 2008 database.

We are looking at a possible scenario where the SQL server crashes or goes offline. Microsoft indicates that an Offline database can be set up to cover such instances but I have heard that this is buggy. Has anyone implemented this and have had such experiences? Is it worth implementing? (is a potentially buggy system better than none at all?).

I would love to know how others are implementing their disaster recovery processes.

 

Thanks!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: RMS 2.0 Offline mode

    I agree with Paul - it makes sense to use them.

    Domains, user access rights, different SQL versions between register and db host, the OS and firewalls are the main culprits for offline databases not synchronizing, but if your setup is simple (no domain, registers log on to windows automatically with full admin rights) you should expect no problems with offline databases.  If you set up users in windows or on a domain make sure the registry is edited to allow full rights to everyone on the POSUSER entry.

    Hope this helps....

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: RMS 2.0 Offline mode

    Just a point of fact

     

     I support about 95 RMS sites and about 35% have multiple regsiters. I Always setup the Offline database

    as you never know when the primary system will fail. It works great most of the time. We still take credit

    cards in the offline mode and there is never a big deal closing the blind close batches. As long as the offline

    system can get to the internet we keep selling to our customers with little or no problems as usual.

     

    Paul H.

    Eastern National

  • jos ange Profile Picture
    jos ange 50 on at
    Re: Re: Re: Re: RMS 2.0 Offline mode

    It does work ' sort of ' Here is the problem.

    • Like always NO Documentation, of how to handle the Automatically Blind Closed batche(s) and now Blind Open batches without Opening and/or Closing dollar amounts.
    • Every time this happens, and it will. It will take hours to try and figure out what to do with ALL of these batches and balance ALL of your cash drawers.  Then add in the time it will take because RMS cannot processes credit cards ( because it cant do a simple task like process Tips) and it will add to your nightmare. 
    • When this does happen to you 'Take NOTES' of everything you did to resolve the batch problems and settle. Beleive me, in 4 months from now when this happens again you will need them.

     

  • Simon Merritt Profile Picture
    Simon Merritt 2,270 on at
    Re: Re: Re: RMS 2.0 Offline mode

    We tested it, and have a had a couple of servers crashes and it works fine.

  • Alan Brown Profile Picture
    Alan Brown 145 on at
    Re: Re: RMS 2.0 Offline mode

    Thanks Simon,

    Have you tested this/had cause to use it (eg server crash)?

     

    Alan

  • Simon Merritt Profile Picture
    Simon Merritt 2,270 on at
    Re: RMS 2.0 Offline mode

    The offline database is easy to setup and to be recommended. As it will help you out if the database goes South.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans