Solved

how to upgradea cloned sql 2008 to 2008 r2 on a vmware server

Posted on 2011-09-22
1
369 Views
Last Modified: 2012-06-21
:
We are trying to upgrade a sql server 2008 database to sql2008 r2.  The problem is this database was created by cloning one vmware server (and database) to another server.  
So, the machine name in SQL and the registry is the old server.  But to connect to ssms, the new server name is used.  What would need to be done to correct the cloned database, so it has the correct servername?

What is the best way to do this upgrade?  Should we uninstall sql 2008, and do a clean install of sql 2008 r2?  
0
Comment
Question by:abgail
1 Comment
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 36584492
As suggested in your duplicate question all you have to do is change the server name in SQL Server.  No need to repeat the technical details as it has already been done.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How can i make performance tuning to my sql query? 6 47
cloning a vm failure 9 62
MS SQL Delete Query 9 31
VMware Workstation: VM doesn’t start 6 53
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
Teach the user how to install vSphere Update Manager  Console to Windows system:  Install vSphere Update Manager: Configure vSphere Update Manager plug-in in vSphere Client: Verify vSphere Update Manager settings in vSphere Client:
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question