Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why, why, and why?
Message
 
À
23/02/2004 20:08:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00877841
Message ID:
00880140
Vues:
24
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."
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform