View Single Post
Old 10-04-2011, 10:27 AM   #1
douglasluck
New Member
 
Join Date: Oct 2011
Model: curve
PIN: N/A
Carrier: sfr
Posts: 2
Default Database growth / backup

Please Login to Remove!

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.
Offline   Reply With Quote