troubleshooting Question
SQL Server sync/mirror/replicate best practice
asked on
I am having an issue getting a backup SQL server setup for a mortgage database. It is a SQL database and it is for Calyx Point Central. I know Calyx Point Central uses a service to sync files outside of the database to links within the database. It also uses IIS 7 to be accessed. I do not think there are other services Calyx Point Central uses to access the database. I have issues getting SQL server mirroring setup with this setup.
Calyx Point Central administrators advised me their software does not support SQL replication. So I am trying to have the databases linked/mirrored and then change a few things if the main server is offline, like where the clients are pointed to.
Is there other alternatives to SQL server mirroring and having a pretty fast ability to get another SQL server online?
I have a 2nd/backup server with Server 2008 R2 on it. It has SQL SAerver 2012 Enterprise installed just as the main server. It also has Calyx Point Central all setup and I have been able to get Point Clients to connect properly.
Maybe I can have multiple full backups and transaction log backups happening throughout the day that are saved to the backup up server? Then it is a matter of restoring the database?
Or can I use Dropbox, Google Drive, or DFS Replication to have the SQL database constantly copied/updated to the backup server?
Or maybe there is much better mortgage software out there? :-)
Calyx Point Central administrators advised me their software does not support SQL replication. So I am trying to have the databases linked/mirrored and then change a few things if the main server is offline, like where the clients are pointed to.
Is there other alternatives to SQL server mirroring and having a pretty fast ability to get another SQL server online?
I have a 2nd/backup server with Server 2008 R2 on it. It has SQL SAerver 2012 Enterprise installed just as the main server. It also has Calyx Point Central all setup and I have been able to get Point Clients to connect properly.
Maybe I can have multiple full backups and transaction log backups happening throughout the day that are saved to the backup up server? Then it is a matter of restoring the database?
Or can I use Dropbox, Google Drive, or DFS Replication to have the SQL database constantly copied/updated to the backup server?
Or maybe there is much better mortgage software out there? :-)
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 2 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.