Forum Replies Created

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

  • 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" 😉

  • RE: Any problem with installing SQLServer 2012 on Windows 2012?

    As far as I'm aware you cant. If you try to enable .NET role without internet access you have to use cmd line to disable online checks

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

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

  • RE: compressing read only file groups

    muthyala_51 (1/22/2014)


    Steve,

    Can you help me to find that article or elaborate on that technique which you are referrring to?

    As follows

    ALTER DATABASE olddata ADD FILEGROUP newFG

    ALTER DATABASE olddata ADD FILE(NAME=somename, FILENAME...

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

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

  • RE: compressing read only file groups

    SQL Server data compression would be my preference over NTFS compression

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

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

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