SQL 2005 Database issue

Question

Hi All, I have SQL 2005 (SP1) database of which is replicating to my target site having same configuration i.e OS = windows 2003 sp1 APP = SQL 2005 sp1. replistor = 6.2 SP4 SQL Module = 1.0.4 Problem: My data i.e MDF & LDF files are replicating properly to target site. During failover my database mount properly but users permmission in database are not getting replicated Secondly, during failback some of my database are not getting mounted automatically for that i have to restart the MSSQL Services and then it works fines. Regards, Sandeep

yito1 · Answer

Hi,Is 'User permission' an original user who set it to the database? Secondly, during failback some of my database are not getting mounted automatically for that i have to restart the MSSQL Services and then it works fines. I do not understand by this explanationFor cause investigation, please see log of RepliStor and SQLServer.Or, please write the log here.You will understand which problem it is.Yoshinobu

Replication Manager

Was this post helpful?