Do we need to stop SQL Server services before cloning the machine. ?

Question

Do we need to stop SQL Server services before cloning the machine. ?

Joy Smith San

SSC-Insane

Points: 24877
More actions
September 29, 2014 at 10:18 pm

#291114

Hi All,
Wintel is cloning a machine where SQL Server 2005 is installed for some testing purpose.
It will have same IP and name but will not be in network so that it wont clash with the actual server.
My question is, do we need to stop SQL Server services before cloning the machine. ?
Any recommendation from microsoft on this ?
Thanks in advance.
Smith.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

It is best to quiesce the databases before cloning the machine. You can achieve that through stopping the SQL services.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 2

SQLRNNR (9/29/2014)
It is best to quiesce the databases before cloning the machine. You can achieve that through stopping the SQL services.

Thanks alot.

Is it essential ?. Do we have any reference link ?

Thanks once again, much appreciated.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

http://il-adan.blogspot.com/2013/07/hyper-v-clone-machine-with-sql-server.html

Here is an example on how to do it.

And a recommendation from VMWare on their best practice recommendation

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1004588

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 4

Thanks.

They are cloning to totally a diff box. So will the following steps be fine.

1. Stop SQL Server services in actual server

2. Let wintel complete cloning.

3. Start SQL Server services in actual server

Continue with the activities in cloned server. Can we do it this way ?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Yes. Just make sure to rename the clone appropriately as discussed in those articles.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sqldriver SSChampion Points: 10440 More actions · Answer 6

SQLRNNR (9/30/2014)
Yes. Just make sure to rename the clone appropriately as discussed in those articles.

This seems to be a popular subject, and you're really knowledgeable about it, it seems. I remember a couple months ago asking a sort of similar question. The write-ups I came across were pretty sparse. Bet it would make a popular post on your blog :smooooth:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

sqldriver (10/1/2014)
SQLRNNR (9/30/2014)
Yes. Just make sure to rename the clone appropriately as discussed in those articles.
This seems to be a popular subject, and you're really knowledgeable about it, it seems. I remember a couple months ago asking a sort of similar question. The write-ups I came across were pretty sparse. Bet it would make a popular post on your blog :smooooth:

Thanks for the idea.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events