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 |
|
tanu
Yak Posting Veteran
57 Posts |
 Posted - 2009-07-29 : 15:56:54
|
| I want to know about the best practices of migrating database server to New SAN Box.Do we need to stop services before doing that?One day I realized that the backup job didn't run so I tried to runit manually but everything was so slow and other job were failing too.Then I talked to the server person and he was in the process of migrating database server to new SAN Box. It was sunday night though.It took 12 hours before everything came back to normal. |
|
|
wshawnmelton
Starting Member
17 Posts |
Posted - 2009-07-30 : 14:52:11
|
| It depends on the uptime requirements you have from the users. Are you talking about moving the databases to SAN or moving the server itself to a new server with SAN storage?w s melton |
 |
|
|
tanu
Yak Posting Veteran
57 Posts |
Posted - 2009-07-31 : 09:32:01
|
| Moving the server to new san box. |
|
|
|
wshawnmelton
Starting Member
17 Posts |
Posted - 2009-07-31 : 09:47:22
|
| Getting best practices would be good, but I would be more concerned with why he moved the server to begin with (performance issues, hardware errors, hardware upgrade, etc). Then why he decided to start this little project on a Sunday night.Anyway...just moving an SQL server to another server (physical or SAN) is pretty much the same processes. You can do it different ways and there are many documents online on the different methods. The method you choice depends on the window you are given to complete it. I prefer to dettach the database and copy the files to the new server. Then get the user's set back up on the new server and confirm connections. Then on final switch over just restore the latest backup to the server to bring the data up to date.w s melton |
|
|
|
tanu
Yak Posting Veteran
57 Posts |
Posted - 2009-07-31 : 11:12:22
|
| We had to move all the servers to new SAN box and this one is the last one to move. To move database server it took more than 12 hours.Would it be faster if he would have moved it after taking it off line?Our Transaction log files were huge, but afte resarting the database and doing backups thnorey are normal now. |
|
|
|
sawag
Starting Member
5 Posts |
Posted - 2010-08-28 : 16:45:35
|
| Hi,We also want to move the SQL Databases on new SAN and want to remove old SAN. we have two SQL 2005 in cluster environment. Will you please guide me which procedure did you follow in order to move only the databases on new SAN?thanks, |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Migration of database server to new SAN box