Forum Replies Created

Viewing 15 posts - 5,116 through 5,130 (of 9,244 total)

  • RE: replication or monitor breaks after changing sa password

    At present I have not managed to reproduce this issue,

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: replication or monitor breaks after changing sa password

    karen_jonesdba (8/31/2012)


    Thank you for getting back.

    Is there a way to verify where sa is being used in all the replication processes?

    open the publication properties and go to the agent security...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Setting up a new SQL Server 2008R2 Active/Passive Cluster

    Jpotucek (8/31/2012)


    We have several Standalone SQL Server 2005 Servers in Production each with Multiple Instances.

    We will be building out a new SQL Server 2008R2 HA Active\Passive Cluster and I...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: replication or monitor breaks after changing sa password

    Divine Flame (8/31/2012)


    Seems like "sa" login has been used while configuring replication. In that case you might need to update the replication passwords too when you change the password for...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Renamed AD users' accounts, now some SQL Servers can't get info

    Ok, what other roles does this DC hold or are they spread amongst the remaining members?

    Are all DC's in the same site or do you have multiple AD sites?

    Check the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Renamed AD users' accounts, now some SQL Servers can't get info

    schleep (7/13/2012)


    The OS reboot solved everything,

    Possibly because its bound itself to a different DC upon reboot

    What does the following return on each sql server when run from a command prompt

    set...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Cluster - Nodes

    SQLSACT (8/31/2012)


    I am removing a node from the Cluster to have it replaced with another node.

    ok, so perform the remove node on each clustered instance and finally evict the node...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: database auditing performance issues?

    what exactly is it you want to audit?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Replicate a huge database in another server

    2012 Std definitely lists Windows 7 as a valid platform but BI and Ent don't, it's in the link i posted

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Replicate a huge database in another server

    They do indeed differ, although this does somewhat limit the options

    SQL Kidu (8/30/2012)


    Running on Windows 7 Professional Version with SP1

    Interesting and never tried it, but SQL Server 2012 Ent does...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Log shipping secondary not showing new results from primary

    it all depends on whether the failure is known or not. Try it on a test system you'll see how it works

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Resource Failover on Always on

    MSDN states the following

    MSDN


    Note

    Issues at the database level, such as a database becoming suspect due to the loss of a data file, deletion of a database, or...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Log shipping secondary not showing new results from primary

    n00bDBA (8/30/2012)


    Hi Perry thanks!

    Can i just confirm im understanding it right.

    CASE 1 - logs retained on Primary and secondary for 24 hours - 1 hour LINK down

    10:00 - Log...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Log shipping secondary not showing new results from primary

    n00bDBA (8/30/2012)


    Hi Perry thanks!

    Can i just confirm im understanding it right.

    CASE 1 - logs retained on Primary and secondary for 24 hours - 1 hour LINK down

    10:00 - Log...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Replicate a huge database in another server

    do the secondary databases need to be readable?

    what edition of sql server 2012 are you using?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 5,116 through 5,130 (of 9,244 total)