.TUF files not getting Deleted RRS feed

  • Question

  • Hello all

    .TUF files are reqiiured To keep Secondary server read-only .

    But when they will delete ?

    some body guide me  what is the mechanism...behind this .TUF files


    Thanks in Advance




    Wednesday, June 23, 2010 6:59 AM


All replies

  • TUF file is a Microsoft SQL Server 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

    Best Regards, Uri Dimant
    • Proposed as answer by sekhara shiris chinta Wednesday, June 23, 2010 8:41 AM
    • Marked as answer by SNIVAS Wednesday, June 23, 2010 9:29 AM
    Wednesday, June 23, 2010 7:37 AM
  • Thanks UriDimant 

    Today I verified in secondary server there are couple of .TUF files in the folder.

    How to delete those file manually or any Logshipping Job will delete those

    Wednesday, June 23, 2010 8:28 AM
  • Yes, when you remove log shipping it should be deleted,  do you observe something different?

    Best Regards, Uri Dimant
    Wednesday, June 23, 2010 8:37 AM
  • Once again thanks  Uri Dimant

    I don't found any failure in Logshipping Jobs,But I have almost Seven  .TUF files along with  .TRN files and all those files Past date I mean Three day back,seven day back..and a month  back.


    that means secondary  database not sync with Source Database?




    Wednesday, June 23, 2010 9:12 AM
  • No,no that means that SQL Server needs them to access the database in read only mode
    Best Regards, Uri Dimant
    Wednesday, June 23, 2010 9:21 AM
  • Thanking you very much Uri Dimant  for your greate help

    Wednesday, June 23, 2010 9:32 AM