Post reply

The default PoSh backup

  • January 23, 2017 at 11:37 pm

    #77446

    Comments posted to this topic are about the item The default PoSh backup

  • January 23, 2017 at 11:38 pm

    This was removed by the editor as SPAM

  • January 24, 2017 at 6:52 am

    #1924618

    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?

  • January 24, 2017 at 8:17 am

    #1924636

    Chris Harshman - Tuesday, January 24, 2017 6:52 AM

    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?

    The PoSh backup command uses the same method as the T-SQL backup database. A full db backup always includes some amount of log. It might be minimal, meaning no roll forward/back needed, but it's always there.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply