Tag Info

New answers tagged

5

No different. Space Reserved for your MDF file: 100.21 GB, which is equal to 105,082,944 KB (105,082,944 / 1024 / 1024 = 100.21) Space Reserved for *_1.ndf: 148.62 GB, which is equal to 155,843,968 KB (155,843,968 / 1024 / 1024 = 148.62) The numbers match up just fine. The Operation System is going to see Space Reserved, and that's how you would need to ...


0

Maybe this is not an answer to your question but I believe it is relevant. I would write a comment if I could but I want to add the pictures and the script I used. I had the same problem while ago, I was getting the following error message while trying to re-attach a database: The way I sorted this out was impersonating the login used to detach the ...


0

This is a bit long for a comment so I'm putting it here. First try running this: exec sp_msforeachtable 'sp_spaceused [?]' Yes I realize it uses sp_msforeachtable and there are a number of better methods, this is just quick and hopefully "good enough". At a guess you have a heap (no clustered index) that has a large amount of "unused" space. I wrote ...



Top 50 recent answers are included