| Author |
Topic |
|
redlemur
Starting Member
8 Posts |
 Posted - 2008-07-29 : 17:15:18
|
| Can anyone explain to me what this means:"SQL Server migration includes elimination of free space as databases are converted to SQL2005."Why does free space get eliminated? What does that mean? Thanks a lot. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-30 : 05:06:53
|
| are you upgrading your server from sql server 2000 to 2005?ArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
VGuyz
Posting Yak Master
121 Posts |
Posted - 2008-07-30 : 05:21:16
|
| Are you migrating any other database into sql server 2005.? |
|
|
|
redlemur
Starting Member
8 Posts |
Posted - 2008-07-30 : 11:33:00
|
| Actually, I'm not trying to do anything with a server--I just want to understand what happens during the migration descibed here. When they say "elimination of free space" do they just basically mean that the process of changing a server to SQL will compress some of the data so there isn't excess wasted space?Or does it mean something else? Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
redlemur
Starting Member
8 Posts |
Posted - 2008-07-30 : 13:03:05
|
| That's all I have. Can you give your hunch about what it means? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
redlemur
Starting Member
8 Posts |
Posted - 2008-07-30 : 13:19:35
|
| lol....I'm an assistant for a technology writing firm, and I was just given the assignment to figure out what the "elimination of free space" means. Do you have an idea? Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-30 : 13:23:20
|
| I'm not aware of any elimination of free space when upgrading. I have not witnessed that in any of my upgrades. An important thing to run after an upgrade is DBCC UPATEUSAGE though as after an upgrade there can be a ton of inaccuracies for the indexes. Unlike previous versions, you only have to run DBCC UPDATEUSAGE once on an upgraded database. After that and on all new databases, the data is kept up to date.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
redlemur
Starting Member
8 Posts |
Posted - 2008-07-30 : 13:30:43
|
| Thanks, tkizer. Why is eliminating free space a good thing? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-30 : 13:32:50
|
| If I understod in what context this was asked in, I'd better be able to help. But I don't see any reason to eliminate it given the lack of information provided.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
redlemur
Starting Member
8 Posts |
Posted - 2008-07-30 : 14:31:23
|
| Why do you want to "shrink databases"? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-30 : 14:33:22
|
| 1. You shouldn't shrink databases unless absolutely necessary as the extra space was needed by some process, so if it runs again and needs that extra space, you'll receive a big performance penalty as the file now needs to grow.2. To reclaim disk spaceTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Need help understanding server migration