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 |
|
wardsan
Starting Member
48 Posts |
 Posted - 2004-11-18 : 10:43:36
|
| Folks,I have a database that has not been in use for some time, there is currently no activity on the database, yet the transaction log is occupying 30MB. I have backed it up and attempted to shrink the file but it stays at 30MB, I just don't get it. Can anybody tell me why? There are no sessions on this database.ThanksSandra |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-11-18 : 13:13:54
|
| How big is the data file? 30 MB doesn't sound that big?Is this 2000 or 7.0?-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
wardsan
Starting Member
48 Posts |
Posted - 2004-11-19 : 04:12:50
|
| The log is currently 33Mb and it's not large. I don't understand why there is anything in the log though. I am going to restart the sql server services but I'd like to understand why the log has this size.thanks for your help |
|
|
|
|
|
|
tlog space