Announcement

Collapse
No announcement yet.

Windows 2003 Server with 1 x live SQL server and 1 x offline server - DB sync

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Windows 2003 Server with 1 x live SQL server and 1 x offline server - DB sync

    Hi all,

    Does anyone know how I can copy live data from SQL server 1 to offline Server server 2?

    The reason being, SQL server 2 is used for R&D.

    Thanks
    CM

  • #2
    Re: Windows 2003 Server with 1 x live SQL server and 1 x offline server - DB sync

    If this is a one-off copy, backup on one and restore on the other
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: Windows 2003 Server with 1 x live SQL server and 1 x offline server - DB sync

      Thanks for the reply.

      Can this be achieved by a script or other function in anyway?

      Thanks
      CM

      Comment


      • #4
        Re: Windows 2003 Server with 1 x live SQL server and 1 x offline server - DB sync

        In SQL Server you can do EVERYTHING with scripts!
        Easiest way is to do it manually and look at the code that results
        Tom Jones
        MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
        PhD, MSc, FIAP, MIITT
        IT Trainer / Consultant
        Ossian Ltd
        Scotland

        ** Remember to give credit where credit is due and leave reputation points where appropriate **

        Comment


        • #5
          Re: Windows 2003 Server with 1 x live SQL server and 1 x offline server - DB sync

          Thanks but how effective will it be with a 5GB database? Is there any software that I can use to achieve this?

          Comment

          Working...
          X