March 15, 2013 at 4:27 am
Hi,
Please we need you help and advice.
We want to move all of the SQL server 2008 databases files to the new SAN (Active Passive Mode ). The SQL server machines will not be changed just we need to move the databases to the new installed SAN.
1. What are the thing that we should consider?
2. What steps need to follow in such case?
Kind regards.
March 15, 2013 at 4:48 am
So you have new SAN drives presented on your existing servers and you want to move files say from drive D to drive Z on the same server?
If so, ALTER DATABASE dbname MODIFY FILE (logicalname, newfilelocation)
ALTER DATABASE dbname SET OFFLINE WITH ROLLBACK IMMEDIATE
Copy files from old location to new location
ALTER DATABASE dbname SET ONLINE
March 15, 2013 at 5:40 am
as anthony said but I would stop the apps first and take backups of all the databases.
also, are you moving just user databases or system databases as well?
---------------------------------------------------------------------
March 15, 2013 at 12:50 pm
I'm want to move everything to the new san and remove the old san.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply