Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-10-26 : 01:58:24
|
| Dear Experts,i've taken a backup from one database(which is running on sql server 2000) 'X' and restored it in another database(sqlserver 2005) as 'X' with the same name.when i'm taking the backup, the size of the database is 59.63 MB (test database)after restoring the same in my local machine, on sql server 2005, it became 158.25 MB.why is this much of difference.....any architectural difference...?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-26 : 06:13:35
|
| This has come up before, so I don't think its unusual. Is the size differences in the MDL, LDF or both? Might be that the migration needed some log space for updates etc.After restore of SQL 2000 -> 2005 you need to change compatibility mode [assuming that you want 2005 compatibility] and then reindex / update statistics on everything.You may then want to do a one-time-shrink and see what size you are at then.See also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Migrating+to+SQL+2005+Hints+and+TipsKristen |
 |
|
|
|
|
|
database size differences