Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Moving All SQL Server 2008 databases to a new San storage Expand / Collapse
Author
Message
Posted Friday, March 15, 2013 4:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 5:42 PM
Points: 2, Visits: 39
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.
Post #1431439
Posted Friday, March 15, 2013 4:48 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:37 AM
Points: 5,143, Visits: 4,939
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




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1431449
Posted Friday, March 15, 2013 5:40 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:21 PM
Points: 5,975, Visits: 12,883
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?


---------------------------------------------------------------------

Post #1431477
Posted Friday, March 15, 2013 12:50 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 5:42 PM
Points: 2, Visits: 39
I'm want to move everything to the new san and remove the old san.
Post #1431687
Posted Friday, March 15, 2013 3:13 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:21 PM
Points: 5,975, Visits: 12,883
for system databases see here

make sure you use the procedure for your version of SQL (I have presumed 2008)


---------------------------------------------------------------------

Post #1431785
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse