Log Shipping breaking daily on SQL Server 2005
- by IT2
I am facing a somewhat serious problem with Log Shipping on SQL Server 2005 and I am having trouble to correct it, so I will try some help from SF's experts.
I have a Windows 2003 Server (PROD) that ships transactional log backups to another two servers:
STAND1: Windows 2003 Server with SQL Server 2005.
STAND2: Windows 2008 R2 Server with SQL Server 2005.
The problem is that Log Shipping to STAND2 is breaking for ~ 90 minutes some times of the day and returning back without intervention. The breaking occur at times when the backup file is larger (after reindexing, etc). I can see the message below logged on the COPY job:
*** Error: The specified network name is no longer available
The copy agent was breaking dozens times a day only to STAND2 server, and after the changes below "only" breaks ~ two times a day:
The frequency of the backup job was changed from 5 minutes to 10 minutes.
Instead of backing up the 4 databases to the same folder, the log backups are now saved on separated folders for each database.
The backup job doesn't run 24hs now, and only for 14 hours a day, when people are working on the database.
I configured the SQL Server instances on the three servers to limit the memory, leaving more memory to the OS.
Now I don't know what to do. Any help will be much appreciated! Thanks!