Lian Pretorius (4/1/2008)

---

Thanks Bessem,

There's also a report you can run from Management Studio for this info.

Unused space in my tables only add up to about 750MB (Againt a total of...

Preet (4/1/2008)

---

What sizes are the actual op sys files (mdf/ldf/ndf) ?

Do these correlate with what sp_spaceused is tellling you?

If the log file is huge run DBCC OPENTRAN to determine the...

i had issues like this with sql2000/sp4/cluster, and i think some of this problem may happen with sql 2005 before sp2, so i am not sure u have 2005 with...

thanks for replying

actually i do hese procedure but i don't know why usually it is not 100% success sometimes it fail and never restore.

if the collation changed between old server...