January 8, 2013 at 10:49 am
The C drive (OS, SQL assemblies) are stored in SAN Array1 and all data & log files are stored in SAN Array2. San Aarry1 is down now. To fix it, the plan is to restore a backup from C drive to a local drive and then connect to data & log files from SAN Array2. Is it OK to do it and what things I need to be care of?
January 8, 2013 at 11:25 am
Sounds like it should work. So long as the backup can be restored successfully.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 8, 2013 at 11:27 am
Yeah, in theory it should work. But I never did it before, any suggestions during the process?
January 8, 2013 at 11:39 am
What's the new local drive? Are you saying you will restore c: (local) disk to a different disk?
For the array on the SAN, as long as you have the logical pathing (Drive/mount point) pointed to the same location, it should work.
January 8, 2013 at 11:55 am
Hi Steve,
The C drive used storage from the bad SAN before. The plan is to have C drive use local stoage. Yes, all data and log files will be on the same logical drive.
January 8, 2013 at 11:59 am
I suspect this will work, as the new server will just see a "c" drive. I'm not sure how you will do the restore from your SAN to the new C drive, but the SAN people should be able to do that. As long as it's bootable, it should work.
January 8, 2013 at 12:40 pm
Steve,
This is not a new server. We will use the exsting server. Once the C drive is restored, the server should see other existing data, log, tempdb drives..
January 9, 2013 at 10:19 am
Thank you all! it went smoothly. All DBs are online and passed DBCC check.:-)
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply