So I’ve moved the tempdb, model, & msdb databases. I was getting ready to move the master db, when I came across this note:
Although it was possible to move the Resource database in SQL Server 2005, things changed in SQL Server 2008 where the location of the Resource database can no longer be relocated from its default directory. In SQL Server 2005, the Resource database depended on the location of the master database. The Resource data and log files had to reside together and had to be in the same location as the master data file (master.mdf). Therefore, in SQL Server 2005, if you moved the master database, you had to also move the Resource database to the same location as the master data file. In SQL Server 2008, the location of the Resource database cannot be moved from its default location. How is this going to affect me moving forward? Is there a way to resolve this? As the SQL server is a cluster, none of these reside w/in the C: path. Sean Rector, MCSE From: Sean Rector [mailto:[email protected]] Sent: Friday, October 07, 2011 12:47 PM To: NT System Admin Issues Subject: RE: New SAN - How to remove old from SQL Cluster? <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 ~ 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>>
