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 |
|
maximus_vj
Yak Posting Veteran
88 Posts |
 Posted - 2004-07-23 : 13:56:46
|
| Hello,I just configured Log shipping with Primay, Seconday and Monitor servers. In my Monitor Server I see that my Primary and Seconday are in sync. And I can also see Backup History and Copy/Restore History. But the problem is this:I can see the trans backup file on teh primary in the backup folder. But I cannot see the backup file on teh secondary server any where. From what i read this file should be copied to the Secondary Server. Am I correct?Can anyone throw some light on this.Thanksmaximus |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-23 : 14:04:44
|
| Yes you are correct. Check the log shipping configuration to see where the files are copied to. The log shipping configuration would be the log shipping maintenance plan.Tara |
 |
|
|
maximus_vj
Yak Posting Veteran
88 Posts |
Posted - 2004-07-23 : 14:33:00
|
| Hi Tara,Thanks for your reply. I went to the log shipping maintenance paln properties. I went to the Log Shipping tab on the properties screen and selected the destination Server and clicked on Edit. And this opens up another properties window. And in the General tab the transaction log destination is C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP. But I went to the secondary server and went to this folder but I did not see any transaction log files. Is this destination folder supposed to be a network share?Thanks again,maximus |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-23 : 14:40:12
|
| Yes it needs to be a network share. So I believe you are copying them into the source folder, which isn't what you want.Tara |
|
|
|
maximus_vj
Yak Posting Veteran
88 Posts |
Posted - 2004-07-23 : 14:47:01
|
| Thanks a lot Tara. One more question .....My primary Server is in IL and Secondary Server is in CA. Both of them have different times. Does this cause any problems. Or it doesn't matter because whatever jobs that will be scheduled on each server is managed by its own SQL Server Agent.Does it make sense?Thanksmaximus |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-23 : 14:50:41
|
| Yeah it doesn't matter.Tara |
|
|
|
maximus_vj
Yak Posting Veteran
88 Posts |
Posted - 2004-07-23 : 14:53:53
|
| Thanks again! |
|
|
|
|
|
|
Log Shipping - Cannot see back up files