Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Server 2008 R2 Cloning in VMware

Posted on 2014-08-05
7
Medium Priority
?
1,679 Views
Last Modified: 2014-08-11
Today I have followed the steps below to clone a Windows Server 2008 R2 Server running SQL 2008 on VMware 5.5

1. On the SQL Server to be cloned, renamed all SQL Services to Local System, made them manual and stopped them

2. Rebooted SQL Server to be cloned and then shut down ready for a cold clone

3. Cloned SQL Server using Guest Customization

4. Powered new SQL Clone on, checked networking and hostname and joined domain. All drives working fine for Logs and Data etc

5. Rebooted new SQL Clone

6. Gone to Services.msc and changed all services to the Windows AD Service accounts they were.

7 Tried to start them and each one says "Windows could not start the SQL Server (MSSQLSERVER) Service on Local Computer. Error 2: The System cannot find the file specified" I also cannot run SQL Server Configuration Manager. It says MMC could not create the snap-in. The snapin might not have been installed correctly. (It was definitely working on the machine we cloned from fine)

8. Tried googling but there are so many different issues, it's very difficult to find one which corresponds to this issue. We know the passwords are correct. I don't know if its worth running through a SQL Repair but would rather avoid if anyone has had experience of this

9. There is a MS link but I think you need to actually be able to run a query MSSQL Management Studio.
0
Comment
Question by:rhiancohen
  • 4
  • 3
7 Comments
 
LVL 125

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 2000 total points
ID: 40242530
Personally, I would not recommend CLONE-ING an SQL installation for Production Deployment, it's high risk if the SQL server does function correctly.

We just Deploy from template, or Clone from template standard images, e.g. severs that are fully patches, with the SQL Prerequisites, we then Deploy SQL, Sharepoint using scripts and unattended installations.
0
 
LVL 1

Author Comment

by:rhiancohen
ID: 40242558
Yes I think you're right. I've tried a hot and cold clone now and both with the same problem.

Do you mean you have a standard O/S template with everything ready to go, deploy from it then install SQL etc.

We have standard O/S templates which is fine. Looks like it would be best to do that
0
 
LVL 125
ID: 40242578
Do you mean you have a standard O/S template with everything ready to go, deploy from it then install SQL etc.

Yes, that's it exactly what we do.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 1

Accepted Solution

by:
rhiancohen earned 0 total points
ID: 40242644
OK Quick Update.

I found the reason it didn't work.

On the VM we were cloning from the drives were mapped

C:\O/S
D:\SQL Install
E:\SQL Databases
F:\SQL Logs

but when it cloned the VM, the clone re-arranged the drive mappings. When I put them to the correct ones and rebooted, all the services started fine and I can access SQL Management Studio using the new cloned name.

I still think there may be a few more things that may not work as expected but thanks very much for your quick response earlier
0
 
LVL 125
ID: 40242672
I'm not sure why, you drive letters are changing you CLONE.

Are you using OS Partitions or Virtual Disk Drives for each D:, E: and F: ?
0
 
LVL 1

Author Comment

by:rhiancohen
ID: 40242688
Separate Virtual Disk Drives on separate SCSI Controllers as well. (0:0, 1:0, 2:0, 3:0 etc)

Just changes the clone. The original SQL VM is fine.

Strange I know!
0
 
LVL 1

Author Closing Comment

by:rhiancohen
ID: 40252704
This solution worked for us with the drive mappings allowing us to start the SQL Services. We obviously need to test this for the rest of this week but appreciate that templates, scripts and unattended installations are a better automated way to go.

Also found a good product called Delphix Database deduplication which can solve some of the issues where developers want quick copies of Databases. Created by the guy who developed Avamar.
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

578 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