• Jeffrey Williams-493691 (10/9/2010)


    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.

    thats a nice shout, I can see that as being a very good option when migrating databases.

    @badra

    The option is also used for the final log backup in logshipping when you want to swap the primary and secondary server roles.

    ---------------------------------------------------------------------