[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

High Availability of MS-Dynamics GP-10.0

Posted on 2011-04-21
12
Medium Priority
?
489 Views
Last Modified: 2012-05-11
Hi,

I want to implement high availability of an MS-Dynamics v 10.0 running on standard SQL-2000.

SQL Replication is not working.

Backup is manual

What other possible solutions I have?
0
Comment
Question by:yannis_r
  • 7
  • 4
12 Comments
 
LVL 2

Expert Comment

by:SQLSergentMike
ID: 35446074
Since 2005 you can cluster with two nodes.
0
 

Author Comment

by:yannis_r
ID: 35446079
Have you done it with MS-Dynamics specifically?
0
 
LVL 2

Expert Comment

by:SQLSergentMike
ID: 35446083
Sorry for being short what I meant to say was 2000 standard has no HA options like that. It isn't even supported anymore, I would suggest moving to at the very least 2005, preferably 2008 and just run dynamics in 2000 compatibility mode. You will be able to cluster then with standard edition. Otherwise your only other option is to upgrade to enterprise edition, which again isn’t supported anymore.


0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:yannis_r
ID: 35446086
The question remains: Have you any working epxerience MS-Dynamics on SQL2005 or newer?
0
 
LVL 2

Expert Comment

by:SQLSergentMike
ID: 35446093
Its in on one of our older production clusters right now, SQL 2005 EE 64bit.
0
 
LVL 2

Expert Comment

by:SQLSergentMike
ID: 35446097
I currently support about 1200 SQL databases, and 60 instances of SQL Server versions 2000 to 2008 R2 most are clustered.
0
 

Author Comment

by:yannis_r
ID: 35446099
and what methodology you use to keep the cluster nodes synchronized?
0
 
LVL 2

Expert Comment

by:SQLSergentMike
ID: 35446124
Oh you don't have a SAN. I understand what your trying to do now, your trying to replicate the data without shared disk. You can do this but you will need a third party tool to keep the nodes in sync.
0
 

Author Comment

by:yannis_r
ID: 35446134
actually I have a server in Ohio and a server in Texas.  I want to syncronize them on a scheduled mode (every 15 minutes for example) Ohio will be thw main one while Texas will be thr DR (Disaster recovery) server.

In case I lose the main server at Ohio,  i want to repoint all users to Texas.

That's what I want to do.

so again the question is; Have you done it?
0
 
LVL 2

Expert Comment

by:SQLSergentMike
ID: 35446164
Log shipping would be the best way to accomplish your objective. I just finished doing this for my past client between Texas and Michigan on untrusted domains, and actually I am doing this again for my current client between our Salt Lake Data Center and our Eagan data center to achieve N + 1, are you facing some challenges with SFTP through the firewall, and custom log shipping routines?
0
 
LVL 2

Accepted Solution

by:
SQLSergentMike earned 2000 total points
ID: 35446222
What I ended up doing for the Texas to Michigan Log shipping solution is created a database to track the restores, and keep the LSN numbers, file location, date downloaded from the SFTP site, time unzipped, and location of the unzipped backup files. Then I had a scheduled job, that executed a couple of custom stored procedures that checked the SFTP site for new backups, if there were new backups, it downloaded them, unzipped them and applied them in the order they were created.
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question