Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transaction too large
Message
From
20/04/2007 11:29:29
 
 
To
20/04/2007 11:15:40
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01218303
Message ID:
01218317
Views:
15
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform