Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Possible problem in the documentation about the SQL Server Transaction log ( all versions 2008,2008 R2,2012 )

Answered Possible problem in the documentation about the SQL Server Transaction log ( all versions 2008,2008 R2,2012 )

  • Tuesday, February 19, 2013 9:16 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    In http://msdn.microsoft.com/en-us/library/ms190925(v=sql.110) ( part Transaction Log truncation ), in the note , i found

    "Log truncation does not reduce the size if the physical log file."

    I think that there is an explanation missing between "if the physical log file" and the dot marking the end of the sentence.

    I have discovered this possible problem as i was trying to help the original poster of

    http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/b59f2d9b-4e24-4d00-9364-29ae8a984e0e but i am fearing that the link will not be useful as the BOL is not complete.

    Please, is it possible for someone of the SQL Server Documentation Team to check whether it is a real problem and to post a fuller answer than mine on the thread i gave the link upper ?

    Thanks beforehand and have a nice day

    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

     

All Replies

  • Thursday, February 21, 2013 12:00 AM
    Moderator
     
     Answered
    Sign In to Vote
    1

    It's a very deceptive typo.  The sentence should read this way: "Log truncation does not reduce the size of the physical log file."   The statement, when corrected ('of' instead of 'if') is accurate.  I've updated the topic and it will be published next week.

    Kind regards,

    Gail

    Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

     
  • Thursday, February 21, 2013 9:05 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hello Gail,

    Thanks for your quick and useful ( or helpful maybe is more appropriate ) reply.

    My english is always poor and it is why i am always annoying the SQL Server Documentation when i am discovering problems like this one.

    Please, but what about the documentation for SQL Serve 2008 R2 ? Is it also possible to update it ? It would be very kind.

    Have a nice day and thanks....

    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.