August 2, 2001 at 5:32 am
Hi all
Ive found recently that the transaction log file for a database will NOT extend (even though auto extend is enabled) when a single transaction that is running hits the end of the log. I mistakenly thought that SQL*Server will extend the log when a space request failed. But if its the only transaction running, it seems to me that SQL*Server does not do the check and fails the transaction with the error.
Can anyone explain "when" sql*server decides on when to extend its trans log?
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 2, 2001 at 6:05 pm
No idea! Never ran into that problem. I'll do some looking and maybe try to duplicate.
Andy
August 3, 2001 at 8:29 am
Is this a single huge bulk insert with bulk logging turned on?
August 3, 2001 at 9:19 pm
Hi there
No it wasnt actually, and this is why it supprised me. It was a single massive query over 14 tables.
Cheers
Chris.
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 7, 2001 at 3:26 pm
What was the error that it returned? If you could give me the exact number and description, that would be most helpful.
Also, what version of SQL Server are you running?
Thanks,
Sean
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply