[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.

[tsac]

This looks like a SQL or server problem. You might check the Microsoft site for more info. A google search points to hardware issues.