Home Forums SQL Server 7,2000 Administration spaceused RE: spaceused
MVDBA (Mike Vessey)
SSC-Insane
Points: 21797
More actions
March 22, 2006 at 9:01 am
#628130
if i could suggest something-
can you run the command DBCC SQLPERF(LOGSPACE) and paste the results back
if you need to claim space back it might be wise to claim it back from the log and not from the data file which looks correctly set up.
MVDBA