Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Georgio
Starting Member
6 Posts |
 Posted - 2005-10-27 : 14:27:04
|
| Well..I am trying to grow the transaction log from the properties of my database... everything seems to be ok..But when i shring my database log.. the transaction log is returning to the previeus size.Why this?Please Help me.. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Georgio
Starting Member
6 Posts |
Posted - 2005-10-27 : 14:41:05
|
| When i run a big report.. my server is very very slow.The reason is this Transaction log.Tell me ..Why i have this option of growing the transaction log if i can't use it. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-10-27 : 14:46:53
|
| It is not your log. If you have performed maint, the size of the log will stay the same, but be empty. This is for performance reasons. Growing and shrinking LDF and MDF files is very costly.It is not your log.What do you mean when you run a big report?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-27 : 14:54:35
|
| What command did you use to shrink the "database log"?Tara |
|
|
|
Georgio
Starting Member
6 Posts |
Posted - 2005-10-27 : 15:03:11
|
| ok..I have a table that keeps auditing information since 1996.When i want to retrieve some informations from 1996 since now.. the transaction log is getting full.I calculate that if i grow the size of Tran.log 200mb i will be ok.Sorry i am new with SQL.. Thank you for your help.Georgio |
|
|
|
Georgio
Starting Member
6 Posts |
Posted - 2005-10-27 : 15:06:46
|
| Tduggan..I used the Enterprice Manager - left clic on my database - All Tasks - Shrink Dadabase.The only way i know.. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-27 : 15:10:33
|
| Using that method executes DBCC SHRINKDATABASE which shrinks the database files as you can see in SQL Server Books Online. Use DBCC SHRINKFILE instead.Tara |
|
|
|
|
|
|
Transaction Log