Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We're rolling out laptops to some of our staff that will require SQL Server 2008 R2 Express be installed. We'd naturally prefer to do the setup of the laptops (including the installation SQL Express) once and then clone it to the other 50 or so machines. Will the cloning cause problems with SQL Express? Should we consider doing that install manually after the cloning instead?

share|improve this question
add comment

1 Answer

Hmmm... good question. I'm thinking there's going to be at least one task needed: Running sp_dropserver and sp_addserver on each laptop after they boot into the cloned image. I'm sure there's probably more and to be honest I'm not even sure that imaging is a supported operation with SQL installed.

http://msdn.microsoft.com/en-us/library/ms174310.aspx

http://msdn.microsoft.com/en-us/library/ms174411.aspx

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.