• ..Something came up my mind this morning..

    Suppose a transaction was started before the backup process starts, only one transaction for example.

    Backup process back up the pages.. transaction is still open..

    But before the backup completes the above said transaction commits/Roll Back.

    So backup will also include the part of LOG for "Roll forward/Roll Back" while restoring the database.

    Now my question is that, backing up the LOG is an overhead here is it ? So if I disconnect all the users before the backup starts, ensuring there's no any transaction open which may or may not commit before the backup process ends, would it have been more faster ?. (I know I just can't disconnect all the users ofcourse ! 🙂 )

    Thanks.