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 |
|
Zoma
Yak Posting Veteran
76 Posts |
 Posted - 2008-11-14 : 05:17:18
|
| Hi all!Does anyone know any command or query i can use to generate the Data File size and Log File (Total &Used) with dates for the Month like for the whole October frm the 1st. I had get the files sizes.(I used "DBCC SLQPERF (LOGSPACE)" But it does specify that this day the Log was this and this used...Any one please help... |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-14 : 05:18:31
|
You want different datafiles named after current month?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-11-14 : 05:26:53
|
| I don't think you can get a history of data file size,log file size etc. I'll like to know if there is a way though.Sp_spaceused should give you details for the most recent state though. |
|
|
|
|
|
|
Data Files and Log File Size