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 - 2006-08-16 : 09:35:21
|
| vaddi writes "I would like to get any script which gives me the data file and transcation log file size in sqlserver 2000. And also an script to find the capacites on the drives." |
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2006-08-16 : 09:40:37
|
| sp_helpdb masterYou will get like this:..................................................................name fileid filename filegroup size maxsize growth usage master 1 D:\MSSQL\MSSQL\data\master.mdf PRIMARY 102400 KB 204800 KB 100% data onlymastlog 2 D:\MSSQL\MSSQL\data\mastlog.ldf NULL 20480 KB 40960 KB 100% log onlySanjeev Shrestha12/17/1971 |
 |
|
|
schuhtl
Posting Yak Master
102 Posts |
|
|
|
|
|
Scripts to find data file and transcation file size