ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login
    1. Topics
    2. Tags
    3. sql 2012 standard
    Log in to post
    • All categories
    • anthonyhA

      PowerShell - Script never completes. Is there a session timeout?

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion powershell sql 2012 standard backup
      11
      4 Votes
      11 Posts
      2k Views
      anthonyhA

      @dafyre said in PowerShell - Script never completes. Is there a session timeout?:

      @anthonyh said in PowerShell - Script never completes. Is there a session timeout?:

      @dafyre said in PowerShell - Script never completes. Is there a session timeout?:

      ROFL. Not a problem. Things working as designed. Next!

      For what it's worth, my post was intended to be framed from the standpoint of "what am I doing wrong??" rather than "what's wrong with the system?!". I figured I was missing something stupid.

      Never hurts to have extra eyes. I didn't even think about the potential for this to be a scheduled job... God, I have a case of the Mondays.

      Not your fault at all. I did not mention it in my OP. Whoops. Perhaps I'm the one with a case of the Mondays.

    • AmbarishrhA

      SQL mirroring advise

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion sql sql server 2012 sql 2012 standard mirroring sql mirroring replication
      16
      1 Votes
      16 Posts
      4k Views
      DashrenderD

      @scottalanmiller said in SQL mirroring advise:

      @Ambarishrh said in SQL mirroring advise:

      @scottalanmiller said in SQL mirroring advise:

      @Ambarishrh said in SQL mirroring advise:

      @scottalanmiller said in SQL mirroring advise:

      @Ambarishrh said in SQL mirroring advise:

      @Dashrender said in SQL mirroring advise:

      Are the two SQL servers sitting side by side? If not, shared storage and low latency for it's use would be super expensive.

      Though I do wonder how their DR plan works if there isn't a cluster for the DB, what purpose does the second server serve? Warm spare?

      Yes the servers are side by side, basically just sits there, and when a new site is created on SP side, run the script which mirrors the new DB created on server 1 to server 2. Eventually they were planning to introduce the witness server once our testing is complete and then enable auto failover. The downside here is that someone need to manually run the script for db mirroring of new databases

      So the big thing here is that the databases are not mirrored, just the framework (schema) is at creation time. Very different from mirroring or clustering at that aspect level.

      Yes, we've told them this won't work and asked them to look at a clustered setup. Since the licenses are already in place and is SQL standard no option for Always-On. I want to know what would be the drawbacks for the clustered setup, as for sure there are some more advantages on Always-ON compared to the clustered setup.

      Won't work... for what? What's the end goal?

      Won't work: Current stage its 2 separate DB servers and mirroring needs to be done by executing a script whenever there is a new db is created by SP.

      End Goal: A fully automated failover setup giving high availability for the SharePoint solution

      What they are doing is unrelated to their end goal. How does mirroring database creation help with failover. There isn't even a first step in preparing for a failover here. What is going on is totally something different.

      Exactly what i was asking earlier.

    • 1 / 1