March 6, 2009 at 6:18 pm
I have a database running on my SQL 2005 server. anytime a user enters data by select into, the transaction log grow to 100 GB. i was wondering, how can i disable the txn log to grow for this specific transaction?
Appreciated any input.
Thanks,
March 6, 2009 at 7:46 pm
When does the transaction take place?
If it is once in a while like a after hours? Then you can change the recover mode to Bulk-Load and then change it back to Full. Note though during that time then you cannnot have point-in-time recovery.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 7, 2009 at 1:50 am
California (3/6/2009)
I have a database running on my SQL 2005 server. anytime a user enters data by select into, the transaction log grow to 100 GB. i was wondering, how can i disable the txn log to grow for this specific transaction?Appreciated any input.
Thanks,
Switch your recovery model to Simple if you don't need point -in-time recovery. If your business does not allow, then as Mohit suggested change the recovery model to Bulk Logged Recovery model so that these transactions are minimally logged and then change the recovery model to Full. Make sure you take a log back up after this operation and also regular transaction log backups.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply