February 5, 2010 at 8:09 pm
In my environment there is an issue with Log shipping destination file path, I've to change the file path on the destination, I've changed and LS copy is working fine and LS restore is failing because it is trying find the .tuf file on the old path which is not exists on the destination.
I don't want to do full restore for 30+ databases, so I'm trying to update the .tuf path on msdb on destination server but I couldn't find out the path details on any of the log shipping system tables. I knew the last restored file path details can be found on dbo.log_shipping_monitor_secondary , dbo.log_shipping_secondary_databases tables, updating these tables not helping to resolve my issue.
Where is the .tuf file path details on msdb?
Thanks in advance...
Thanks
Jay
http://www.sqldbops.com
February 7, 2010 at 1:16 am
Try:
On Pri. server
select * from msdb.dbo.log_shipping_primary_databases
On Sec. server
select * from msdb.dbo.log_shipping_secondary
February 8, 2010 at 6:53 am
the .tuf file would be kept in the same location as .trn files on the destination server.
---------------------------------------------------------------------
November 28, 2011 at 3:22 am
Tuf file will not store in the database,exists at the file system level where you have specified by Manually, where we are defining the Transaction undo file to make the Standby/readonly mode on secondary database(note you have two types of restoring mode 1. WITH NORECOVERY 2. STANDBY/READONLY) for reporting purpose only.
Best Regards,
Rama Udaya.K
ramaudaya.blogspot.com
November 28, 2011 at 4:59 am
when you changed the path to the log files, did you copy the existing log folder to the new location after the config change, or did you delete the old directory without copying?
if you did, you have probably lost your TUF file unless its in the recycle bin, if you have lost it, then the only way I know to get it back would be to set logshipping up from scratch.
November 28, 2011 at 5:18 am
thread more than a year old!
---------------------------------------------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply