I'm looking for software that does SQL Server replication. The current replication software that we use replicates corrupted databases. Which really defeats the purpose of replication. Anyway, I'm looking for software that will recognize that the database being replicated has been corrupted. If this situation occurs, then the replication software should NOT replicate the corrupted database. Any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Anyone know of good SQL Server replication software?
- Thread starter hross2026
- Start date
Not meaning to be smart, but if I was you, I'd be more concerned about the cause of the corruption, rather than a way of replicating 'around it'. You seem to be rather accepting of the fact that the database is corrupting. Do you know or suspect why this is happening?
More the the point of your question, I would imagine that it is programatically possible to detect whether a database is corrupt, and trigger the replication only if this is not the case. How this is checked, I am not sure.
Recognising that I have not answered the question; I do think however that the focus of the attention should be on why you are getting the corruptions.
Cheers,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)
More the the point of your question, I would imagine that it is programatically possible to detect whether a database is corrupt, and trigger the replication only if this is not the case. How this is checked, I am not sure.
Recognising that I have not answered the question; I do think however that the focus of the attention should be on why you are getting the corruptions.
Cheers,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)
- Thread starter
- #3
We believe that the database corruption was due to drive fragmentation. Believe me when I tell you that I am not accepting of the database corruption. This was a very bad situation to be in. We are now running a defrag process once a week. However, after doing lots of research I found that there are several things that might cause database corruption, i.e. Virus Scanning software, any other 3rd party software, hardware failure. We want to be prepared for every possibility, therefore that is why I am looking for a tool that will not replicate database corruption.
OK. Try checking out the "DBCC CheckDB" statement in Books Online. This allows the integrity of the database to be checked, and possibly repaired. Subject to the found status, I'm sure that the replication can also be controlled from the DBCC environment.
At this point I'm a bit over my head, not being a professional DB Administrator. You might also try re-posting your question in the "Microsoft SQL Server: Setup and Adminstration" forum.
Good luck,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)
At this point I'm a bit over my head, not being a professional DB Administrator. You might also try re-posting your question in the "Microsoft SQL Server: Setup and Adminstration" forum.
Good luck,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)
- Status
Similar threads
- Locked
- Question
