William,
I added an additional transaction log and at the same time put an extra job shrinking the database. It is now under observation...
>>It's already set to automatically grow.
>>
>>>Your log file is probably set to have a maximum size, which you have now reached.
>>>You need to increase that size. Or (in the latest versions of SQL server) set it to Automatically grow file.
>>>
>>>You can find these settings in the Enterprise Manaager, by right clicking on your database ( you will need to expand the SQL Server Group to reach it..),
>>>selecting Properties, and going to the Transaction Log tab.
>
>
>Hi - I'm assuming you got a good backup of your transaction logs now .
>
>Have you TRUNCATED THEM?
>
>what was physical size before and after ? in megs/gigs/kilobytes ?
>mondo regards [Bill]
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."