Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
NAV SQL Server DR Solution
stevodevo
Member Posts: 4
Hi All,
I'm running NAV 2009 SP1 on SQL 2008 SP1. I've been asked to come up with a disaster recovery solution for my company that will allow us to continue working in NAV should our primary SQL server fail in any way. We are very prone to power outages, weather etc.
I've been playing around with Amazon Web Services and have a SQL Server up there in 'The Cloud' that I'd like to use as our DR option.
What is the best option to sync the database between our primary site and the Amazon site? Our database is about 1GB in size, so just copying the full database over each night probably isn't the best solution.
I was thinking, log shipping or some type of replication. What works best for NAV?
Thanks for your advice.
Steve
I'm running NAV 2009 SP1 on SQL 2008 SP1. I've been asked to come up with a disaster recovery solution for my company that will allow us to continue working in NAV should our primary SQL server fail in any way. We are very prone to power outages, weather etc.
I've been playing around with Amazon Web Services and have a SQL Server up there in 'The Cloud' that I'd like to use as our DR option.
What is the best option to sync the database between our primary site and the Amazon site? Our database is about 1GB in size, so just copying the full database over each night probably isn't the best solution.
I was thinking, log shipping or some type of replication. What works best for NAV?
Thanks for your advice.
Steve
0
Comments
Assuming you have a dedicated highspeed WAN connection towards Amazon Web Services, Asynchronous Database Mirroring might be an option as well (depends on your transaction volume). You will need SQL Server Enterprise Edition for that, though.
Wouldn't this also impact access to the remote (backup) database? If your issues are as severe as you make them sound, why not just host NAV at a commerial site that already has DR capacity.
When I connect up via the NAV client, I don't see any of the new transactions (POs, Customers, SOs etc). Any ideas why? Like I said, the transaction logs are reporting as being backed up and restored just fine (no errors in the SQL Logs).
Those would seem to be conflicting statements.
Hopefully your post makes you feel like more of a man - I didn't see any useful information in there at all.
For some weird reason, when you set up Transaction Log Shipping, there is a tab in there called "Restore Transaction Log" and I have the job set up to "restore files from the destination folder by a SQL Server Agent job running on the secondary server instance". When I connect to the secondary server instance, I find the database there that the logs are being restored to that is in a Standby / Read-Only state.
Guess I've done something wrong, so maybe you could enlighten me with another comment?