SQL Server Performance Forum – Threads Archive
Log Shipping – Cannot see back up filesHello, 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.
I have noticed one thing. Whenever you get a log backup file on primary server, it doesn’t copy the file to the secondary server immediately. Instead, for the first time, it creates a .tuf file and when this is done, the file is copied to the secondary server. From then onwards, whenever .tuf file is updates, the file is copies to the secondary server. So wait, till .tuf file is created or updated. I don’t know if we can control the creation of .tuf files in anyway. HTH
Hello, I did search for .tuf files on my primary Server and I don’t have any. Is this file created in the Back up folder? Thanks
Yes, the file will be created in the backup folder. For me, it got created after around 15 minutes after my first transaction log was created.