Forum Replies Created

Viewing 15 posts - 4,936 through 4,950 (of 9,253 total)

  • RE: SQL 2012 High Availibility

    ok, so you understand that the 2 nodes participating in the failover cluster instance share the resources in the cluster group, they don't each have a G drive, they share...

  • RE: SQL 2012 High Availibility

    Have you worked with windows server failover clusters before, do you understand the concepts?

  • RE: SQL 2012 High Availibility

    SQLSACT (9/27/2012)


    FCI called "SQLCLUST01\INST1" across Clusternode1 and Clusternode2.

    Non clustered instance "Clusternode3\INST2" installed to Clusternode3.

    AO group called "AOGrp1" created between instances "SQLCLUST01\INST1" and "Clusternode3\INST2"

    The above setup is an AG combined with...

  • RE: SQL 2012 High Availibility

    SQLSACT (9/27/2012)


    For a setup of an AG between 2 servers without incorporating FCI, I just need 2 servers, with it's own storage, right?

    That is correct, recall that an availability...

  • RE: Repairing a Broken Log Shipping Plan From a Differential Backup

    joeroshan (9/27/2012)


    Great article. Very useful for DBA in production environment.

    Hi, thanks for the feedback, please don't forget to rate the article if you found it useful

  • RE: LOGSHIPPING RE-ESTABLISHMENT

    Jai-SQL DBA (9/26/2012)


    Hi,

    I want to understand the Logshipping reestablishment Scenerio After a Failover.Below Mentioned are the details of the Environment for the Better Understanding.

    Server A: Primary Server

    Server B:...

  • RE: Active /Active configuration

    saidapurs (9/26/2012)


    Hi Peery,

    I am using 1 cluster & multiple node. You mean multiple clusters are called active/active?

    Please collaborate this one....

    Thanks & Regards

    Satish Saidapur

    Microsoft now prefer the...

  • RE: SQL Disk to Memory

    thanks I stand corrected

  • RE: Want to find transaction log size before taking backup

    opc.three (9/25/2012)


    CREATE TABLE #LOGSPACE

    (

    DB SYSNAME,

    LogSize FLOAT,

    SpaceUsed FLOAT,

    Stat BIT

    );

    INSERT INTO #LOGSPACE

    (

    ...

  • RE: OS Error when configuring Log Shipping

    Normally i would expect an error 5 if the backup couldn't be accessed during the restore part of the wizard. Haven't managed to recreate an error 2 yet.

    What account...

  • RE: Want to find transaction log size before taking backup

    opc.three (9/25/2012)


    The SpaceUsedMB could be low if you ever switch the DB into the Bulk Logged Recovery Model and perform any minimally logged operations.

    Yes, but bear in mind that log...

  • RE: SQL Disk to Memory

    to TempDB

  • RE: OS Error when configuring Log Shipping

    Perry Whittle (9/22/2012)


    One further question,

    When you set the details on the restore tab did you edit the restore options and enter different paths for the target\secondary data and log...

  • RE: SQL Disk to Memory

    laurie-789651 (9/25/2012)


    Perry Whittle (9/25/2012)


    SQLSACT (9/25/2012)


    Hi all

    I have a quick question regarding pages moving from disk into memory

    If I select * from a table, are all pages that make up the...

  • RE: Mirror and witness becomes disconnected, won't reconnect

    scogeb (9/25/2012)


    I am going to try to restart the endpoint per Perry's suggestion next time this happens. I will post back the results at that time.

    This should be your...

Viewing 15 posts - 4,936 through 4,950 (of 9,253 total)