April 1, 2006 at 7:42 am
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.
April 3, 2006 at 10:41 am
Do you have the truncate (remove unused space) on in your maintenance plan?
Sure you do the same type of backup (full, differential,...)?
April 3, 2006 at 12:07 pm
Are you sure it's backing up what you expect it to be backing up? Maybe it's missing something.
-SQLBill
April 3, 2006 at 12:10 pm
Jo,
The answer is Yes. what is the tsql command to do the same?
April 4, 2006 at 10:11 am
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