Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Nav 2018 SQL DB Replication possible?
meelan
Member Posts: 7
in SQL General
Hi
What would be best sql replication methods for Dynamics NAV 2018 database which the partner still uploads changes (objects including tables).
The DB is around 200GB and subscriber will also be in the same premises (different building)
I see snapshop, transactional etc. Not sure which one will work in this case?
What would be best sql replication methods for Dynamics NAV 2018 database which the partner still uploads changes (objects including tables).
The DB is around 200GB and subscriber will also be in the same premises (different building)
I see snapshop, transactional etc. Not sure which one will work in this case?
0
Answers
I my opinion that depends on what you want to accomplish.
Is this for reporting?
Is the for security/emergency ?
Is the for a TEST/DEV DB?
For reporting I have previous use transaction log shipping.
For Security/emergency you could have a look at a "Always on cluster"
It is for emergency, in case of primary server failure, we want to have maximum possible data recovered. This installation has some 100 users. Database is being backed up twice daily for the time being.
We use SQL Server Std.
I will look into the "Always On Cluster" feature. Needed to what methods most of us here uses?
Main confusion is the object (specially tables) changes the partner makes.
Thanks