It’s been almost two weeks since my last post as we’ve been offline in Scotland (another photo post to follow – I owe you two now…) but now we’re back for the crazy Fall conference and teaching season. The latest installment of my regular Q&A column in TechNet Magazine is available at http://technet.microsoft.com/en-us/magazine/cc895648.aspx. This month I cover the following topics: Enjoy!
2024: the year in books
Back in 2009 I started posting a summary at the end of the year of what I read during the year and people have been
6 thoughts on “TechNet Magazine: October SQL Q&A column”
I am trying to find some good information of TUF file and what it really stores inside the file. Is there any good whitepaper or blogs.
I tried few but it hasn’t been explained much in detail
What is a TUF file? That’s not a standard SQL Server file extension (.mdf, .ndf, .ldf)
TUF stands for Transaction Undo File. It is the file extension used by convention when MS code creates standby files when restoring to Read Only/Standby mode, i.e. RESTORE …. WITH STANDBY = dbname_yyyymmddhhmmss.tuf
see http://technet.microsoft.com/en-au/library/cc966495.aspx
"Transaction undo file
File containing information regarding any modifications that were made as part of incomplete transactions at the time the backup was performed. A transaction undo file is required if a database is loaded in read-only state. In this state, further transaction log backups may be applied."
Never heard it called that before – it’s usually just called the undo file (and that’s what we used to call it in the SQL team too :-)
can you please tell me where TUF file will located(stored) in log shipping [which server(primary\secondary) and exact path]
If you don’t configure the location, it’ll likely be in the /Backup folder for the server installation.