Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sphilp
Starting Member
2 Posts |
 Posted - 2003-07-22 : 21:26:41
|
| I'm new to SQL Server in general and Log Shipping in particular, but haven't found any documentation that might cover the failures I'm seeing in setting up our particular log shipping application.We have three servers. Two of those servers are production databases, each for a single faciltiy. We would like to have each of those servers log ship to a third server for reporting.I am able to successfully run log shipping from a single server to the reporting server. When I configure and start the second server, I immediately begin receiving failures from the Restore job on the first server. I have tried swapping which is first to see if it's a particular server, but still receive Restore failures from the "first started" job.I've searched the Microsoft knowledge base and the multiple reference manuals I have available, but have found nothing that mentions a limitation against two servers shipping to a single third server.The production servers are Windows 2000 Advanced Server/SQL Server 2000 Enterprise Edition. The reporting server is Windows 2000/SQL Server 2000 Enterprise Edition. All have been patched to Service Pack 3 for both Windows and SQL Server. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-07-22 : 22:44:12
|
| Are you trying to apply the logs to the same database?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sphilp
Starting Member
2 Posts |
Posted - 2003-07-22 : 23:22:29
|
| No, they are different databases. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-23 : 12:20:39
|
| Log shipping is not limited to two servers, three servers, four servers, etc... What is the error that you are receiving on the restore job? The error will either be in the job history for the job or in the SQL Server Error log.Tara |
|
|
|
|
|
|
Log Shipping from multiple servers fails