Announcement

Collapse
No announcement yet.

How can i create backup SQL Instance as is?

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

  • How can i create backup SQL Instance as is?

    I have 2 servers: each one has his own Storage...
    i am going to create something like Cluster to set one active and the 2nd one as backup

    the server in deference location and connected via VPN connection and not always up how can i do that?

  • #2
    Re: How can i create backup SQL Instance as is?

    Look into Log Shipping -- true clustering requires better availability than "not always up"
    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: How can i create backup SQL Instance as is?

      Thx ossian...
      But what about Master, Model, MSDb and tmp databases

      Master includes: Security login
      MSDB contain Jobs
      and i have replication jobs
      please advice

      Comment


      • #4
        Re: How can i create backup SQL Instance as is?

        tmpdb does not need any replication. Others will need to be done only if they have been changed, which should happen infrequently.

        IIRC Masterdb is instance specific so should be backed up, not replicated
        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: How can i create backup SQL Instance as is?

          i did log shipping but the Data Base in restore mode how can i test the data base is resorted.


          and i test by run the below command
          RESTORE DATABASE TestDataBase WITH RECOVERY
          as the steps on this link: http://www.youtube.com/watch?v=2k003Dj7fHo

          and the job of restore field.. how can i continue in log shipping mode

          Comment


          • #6
            Re: How can i create backup SQL Instance as is?

            logging shipping now clear
            thx alot

            Comment

            Working...
            X