Detaching/Re-Ataching all DBs in a SQL 2K Enterprise

[magicrjm]

I have taken over a network where the previous sys admin put the company's critical SQL DBs on a RAID 6 SAN drive array. The OS, SQL Binaries, and Paging file are currently on a RAID 1 on a Blade. The Data, TempDB, Logs, and TempLogs are all on one RAID 6 array SAN via iSCSI to the Blade. The RAID 6 array is on Ultra320 SCSI hard drives. With this configuration we obviously are not able to utilize the drive array to get optimal performance from our SQL Databases. I have (2) 30GB databases and (1) 140MB database on this array that are critical to the company. I want to move all the DBs off the array, then re-configure the drive array as follows: (4) drives in a RAID 10 for Data and TempDB, and (4) drives in a RAID 10 for Log and TempLog. I only have 8 drives to work with. I'll then run my backups to the opposite drive arrays. My question is how to move all the SQL databases including system DBs, then move them all back after I re-configure the drive array. I then will have to follow procedures to move the transaction logs, tempdbs, and templogs. I found the MS article 224071, but I did a trial run and found that the article is missing some procedures when detaching all the system DBs. I really don't have a clear understanding of how to detach all DBs in an Enterprise then put them all back. There is a certain order you must follow when detaching/re-attaching and articles that I found don't expect that you are actually moving all the DBs in an Enterprise. Can anyone point me in the right direction?

By the way I'm using SQL Server 2000 Std.

 

[Mich]

See if this helps.

http://support.microsoft.com/kb/314546

-If it ain't broke, break it and make it better.

 

[magicrjm]

Mich,

Thanks for trying but the second paragraph rules out what I'm trying to accomplish right away:

"The steps that are described in this article assume that you will not move the master, model, tempdb, or msdb system databases."

I need to move those databases (the system databases).

 

[JayKusch]

This KB may be of more interest and help ...

http://support.microsoft.com/kb/224071

Thanks

J. Kusch

 

[magicrjm]

I found this article:

http://www.myitforum.com/articles/18/view.asp?id=4077

Can anyone confirm these instructions?

 

[magicrjm]

I found a great link to accomplish this. Here it is:

http://www.sqlservercentral.com/articles/Administering/movingsystemdatabasesachecklist/1608/

 

[JayKusch]

At the bottom of that article, the authors states

"Most of the steps here come from the Microsoft article Moving SQL Server databases to a new location with Detach/Attach, which will probably help you more than this list."

Which is the exact link I gave to you.

Have a great weekend!

Thanks

J. Kusch