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:53 am

    #2012569

    Lynn Pettis - Tuesday, November 6, 2018 9:42 AM

    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.

    Yes, but why make it the default to take a tail log backup... just because I'm restoring a copy of another database, doesnt mean I want that one taken offline.  In my case, I'm usually making a copy and keeping both online.