October 16, 2008 at 9:37 am
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.
October 16, 2008 at 1:35 pm
I found this article: http://www.myitforum.com/articles/18/view.asp?id=4077
Can anyone confirm these instructions?
October 16, 2008 at 3:17 pm
Thanks homebrew. That second link is what I was looking for.
October 19, 2008 at 2:48 pm
Dont Forget to take cold as well as hot backup before moving system databases. 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply