Hi all, Thank you. Does the size of the second rollback file depend on the size of database file or another issue? If the size of database file is 2MB, will the rollabck file also consume 2MB? Best regards, Kei
The size of the rollback file is equivalent to the number of 1K pages in the database file that you change within a transaction. Things that affect this include both data insert/update/delete, changing schema definitions, and any indexes that exist on data or schema that you change. If anything, the size of the rollback file has a *maximum* possible size that is the same as the database file (if you change every page in the file), but usually it is only a small fraction of the size. For example, if you are deleting one record, then the rollback file may take about 5K (wild guess). -- Darren Duncan
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
