Home Forums Article Discussions Article Discussions by Author Discuss content posted by Warren Campbell Caution about Restoring via SSMS v17 RE: Caution about Restoring via SSMS v17

  • November 6, 2018 at 9:42 am

    #2012564

    sqlfriends - Tuesday, November 6, 2018 9:26 AM

    Thanks for the article, that is a good reminder.

    Not sure why microsoft make the checkbox checked as default? why the source database has to be in nonrecovery mode?

    Thanks

    If you are taking a tail log backup of the database you don't want additional transactions being applied.  Defeats the reason for a tail log backup.