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 |
|
swekik
Posting Yak Master
126 Posts |
 Posted - 2008-06-11 : 21:38:00
|
| Hi, I need to migrate db,Im planning to use attach & detach option.Is there any cons in migrating the databases(32 bit,not clustered ,sql 2005) to databases(64 bit,clustered,sql 2005).What are the things do i need to take care of?what are the things do i need to do after the migration?Thank |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-11 : 22:05:05
|
| Make Sure you backup before you do that. |
 |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-06-11 : 22:38:24
|
| after the migration do i need to run any dbcc command or update statistcs????? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-11 : 22:45:03
|
| You can run to make sure its upto date. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-11 : 23:05:32
|
| Need rebuild index/update statistics. |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-06-11 : 23:12:07
|
| for database consistency i can use "dbcc checkdb",and for the update statistics on the database not on a single table?? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-11 : 23:19:54
|
| Need update statistics on all tables in all dbs. |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-06-11 : 23:29:57
|
| I saw in BOL.rebuild index & update statics commands are for a particular index and for a particular table or view only.After the migration of databases,what are the commands do i need to execute?Do i need to rebuild one index at a time only? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Migrating DB