December 9, 2009 at 2:58 pm
Hi
I wanted to import couple of big schema from my production database to test version.
These schema contain huge number of tables with milions of records.
I used the import/export wizard and saved it as a SSIS package.
Then I executed it Manually and it failed with an error message saying trnsaction log is full.
Can you please provide me other possible ways of doing the same? Thanks.
I have to import/export two schema with selected tables. So i will not be use any backup or restore mechanism.
Thanks
Santosh
December 10, 2009 at 8:06 am
The problem is that the transaction log on your test server is filling up and you don't have autogrow enabled. You have a few options:
1. Manually resize the Transaction log so it will handle the transaction.
2. Set the Transaction Log to autogrow
3. Manually create the Export in SSIS using BIDS. Set the batch commit size to like 10000 rows and set the test database to SIMPLE recovery so that it can reuse space after committed transactions.
4. Use a linked server to do the transfer and batch it over with a backup log after each batch so that the transaction log can re-use space.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply