I have two installations of SQL Server one a PDC and the other on a BDC.
Both are configured to use Named pipes and integrated security.
The problem is when I try to connect to theSQL Server on the PDC with Security Manager it stops the SQLserver service and gives the error below. When I restart the SQL server service and try to connect again it freezes and I have to forceably end the task which leaves the SQL Server service in an unstable state.
SQL Server Error
Msg 10025 Severity 9 State 0
Error: Possible network error: Write to SQL Server failed. Connection Broken.
OS Error 109 Connection Transact (GetOverLappedResults())
The event log has a number entries by SQLCTR60 all of which say:- DB-Library: SQL Server connection timed out
I checked up error 10025 and severity 9 in the Online books but it doesn't help.
Other than this there is no other problem with the SQLserver
None of this happens on with SQLserver on the BDC.
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days.
Lets' understand the Au…