Error in Client copy
We got a problem during client import because of the transaction log being full.We observe that the transaction log space in initially at 95 % free but when we start the import job its keep on growing drastically and reaching its maximum available size before the import completes.
Is there any way to switch off the transaction log temporarily during the import job ? we are running on SQL 2005 , ECC 6.0.
I got following command from some forum ( sp_dboption QAS, 'trunc. log on chkpt', false )
(sp_dboption QAS, 'trunc. log on chkpt', true* )*
which says these SQL queries would switch off the changes recording on to transaction log. i dont know whether this would work on SQL 2005. Please let me know the way to fulfill my requirement.
Any quick replies would much appriciated. Please help me to fix this issue.
Thanks & Regards,