<quote> If the old disks have the SQL service master, model, temp db’s
</quote> Gah! That’s the problem. I’m looking at several docs now for how to move the system/master databases. Gonna be a busy weekend. Sean Rector, MCSE From: Ziots, Edward [mailto:[email protected]] Sent: Friday, October 07, 2011 8:36 AM To: NT System Admin Issues Subject: RE: New SAN - How to remove old from SQL Cluster? I am thinking from the Windows 2003 Cluster side of it ( I haven’t done anything with Windows 2008 clustered) that you must add the new disks as as dependent resources of the SQL Service, before you remove the old ones) (Along with both nodes needing to know its cluster aware) and then you need to copy what was on the old disks to the new disks, and then remove the old disks. If the old disks have the SQL service master, model, temp db’s you might be a little stuck on just trying to replace the disk. Most times when we had to migrate SAN’s it was done in the background ( disk to disk migration via EMC tools, so the host basically saw nothing, disk signatures, and disk letters and sizes stayed the same.) HTH EZ As a side note if anyone has a good write up on Windows 2008 Clustering step by step guide that would be nice to have. I know the windows 2003 document that Microsoft put out is what I use and its cake to take care of the clustering when needed, but in Windows 2008 I haven’t found a resource such as it to do a step by step setup, testing of failover etc etc. Edward E. Ziots CISSP, Network +, Security + Security Engineer Lifespan Organization Email:[email protected] Cell:401-639-3505 From: Richard Stovall [mailto:[email protected]] Sent: Thursday, October 06, 2011 11:07 PM To: NT System Admin Issues Subject: Re: New SAN - How to remove old from SQL Cluster? I'm not real clear on what you're doing. New SAN replaces old, but what else? Did the new disk resources come online? Did they have the same drive letters as the ones they replaced? Note, I know that clustering has changed a lot since Server 2003, which is the last OS I've had much cluster experience with. So forgive me if the above makes no sense within the context of 2008R2 clustering. Also, what about the event logs. I would think that SQL would be screaming a lot of information if the service can't start. On Thu, Oct 6, 2011 at 10:50 PM, Sean Rector <[email protected]> wrote: I know it should be as simple as change the dependencies and delete the disks in Server 2008 R2 Cluster Manager, but that’s not what happened. I removed the disks, and SQL promptly shut down & would not restart. I re-added the disks in Cluster Manager & SQL started with no problem. Thoughts? Sean Rector, MCSE Information Technology Manager Virginia Opera Association E-Mail: [email protected] <mailto:[email protected]> Phone: (757) 213-4548 <tel:%28757%29%20213-4548> (direct line) {+} Tickets and Subscriptions On Sale Now! Aida | Hansel And Gretel | Orphée | The Mikado Visit us online at www.VaOpera.org <http://www.vaopera.org/> or call 1-866-OPERA-VA Experience the Beauty, Power & Passion of Virginia Opera. ________________________________ This e-mail and any attached files are confidential and intended solely for the intended recipient(s). Unless otherwise specified, persons unnamed as recipients may not read, distribute, copy or alter this e-mail. Any views or opinions expressed in this e-mail belong to the author and may not necessarily represent those of Virginia Opera. Although precautions have been taken to ensure no viruses are present, Virginia Opera cannot accept responsibility for any loss or damage that may arise from the use of this e-mail or attachments. {*} ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
<<image001.jpg>>
