Moving DB and Log files to a SAN

Question

Moving DB and Log files to a SAN

jsqldba

SSChampion

Points: 11257
More actions
December 8, 2008 at 8:12 am

#194731

Hello....quick question (I think)...
We are migrating a SharePoint database server (SQL 2005) to SAN storage. In what order to I move the variouos db and log files including the system databases? I know how to move user dbs with detach/attach but not clear on moving the system databases. In what order do I move these? Can they be done all at one time? Before reataching the user dbs I presume?
thanks in advance

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 1

Yes, you can. Please make sure that you have all correct paths before detaching/attaching databases. Also, make sure both have the same service pack and hotfixes.

jsqldba SSChampion Points: 11257 More actions · Answer 2

sounds good. can you (or anyone) verify that this is correct?

1) detach all user databases and copy to new SAN location

2) add -c -m -T3608 in startup params and stop restart SQL

3) detach model and msdb and copy to new SAN location

4) remove -c -m -T3608 in startup params and stop restart SQL

5) reattach model then msdb databases

6) add new SAN paths for master to startup params and stop SQL

7) copy master to new SAN location

8) restart SQL

9) reattach user databases on new SAN location

10) move tempdb to new SAN location

jsqldba SSChampion Points: 11257 More actions · Answer 3

i just had a brainfart -

would it work the same if we simply:

1) stop SQL Server

2) copy ALL user and system databases to new SAN location

3) remove local D: (logs) and E: (data) drives

4) map new SAN locations as D: and E:

5) restart SQL

Basically, this just swaps the physical drives from under SQL but the drive location names/paths stay the same. Or will this trip up SQL somehow?

sturner SSC-Insane Points: 22411 More actions · Answer 4

That way will work fine also. You'll just have to make sure those drive letters always auto-mount after reboot and before SQL server starts up.

The probability of survival is inversely proportional to the angle of arrival.

HanShi SSC-Dedicated Points: 33508 More actions · Answer 5

Vince Lacoboni wrote a nice article about moving the system databases, including scripts to do it...

see http://www.sqlservercentral.com/articles/Administration/2605/

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

jsqldba SSChampion Points: 11257 More actions · Answer 6

jsqldba

SSChampion

Points: 11257

December 10, 2008 at 12:26 am

#910106

awesome info .... thanks guys!

Jpotucek SSCoach Points: 18583 More actions · Answer 7

Can you accomplish the same thing with Backup and Restore?? I can find articles about restoring SQL Server 7.0 System Databases but not SQL Server 2000 and 2005 System Databases...