• So I have a question then... since the TSQL command BACKUP DATABASE documentation says "SQL Server backs up enough of the transaction log to produce a consistent database when the backup is restored", is this an inconsistency between the TSQL command and the PowerShell command?  What happens when you restore a backup taken by the PowerShell command  and someone forgot to also do a backup of the transaction log from a FULL recovery mode database?