how to copy (running) instance RRS feed

  • Question

  • I need to get up on my computer with MSSQL Server 2005 SP2 an exact copy of running MS SQL Server 2005 SP1 instance (with system objs, accounts, etc.).

    In the same LAN.

    Well, not exact one but the one as close as possible...

    And what exactly may I  mimick without interfering to existing SS2005 in production?


    What is the best way to do it without invoking excessive (manual) work and problems? 

    I see dozens of ways and I am still in doubt...
    No ideal or straight-forward solution

    Friday, May 25, 2007 9:35 AM


All replies