• when i perform transaction log backup which is in format:

    backup log databasename to disk='path.trn'

    When we perform transaction log backup regularly it size get smaller and in full backup we do "with init" i.e. overwrite OR 'with noinit" i.e. append.

    My main motto is in express edition how to schedule transaction log backup using Windows task scheduler which will be scheduled and using batch file in which all command will be present.

    thnx...........reply