Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JonEdwards422
Starting Member
1 Post |
 Posted - 2007-11-01 : 07:59:39
|
| Hi All,Apologies if this covers old ground but I am really stuck!I have a database build job that can run for up to 12 hours. The job uses a lot of temp tables and deals with a large amount of data. The database being built is a STAR schema and is set up for simple recovery and transaction log unlimited growth. Recenty more hard drive capacity was added to the box and I now have 130GB of free space on the drive that the database builds on. My problem is that the SQL build job will fail and report that the STAR log is full and that I should truncate the log, however there seems to be plenty of room for the log to grow into! Has anyone come across this before? I've posted this in the DBA section as I think this is more of a DBA type question that development based. Any ideas are hugely appreciated!Jon. |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2007-11-01 : 22:53:33
|
| Are you sure that the log file of this DB is located on the new drive which got space? If not you might need to add in another log file on that new drive. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-01 : 23:15:59
|
| What's growth rate? Keep in mind that file growth takes time, you'll get error if the app can't wait. One thing you can try is allocating log space in advance. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-02 : 05:08:21
|
| Is it TEMPDB (which is perhaps on a smaller drive) which is filling up perhaps? |
|
|
|
|
|
|
Database log full but lots of free space?