| Author |
Topic |
|
steel
Posting Yak Master
107 Posts |
 Posted - 2010-06-23 : 01:47:43
|
| Dear Experts,We are having a production environment having HP proliant DL 380 servers haosting windows server 2003 SP2 and SQL2k5 with SP3.The logshipping is enabled for three databases.The server works ok but after some time it hangs .Please help.Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2010-06-23 : 03:02:53
|
| Thanks for replying..This server is deployed with 146GB*2 RAID1 and 300GB*4 RAID5.RAID5 contains song content which is being read by other mapped machines(Only read happens during this operation) and our logshipped db are also residing in this RAID5 volume.Whenever we are dissabling logshipping then this server works fine but when we enabled logshipping this server used to reboot and then goes into hang status(this sql server is not able to connect from other machine but we are able to telnet 1433 port). Then we need to give hard boot to this server to make it functioning.It directly indicates some issue with our logshipping setup.Please suggest. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2010-06-23 : 03:16:21
|
| This is the configuration of Secondary server which is also hosting some content.The main Database server is working fine. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2010-06-23 : 05:58:07
|
| We are having two servers with same configuration.The issue is with the secondary log shipped server.The primary server for log shipping is working ok but the secondary server for log shipping is working abnormally.We are having two seperate machines. |
|
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2010-06-25 : 07:58:46
|
| Dear Experts,Please help |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Server hangs with log shipping