I am trying to delete all records in a talbel that has about more than 25,000 records in there. When i execute the SQL statement (delete from table), i have a transaction log full error. How does this problem solve? I know the transaction log needs to be increased, but until to how big that would not be a problem in the future. Thanks for your help.
All the transaction uses logprimary+logsecondary to the size of logfilsiz db
parameter.A transaction uses the log primary, if it need more then that it creates
log second file and uses it, once it uses all the log second then you will get
trasaction log full error.
As n_i told you , you can use it to set these sizes, remember that you can
change the number of log second dynamically , but not the other 2 parameters.
Also every time a database activate it creates all the primary log files, but
log second on demand.
I always try to fill my transaction in primary and only try to use second for