October 5, 2012 at 3:13 am
Hi All
I have log shipping running between 2 servers, I have chosed to run the restore job in Standby mode. I've noticed that it creates a tuf file after the restore job has completed.
What is the purpose of this file? I've tried to look around for an answer but it doesn't seem to make sense.
Also, what is the difference if I choose to restore with NORECOVERY instead?
Thanks
October 5, 2012 at 5:07 am
It's the undo file that is needed to keep the secondary server in the read-only state and if you use the norecovery instead, you wouldn't have that file on the secondary server....
October 5, 2012 at 5:13 am
TUF file is created when configuring log shipping in Standby mode.All uncommitted transactions are recorded to the TUF file while restoring the log backup into standby database so that users can read the database. And in next log backup, server will fetch all uncommitted transactions from undo file and check whether committed or not. If committed, those transactions will included in the log backup else it will be remain in TUF file.
October 5, 2012 at 5:17 am
Be very careful with this file, because unlike the actual database files it can be deleted accidentally, once that happens you'll encounter issues with the LS scenario.
ACL the folder where this file lives so that users cannot delete it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply