Re: Duplicate SQL 2005 using Virtual images

Hi

That is still required, but since you can't update the tables directly in
SQL Server 2005, you have to use the documented stored procedures
(sp_addserver and sp_dropserver)

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@xxxxxxxxxxxx

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"arno" <nono75@xxxxxxxxxxxxxxxxx> wrote in message
news:%23JFhwv%23%23FHA.1248@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> Have you got any feedbacks or comments about virtualization and
> duplication of SQL server 2005?
>
> For SQL Server 2000, after obtaining a new Virtual PC image, it was
> necessary to update the name of the server in the system tables.
>
> So, is there other requirement for SQL 2005?
>
> Thanks,
> arno
>


.

Relevant Pages

  • Re: Software Activation - A Straight Question
    ... Microsoft announced that it is expanding virtualization ... use rights to allow unlimited virtual instances on servers that are fully ... SQL Server 2005 Enterprise Edition is the ideal choice. ...
    (borland.public.delphi.non-technical)
  • Re: SQL Server 2005 - How many Instances on a physical Server?
    ... different SQL Server Intance means five different SQL Server services and other SQL Server related services. ... He answered that "you can install multi instances of SQL Server 2005 on a physical computer (I'm not talking about the virtualization here, for that question check out the link that Ben has already provided) and you need only one license of SQL Server 2005. ...
    (microsoft.public.sqlserver.setup)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... hopefully he can expedite processing your full subscription. ... SQL Server MVP ... Columnist, SQL Server Professional ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... hopefully he can expedite processing your full subscription. ... SQL Server MVP ... Columnist, SQL Server Professional ... Please reply to the newsgroup. ...
    (microsoft.public.sqlserver.programming)
  • Re: Profiling error message 208: sorting the wheat from the chaff
    ... Profile load to a file then load the> file to a table or have Proviler load to a table directly. ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)