Forum Replies Created

Viewing 15 posts - 3,661 through 3,675 (of 9,244 total)

  • RE: Always On, Transaction Logs getting big

    Joe.Spitler (1/23/2014)


    We are running MS System Center Operations Manager (SCOM) with 2 nodes, always on, with SQL Server 2012. Our transaction logs are growing and filling up the the...

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

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

  • RE: Detached DB After Dropping Certificate - Now I can't attached it

    the main point of confusion was that the OP was under the impression the cert was encrypted by password when in fact it wasnt, it's protected by the DMK. Had...

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

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

  • RE: Convert Drive Letters to Mount Points in SQL Cluster

    edit the volume in windows disk management, do you see a drive letter and a volume mount point name?

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

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

  • RE: Detached DB After Dropping Certificate - Now I can't attached it

    arrjay (1/23/2014)


    Thanks for the link but it doesn't help me.

    The situation I'm in is that I have removed the certificates from server A.

    The link does help...

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

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

  • RE: Detached DB After Dropping Certificate - Now I can't attached it

    arrjay (1/23/2014)


    Thanks Perry - I have removed the cert information. As the certs are encrypted by the database master key, does this mean they will be easily re-created. ...

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

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

  • RE: Detached DB After Dropping Certificate - Now I can't attached it

    arrjay (1/23/2014)


    Hi there - Not sure if this is meaningful;

    First things first, edit your post and remove details of all other certs 😉

    Leave just the detail on the cert...

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

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

  • RE: Detached DB After Dropping Certificate - Now I can't attached it

    arrjay (1/23/2014)


    the certs exist on another server (which the db orginally came from), is there a way of scripting them out and copying them to the server?

    Can you post the...

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

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

  • RE: Detached DB After Dropping Certificate - Now I can't attached it

    might be worth first attempting to get the cert from the other server, leave the master restore as last resort

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

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

  • RE: Do we need Shared Drive for Quorum disk to configure AlwaysOn Availability Groups

    If both servers are on the same site then using a disk witness would be fine

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

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

  • RE: Detached DB After Dropping Certificate - Now I can't attached it

    Do you not have a backup of the cert anywhere

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

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

  • RE: Linked Server error: Login Failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

    DSQLServer (1/22/2014)


    I have a server that doesn't have kerberos setup and isn't using sql ID and it all works. Since it works, I've not checked the finer related details...

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

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

  • RE: Clustering

    sql-lover


    Also, on Veritas you basically install MS-SQL once on top of Veritas which does the rest.

    Thats not correct, see my post above.

    SFW HA has VCS cluster resource...

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

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

  • RE: AlwaysOn config?

    All nodes must be part of the same cluster.

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

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

  • RE: AlwaysOn config?

    You can have an AO group span different clusters but its only supported for migration purposes.

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

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

  • RE: AlwaysOn config?

    david.alcock (1/22/2014)


    May I ask another question Perry. With regards to AlwaysOn, is it possible to have a 2 node cluster, availability group configured accordingly and then add a secondary...

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

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

Viewing 15 posts - 3,661 through 3,675 (of 9,244 total)