Ghosting with SQL

#1

Hi,

Does anyone know if a system can be ghosted with SQL pre-installed on it?
Any issues with the fact that SID and the machine name will change after
ghosting?

Thank you.

#2

Yes. It is a bad idea. You have to manually change the SQL Server name
after ssyprep and MSDTC gets screwed up, requiring a registry hack to fix.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Dragon" <baadil_nospam (AT) hotmail (DOT) com> wrote

Quote:

Hi,

Does anyone know if a system can be ghosted with SQL pre-installed on it?
Any issues with the fact that SID and the machine name will change after
ghosting?

Thank you.

#3

We do it all the time with no problems. There is no need to change the SQL
server name.unless you change the Machine name.

"Dragon" wrote:

Quote:

Hi,

Does anyone know if a system can be ghosted with SQL pre-installed on it?
Any issues with the fact that SID and the machine name will change after
ghosting?

Thank you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Ghosting with SQL

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

Ghosting with SQL - 10-11-2005 , 08:24 AM

Re: Ghosting with SQL - 10-11-2005 , 08:35 AM

RE: Ghosting with SQL - 12-23-2005 , 07:45 AM