title: Tail log backup message warning before restoring a backup
body: <p>SSMS 2012</p>
  
  <p>Production server
  Production database has Full recovery option.</p>
  
  <p>I want to take a copy of this and restore on to same server with different name.</p>
  
  <p>So I have taken a backup and choose restore but there is a message in the top left corner of the dialog which reads:</p>
  
  <blockquote>
    <p>a tail-log backup of the source database will be taken...</p>
  </blockquote>
  
  <p>Additionally, at this point I would rename the destination database, make sure that  the rename has renamed the mdf and ldf files and that would be good to go.  In this case it hasn't renamed the files so it looks like I will have to do that manually so as not to overwrite the prod database.</p>
  
  <p>I haven't dealt with full recovery databases before.  So questions: </p>
  
  <p>What does the tail-log message mean and what are the implications?<br>
  Why did the destination database Rename not rename the mdf and ldf files - that's pretty dangerous huh?</p>