none
.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

     

     

     


    SNIVAS
    Wednesday, June 23, 2010 6:59 AM

Answers

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

    http://sqlserver-qa.net/blogs/tools/archive/2007/11/12/what-is-the-significance-of-tuf-file-in-log-shipping.aspx


    Best Regards, Uri Dimant http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/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
    Moderator
  • 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


    SNIVAS
    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 http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Wednesday, June 23, 2010 8:37 AM
    Moderator
  • 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?

     

     

     


    SNIVAS
    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 http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Wednesday, June 23, 2010 9:21 AM
    Moderator
  • Thanking you very much Uri Dimant  for your greate help


    SNIVAS
    Wednesday, June 23, 2010 9:32 AM