maint plans vs sql backup command

  • does anyone know why the maint plan .bak backups are so much smaller in kb than using the sql command backup database file=.....

    the disparity is huge in favor of the maint plan.

    any info is appreciated.

  • Do you have the truncate (remove unused space) on in your maintenance plan?

    Sure you do the same type of backup (full, differential,...)?

  • Are you sure it's backing up what you expect it to be backing up? Maybe it's missing something.

    -SQLBill

  • Jo,

    The answer is Yes. what is the tsql command to do the same?

  • You can shrink the database (reclaim unused space) with

    DBCC SHRINKDATABASE

    DBCC SHRINKFILE

    See the books online for more information.

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

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