SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 05:56 PM
| ||||
| ||||
 alter table activate not logged initially hi, i found that in alter table command , you can do activate not logged initially to help not log any changes made to the table to log file, cause i have to delete almost 1 million records and my logfilsiz is 6120 pages, with 15 log primary and 20 log seconday, but still run with log file full error. but i also read that any error in the unit of work in which the not logged initially attribute is activate will result in the rollback, and the table is marked inaccessible after the rollback has occurred and can only be dropped, so is it a safe way to do the activate for production system? since i don't want the table being dropped.      |
Linear Mode
