How to Change SQL Server name

• Sisir Kumar De

  SSC Enthusiast

  Points: 124

  More actions

  March 24, 2008 at 1:52 am

  #183535

  We are having to SQL database sever JKA and JKB. Both are running on Windows 2000 Server with SQL 2000 and having same application s/W. The database of JKA is being replicated to JKB. In the event of failure of JKA, we want to change the JKB to JKA and run exactly as JKA. What are the steps we have to follow to rename the database server without reloading the SQL or windows server S/w?

• Anipaul

  SSC-Insane

  Points: 24681

  More actions

  March 24, 2008 at 2:07 am

  #792931

  This can guide you:

  http://www.mssqltips.com/tip.asp?tip=1122

  http://www.sqlusa.com/bestpractices/renamedb/

  http://www.sqlserverandxml.com/2006/06/rename-sql-server-2000-datatabase.html

  http://decipherinfosys.wordpress.com/2007/10/24/re-naming-database-in-sql-server/

• Sisir Kumar De

  SSC Enthusiast

  Points: 124

  More actions

  March 24, 2008 at 5:44 am

  #792961

  Many many thanks for the reply. All the information available on those sites are very helpful.