September 23, 2002 at 9:24 am
Hello. I've a problem with our log file. I want to import data in an Excel file to our database. The Excel file has all of the cities of the states so it has around 25000 rows. I tried to import usind DTS Import Wizard. Everything was fine while importing but after around several thousand rows has been imported the wizard gave a "log file full" error and quit.
What should I do for this? We're using this database for our website and we have limited data/log file size by our host.
September 23, 2002 at 9:29 am
Is your log file set for automatic growth? As you insert into your log it will continue to grow. If this is the reason, then allow sufficient space. If you have run out of diskspace then you have a problem.
Is the Data backed up often? If not and you have limited space, you could try a backup and see if that free's up enough space on the server to perform the import.
The other scenario is increasing the size on your host's server.
Clive Strong
September 23, 2002 at 9:29 am
One option would be to batch up your imports into pieces, say 1000 records. This would require less log space per batch, then one large batch.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
September 23, 2002 at 9:46 am
Greg Larsen: Thanks I will try this.
cstrong: I don't know about growth but what I know is we have limited space allocated and if we were to us more space our host will bill us for that extra space. So we have to find a way to do this without passing the filesize limit.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply