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 |
|
pradeep_iete
Yak Posting Veteran
84 Posts |
 Posted - 2010-02-11 : 14:18:39
|
| Suppose i have a mdf (50GB) and ldf on Machine 1 one on which window server 2003 is installed.Now i have shifed it to MAchine to where Machine has OS window Server 2008.I have restored it .Now my questions are1) the indexes and the data pages number are identical in both cases of same mdf.I mean below command when ran on two machine for same mdf will yield sme result or different.I have no option of doing that. DBCC IND ('DB!',<TABLE>,1) WITH TABLEOPTION |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-11 : 14:22:28
|
| The database is exactly the same after you have restored it (assuming that you are running the same SQL version on both machines).Same indexes, same statistics, same fragmentation, same filesize.Only think the old database has, which the new restored database does not, is whatever is in memory on the old server - query plan, cached data, etc. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-11 : 15:09:52
|
| I'll rebuild indexes after migrating database to new server |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-11 : 15:12:56
|
| Even if same Version, ServicePack, Hotfix on the new server? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-11 : 19:28:07
|
| yep. in OPs case, different OS too |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-12 : 03:12:43
|
| Interesting. What will a reindex do differently (to the original database I mean). Something here that I'm probably missing completely! |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-02-12 : 03:52:56
|
| Nothing.There's a need to update stats when upgrading SQL versions. When just moving DB from one server to another, restore puts it back exactly how it was on the original server, index fragmentation, table layout, everything. An index rebuild once on the new server won't do anything that an index rebuild on the old server wouldn't have done.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
Mdf& LDF issue