Moving All SQL Server 2008 databases to a new San storage

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Moving All SQL Server 2008 databases to a new...

Moving All SQL Server 2008 databases to a new San storage

Rate Topic

Display Mode

Topic Options

Author

Message

Sami jaafar

Posted Friday, March 15, 2013 4:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 14, 2013 7:49 AM
Points: 2, Visits: 33

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

anthony.green

Posted Friday, March 15, 2013 4:48 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

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

george sibbald

Posted Friday, March 15, 2013 5:40 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 5,313, Visits: 11,298

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

Sami jaafar

Posted Friday, March 15, 2013 12:50 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 14, 2013 7:49 AM
Points: 2, Visits: 33

I'm want to move everything to the new san and remove the old san.

Post #1431687

george sibbald

Posted Friday, March 15, 2013 3:13 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 5,313, Visits: 11,298

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 »

Permissions