RE: [SP2013] Duplicate Database Servers in Servers in Farm
Hi James, That command suggests it's for web servers only. Not sure I'm confident using it on the primary database server. Either way, I'm not sure it would help in this case as some content databases (and possibly some config or service DBs) are referencing the server by name. Regards, Paul -- Paul Noone SharePoint Admin/Developer, Keller Australia Group M: 0409 283 961 E: p.no...@keller.com.aumailto:p.no...@keller.com.au From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of James Boman Sent: Thursday, 13 March 2014 4:08 PM To: ozMOSS Subject: RE: [SP2013] Duplicate Database Servers in Servers in Farm I have done this before on 2007 (a long time ago now) and the general strategy was to backup all the databases, restore them onto the new database server, and then use a STSADM command to rename the database server. This then changed all references to the database server to the new server. After a quick look the STSADM command appears to have been migrated to powershell herehttp://technet.microsoft.com/en-us/library/ff607556.aspx. James Boman ■ Office: +61 (08) 7200 1100tel:+61872001100 ■ Mobile: +61 (0) 417 857 298tel:+61417857298 ■ Skype: JDBomanskype:JDBoman?call ■ Web: www.ipmo.com.auhttp://www.ipmo.com.au From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Thursday, 13 March 2014 2:32 PM To: ozMOSS Subject: [SP2013] Duplicate Database Servers in Servers in Farm Hi all, So I've inherited a 2013 farm in my new role and it has a number of issues. :) One of my efforts to resolve SQL latency is to move all SP databases from a shared instance and onto a new server. I've done this before in a properly configured farm without issue by following the usual steps. However, my Servers in Farm screen lists two instances of the same database server: by IP address and by server name. Most of the content databases use the IP address, as do Search and other services. The add Content Database screen also uses the IP address be default. So what to do? And what are the possible ramifications? · Can I simply create an Alias for each in CLICONFG? · Is there a way to easily identify all instances of the server name use and change these to the IP address (or vice versa) via Powershell? Thanks in advance. Regards, Paul -- Paul Noone SharePoint Admin/Developer, Keller Asutralia Group M: 0409 283 961 E: p.no...@keller.com.aumailto:p.no...@keller.com.au | www.keller.com.auhttp://www.keller.com.au/ [Keller Australia | Global Scale, Local Focus] Suite 607, 2-8 Brookhollow Ave Baulkham Hills NSW 2153 The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your system. Please note that neither Keller Australia nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Visit http://www.keller.com.au/ for more information. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your system. Please note that neither Keller Australia nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Visit http://www.keller.com.au/ for more information. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal inline: image001.jpg___ Sponsored by Infotext - Amazing Search for Microsoft SharePoint - http://www.infotext.com/ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: [SP2013] Duplicate Database Servers in Servers in Farm
OK, I think I've identified the problem. Looks like two content databases were migrated and wound up with the server name. One has zero sites and can be safely deleted. What's the best suggestion for the other one (WSS_Content_K) below? Can I just delete it and re-add it again by name via CA? Assuming this will then clear the named server instance from the Servers in Farm screen as others have suggested. Name ServerSiteCount --- WSS_Content_K XX-SQL-X2 WSS_MySites_C 10.0.*.*1 WSS_Content_P 10.0.*.*1 WSS_Content_W XX-SQL-X0 Regards, Paul -- Paul Noone SharePoint Admin/Developer, Keller Australia Group M: 0409 283 961 E: p.no...@keller.com.aumailto:p.no...@keller.com.au From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Friday, 14 March 2014 8:54 AM To: ozMOSS Subject: RE: [SP2013] Duplicate Database Servers in Servers in Farm Hi James, That command suggests it's for web servers only. Not sure I'm confident using it on the primary database server. Either way, I'm not sure it would help in this case as some content databases (and possibly some config or service DBs) are referencing the server by name. Regards, Paul -- Paul Noone SharePoint Admin/Developer, Keller Australia Group M: 0409 283 961 E: p.no...@keller.com.aumailto:p.no...@keller.com.au From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of James Boman Sent: Thursday, 13 March 2014 4:08 PM To: ozMOSS Subject: RE: [SP2013] Duplicate Database Servers in Servers in Farm I have done this before on 2007 (a long time ago now) and the general strategy was to backup all the databases, restore them onto the new database server, and then use a STSADM command to rename the database server. This then changed all references to the database server to the new server. After a quick look the STSADM command appears to have been migrated to powershell herehttp://technet.microsoft.com/en-us/library/ff607556.aspx. James Boman ■ Office: +61 (08) 7200 1100tel:+61872001100 ■ Mobile: +61 (0) 417 857 298tel:+61417857298 ■ Skype: JDBomanskype:JDBoman?call ■ Web: www.ipmo.com.auhttp://www.ipmo.com.au From: ozmoss-boun...@ozmoss.commailto:ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Thursday, 13 March 2014 2:32 PM To: ozMOSS Subject: [SP2013] Duplicate Database Servers in Servers in Farm Hi all, So I've inherited a 2013 farm in my new role and it has a number of issues. :) One of my efforts to resolve SQL latency is to move all SP databases from a shared instance and onto a new server. I've done this before in a properly configured farm without issue by following the usual steps. However, my Servers in Farm screen lists two instances of the same database server: by IP address and by server name. Most of the content databases use the IP address, as do Search and other services. The add Content Database screen also uses the IP address be default. So what to do? And what are the possible ramifications? · Can I simply create an Alias for each in CLICONFG? · Is there a way to easily identify all instances of the server name use and change these to the IP address (or vice versa) via Powershell? Thanks in advance. Regards, Paul -- Paul Noone SharePoint Admin/Developer, Keller Asutralia Group M: 0409 283 961 E: p.no...@keller.com.aumailto:p.no...@keller.com.au | www.keller.com.auhttp://www.keller.com.au/ [Keller Australia | Global Scale, Local Focus] Suite 607, 2-8 Brookhollow Ave Baulkham Hills NSW 2153 The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your system. Please note that neither Keller Australia nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Visit http://www.keller.com.au/ for more information. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your system. Please note that neither Keller Australia nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Visit http://www.keller.com.au/ for more information
RE: [SP2013] Duplicate Database Servers in Servers in Farm
I have done this before on 2007 (a long time ago now) and the general strategy was to backup all the databases, restore them onto the new database server, and then use a STSADM command to rename the database server. This then changed all references to the database server to the new server. After a quick look the STSADM command appears to have been migrated to powershell herehttp://technet.microsoft.com/en-us/library/ff607556.aspx. James Boman ■ Office: +61 (08) 7200 1100tel:+61872001100 ■ Mobile: +61 (0) 417 857 298tel:+61417857298 ■ Skype: JDBomanskype:JDBoman?call ■ Web: www.ipmo.com.auhttp://www.ipmo.com.au From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Thursday, 13 March 2014 2:32 PM To: ozMOSS Subject: [SP2013] Duplicate Database Servers in Servers in Farm Hi all, So I've inherited a 2013 farm in my new role and it has a number of issues. :) One of my efforts to resolve SQL latency is to move all SP databases from a shared instance and onto a new server. I've done this before in a properly configured farm without issue by following the usual steps. However, my Servers in Farm screen lists two instances of the same database server: by IP address and by server name. Most of the content databases use the IP address, as do Search and other services. The add Content Database screen also uses the IP address be default. So what to do? And what are the possible ramifications? · Can I simply create an Alias for each in CLICONFG? · Is there a way to easily identify all instances of the server name use and change these to the IP address (or vice versa) via Powershell? Thanks in advance. Regards, Paul -- Paul Noone SharePoint Admin/Developer, Keller Asutralia Group M: 0409 283 961 E: p.no...@keller.com.aumailto:p.no...@keller.com.au | www.keller.com.auhttp://www.keller.com.au/ [Keller Australia | Global Scale, Local Focus] Suite 607, 2-8 Brookhollow Ave Baulkham Hills NSW 2153 The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your system. Please note that neither Keller Australia nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Visit http://www.keller.com.au/ for more information. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal inline: image001.jpg___ Sponsored by Infotext - Amazing Search for Microsoft SharePoint - http://www.infotext.com/ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss