[douglasluck]

I upgrded to the sp2 to sp3 (mr4) my database backup, normally it was 1.5 gb but now it is growing each day now its 4gb afetr 14 days

I can see in the event viewer "pages dumped" getting bigger and bigger.


Database backed up. Database: BESMgmt, creation date(time): 2008/08/28(18:05:42), pages dumped: 188194, first LSN: 229580:1205:173, last LSN: 229580:1511:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\MSSQL\MSSQL.1\MSSQL\Backup\BESMgmt_backup_201 109082101.bak'}). This is an informational message only. No user action is required.


Database backed up. Database: BESMgmt, creation date(time): 2008/08/28(18:05:42), pages dumped: 253602, first LSN: 232769:1981:148, last LSN: 232769:2278:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\MSSQL\MSSQL.1\MSSQL\Backup\BESMgmt_backup_201 109192101.bak'}). This is an informational message only. No user action is required.


Database backed up. Database: BESMgmt, creation date(time): 2008/08/28(18:05:42), pages dumped: 508570, first LSN: 237771:1596:192, last LSN: 237771:1817:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\MSSQL\MSSQL.1\MSSQL\Backup\BESMgmt_backup_201 110022102.bak'}). This is an informational message only. No user action is required.

anyone know why sp3 mr4 might be increasing my database size. some new function i need to disactivate.

[zemberster]

Hi, I'm not sure but the problem may be with the backup configuration. When you will try to restore the bigest backup file. You probably will see that you will have choice between a few wersion of backup not just last.