Uh, doesnt the database contain the server name, SID, etc of the actual DB serve?
Simply making a the server name in AD/DNS to point to the new one wont really make it work correctly and has the potential to cause some issues? From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Jon Bullen Sent: Wednesday, 29 April 2009 9:52 AM To: ozmoss@ozmoss.com Subject: RE: Moving databases to a new SQL server [SEC=UNCLASSIFIED] May I recommend that you make a alias in AD for the server and use that instead. That way and future DR or server moves involve updating the alias and not having to rename the server in SharePoint. Regards Jon Bullen | Senior Consultant | Microsoft Services E-Mail Signature Orange Energy.gif È +61 4 1048 0197 Canberra, Australia | www.microsoft.com/services MSN IM: <mailto:jon_bul...@hotmail.com> jon_bul...@hotmail.com This email is intended solely for the use of the addressee and may contain information that is confidential or subject to legal professional privilege. If you receive this email in error please immediately notify the sender and delete the email. Please consider the environmental impact before printing this email. From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Noja, Fadi Sent: Wednesday, 29 April 2009 9:34 AM To: ozmoss@ozmoss.com Subject: RE: Moving databases to a new SQL server [SEC=UNCLASSIFIED] Heres how to do it http://technet.microsoft.com/en-us/library/cc288554.aspx Fadi _____ From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Zelda Leung Sent: Wednesday, 29 April 2009 8:45 AM To: ozmoss@ozmoss.com Subject: Moving databases to a new SQL server Hi all, Weve recently acquired a new SQL Server for our SharePoint databases, and now need to move those databases for our development site from the old SQL server to the new SQL server. The process seems to be fairly simple on face value, but does anyone have a website/list of must dos and should knows? Thanks, Zelda Zelda Leung Principal Developer | IT Services | Legal Aid Queensland p 3238 3626 | 44 Herschel Street DISCLAIMER: The contents of this email (including any attachments) are confidential and privileged and are intended only for the addressee. Any confidentiality or privilege is not waived or lost because this email has been sent to you by mistake. Any unauthorised use of the contents of this email is expressly prohibited. If you receive this email in error, please contact us, then delete the email. Emails may be interfered with, may contain computer viruses or other defects and may not be successfully replicated on other systems. We give no warranties in relation to these matters. If you have any doubts about the authenticity of an email purportedly sent by us, please contact us immediately. _____ Support procedure: https://www.codify.com/lists/support List address: ozmoss@ozmoss.com Subscribe: ozmoss-subscr...@ozmoss.com Unsubscribe: ozmoss-unsubscr...@ozmoss.com List FAQ: <http://www.codify.com/lists/ozmoss> http://www.codify.com/lists/ozmoss Other lists you might want to join: <http://www.codify.com/lists> http://www.codify.com/lists _____ Support procedure: https://www.codify.com/lists/support List address: ozmoss@ozmoss.com Subscribe: ozmoss-subscr...@ozmoss.com Unsubscribe: ozmoss-unsubscr...@ozmoss.com List FAQ: <http://www.codify.com/lists/ozmoss> http://www.codify.com/lists/ozmoss Other lists you might want to join: <http://www.codify.com/lists> http://www.codify.com/lists _____ Support procedure: https://www.codify.com/lists/support List address: ozmoss@ozmoss.com Subscribe: ozmoss-subscr...@ozmoss.com Unsubscribe: ozmoss-unsubscr...@ozmoss.com List FAQ: <http://www.codify.com/lists/ozmoss> http://www.codify.com/lists/ozmoss Other lists you might want to join: <http://www.codify.com/lists> http://www.codify.com/lists -------------------------------------------------------------------------------- Support procedure: http://www.codify.com/lists/support List address: ozmoss@ozmoss.com Subscribe: ozmoss-subscr...@ozmoss.com Unsubscribe: ozmoss-unsubscr...@ozmoss.com List FAQ: http://www.codify.com/lists/ozmoss Other lists you might want to join: http://www.codify.com/lists
<<image001.gif>>