|
device_name | physical_name | description | status | cntrltype | size |
master | C:\MSSQL7\DATA\MASTER.MDF | special, physical disk, 4 MB | 2 | 0 | 512 |
mastlog | C:\MSSQL7\DATA\MASTLOG.LDF | special, physical disk, 0.8 MB | 2 | 0 | 96 |
modeldev | C:\MSSQL7\DATA\MODEL.MDF | special, physical disk, 0.6 MB | 2 | 0 | 80 |
modellog | C:\MSSQL7\DATA\MODELLOG.LDF | special, physical disk, 0.8 MB | 2 | 0 | 96 |
MyBackup | c:\temp\MyBackup.dat | disk, backup device | 16 | 2 | 0 |
MyBackup2 | D:\MyBackup2.dat | disk, backup device | 16 | 2 | 0 |
tempdev | C:\MSSQL7\DATA\TEMPDB.MDF | special, physical disk, 2 MB | 2 | 0 | 256 |
templog | C:\MSSQL7\DATA\TEMPLOG.LDF | special, physical disk, 0.5 MB | 2 | 0 | 64 |
|
|
Database Name | Log Size (MB) | Log Space Used (%) | Status |
LBOX | 0.7421875 | 60 | 0 |
msdb | 0.7421875 | 43.42105 | 0 |
lightbox2 | 0.7421875 | 36.31579 | 0 |
tempdb | 0.4921875 | 54.31935 | 0 |
model | 0.7421875 | 64.01316 | 0 |
master | 0.7421875 | 59.01316 | 0 |
|
|