UNSOLVED
SQL 2005 Database issue
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
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
262 Posts
81
0
Posted March 25th, 2008 03:00
Is "User permission" an original user who set it to the database?
I do not understand by this explanation
For cause investigation, please see log of RepliStor and SQLServer.
Or, please write the log here.
You will understand which problem it is.
Yoshinobu