Unsolved
This post is more than 5 years old
16 Posts
0
310
March 25th, 2008 00:00
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
No Events found!
yito1
262 Posts
0
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