Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transaction too large
Message
De
20/04/2007 11:29:29
 
 
À
20/04/2007 11:15:40
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
01218303
Message ID:
01218317
Vues:
16
>Recently , I find that there is timeout occur when runing 'select .
>statement'
>Some said the Transaction Log too large will make SQL become slowly
>
>Now, the transaction log is 14407M , is it too large ? Can I delete it ? (Do
>I need to do backup first ?)


Is it too big? Yes.
See "Truncating the Transaction Log" in SQL Server Books Online (BOL)


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform