• Apparently, you can use this on a full backup also. This can be used when migrating a database to a new server.

    Perform the full backup with norecovery - at the end of the backup, the database will not be available for use.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs