February 14, 2012 at 2:24 pm
I used sp_spaceused to find the size of a database.
The results are:
DatabaseName Database Size Unallocated space
abc 591102.25 MB239057.52 MB
Reserved Data Index Size Unused
256965096 KB235494216 KB6245584 KB 15225296 KB
It's straight forward but I'm little confused if should consider my database size to be 591102.25MB or is it (591102.25MB-239057.52MB)=352044.73MB?
February 14, 2012 at 4:01 pm
the size of the files will be 591102.25 MB, actual space used in the database (i.e about the size a backup would be) is 256965096 KB
---------------------------------------------------------------------
February 14, 2012 at 4:23 pm
I'll be migrating this database to a 2005 server.
Can I truncate the unused space and then take a backup because I think the backup will take more time since it's size is 591102.25 MB?
February 15, 2012 at 4:07 am
the backup will be only 256GB.
Is this the database you are moving be detach\attach in thread
http://www.sqlservercentral.com/Forums/Topic1251467-146-1.aspx#bm1252191 ?
If so leave the file sizes as they are as you will not be moving the files in any way, just the whole lun.
If you need to get back the 350GB of empty space you could shrink the file but be aware this will fragment your indexes and you will need to rebuild them.
If you shrink try the truncateonly option first and do not shrink all the way down, leave some free space.
---------------------------------------------------------------------
February 15, 2012 at 6:08 am
Awesome!Thanks George. That answers my question.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply