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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-12 : 07:31:37
|
| jenny writes "I have read some materials talking about there is a Allocations window at SQL server Enterprise Manager to view the allocation of the log file. I just can't find it at my SQL server 2000. Please give me some clue. Thanks.Jenny" |
|
|
ralphs
Starting Member
8 Posts |
Posted - 2003-03-12 : 08:44:31
|
| Do you mean this?? in SQL EM click on DB then right click on the same DB, choose view -> taskpad, graphical allocation of the data and log device appears in the right window.///Ralph |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-12 : 12:34:28
|
| Or use sp_spaceused - not as friendly as EM, but it gives more information.Tara |
|
|
|
|
|
|
How to manage log file allocation by SQL server Enterprise Manager?