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 |
|
dbist
Yak Posting Veteran
52 Posts |
 Posted - 2008-11-07 : 11:33:20
|
| What is the recommendation for moving databases to new disk with the same disk name ie Drive W: will stay W:? Detach/Attach or Backup/Restore. The new disks are aligned with 64k blocks, the old ones are not. Simply copying the db to new disk will/won't take advantage of aligned disks? Plus the new disks have more space. What is the best approach? Please help, thanks.Operating System: Windows Server 2003SQL 2005 Enterprise SP2 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-07 : 12:23:50
|
| Both Methods are ok.I would prefer Backup/Restore. |
 |
|
|
dbist
Yak Posting Veteran
52 Posts |
Posted - 2008-11-07 : 13:10:03
|
| would attach/detach take advantage of realigned disks? |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-11-07 : 15:54:53
|
| detach attach would be faster |
|
|
|
|
|
|
best approach to move dbs to new SAN