Restore C drive (OS, SQL assemblies) to another disk to save the day

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Restore C drive (OS, SQL assemblies) to...

Restore C drive (OS, SQL assemblies) to another disk to save the day

Rate Topic

Display Mode

Topic Options

Author

Message

clare.xia

Posted Tuesday, January 08, 2013 10:49 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 09, 2013 2:46 PM
Points: 55, Visits: 236

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?

Post #1404378

GSquared

Posted Tuesday, January 08, 2013 11:25 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:55 PM
Points: 15,442, Visits: 9,571

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

Post #1404398

clare.xia

Posted Tuesday, January 08, 2013 11:27 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 09, 2013 2:46 PM
Points: 55, Visits: 236

Yeah, in theory it should work. But I never did it before, any suggestions during the process?

Post #1404401

Steve Jones - SSC Editor

Posted Tuesday, January 08, 2013 11:39 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 4:46 PM
Points: 31,433, Visits: 13,745

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1404410

clare.xia

Posted Tuesday, January 08, 2013 11:55 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 09, 2013 2:46 PM
Points: 55, Visits: 236

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.

Post #1404414

Steve Jones - SSC Editor

Posted Tuesday, January 08, 2013 11:59 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 4:46 PM
Points: 31,433, Visits: 13,745

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1404415

clare.xia

Posted Tuesday, January 08, 2013 12:40 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 09, 2013 2:46 PM
Points: 55, Visits: 236

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..

Post #1404428

clare.xia

Posted Wednesday, January 09, 2013 10:19 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 09, 2013 2:46 PM
Points: 55, Visits: 236

Thank you all! it went smoothly. All DBs are online and passed DBCC check. Smile

Post #1404888

« Prev Topic | Next Topic »

Permissions