gihrnm
asked on
How many databases can you mirror per instance?
I configured mirroring for 33 databases in an instance. Recently the mirroring failed and I found many network related errors like:
- Database mirroring connection error 4 '64(The specified network name is no longer available.)
- The Security System detected an authentication error for the server MSSQLSvc/servername:port. The failure code from authentication protocol Kerberos was "There are currently no logon servers available to service the logon request.
Mirroring timeout for each database is either 10 or 30 seconds.
- Database mirroring connection error 4 '64(The specified network name is no longer available.)
- The Security System detected an authentication error for the server MSSQLSvc/servername:port. The failure code from authentication protocol Kerberos was "There are currently no logon servers available to service the logon request.
Mirroring timeout for each database is either 10 or 30 seconds.
ASKER
can we relate the 2 errors related to resources overload? or they're just caused by network hiccups..
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome gihrnm
http://sqlcat.com/technicalnotes/comments/1102.aspx