i've created software supposed synchronize data between 2 databases in sql server. program tested as able while having limited amount of data , limited time. need make run , want play safe.
what best approach able recover if goes wrong , database gets corrupted? (meaning not usable original program)
i know can backup both databases each time perform sync. know point in time recovery.
are there other options? possible rollback changes made sync service? (both databases going used other software)
you have, suggest investigating backup , recovery options available in sql server. since have no spec, don't know how system going behave against these changes, leaving higher likelihood of problems. reason (and many other obvious reasons) want have solid sql backups/recovery process in place. unfortunately express isn't in automating area, can run them manually before sync.
at least, make transactional; failure in program should not leave databases in partially sync'd state.
too bad don't have full version of sql server... might able use replication services , eliminate program altogether? ;)
Comments
Post a Comment