Forum Replies Created

Viewing 15 posts - 3,736 through 3,750 (of 9,244 total)

  • RE: SQL Server 2012 AlwaysOn

    crcoracle (1/16/2014)


    Hi,

    Do you guys know if I can set up a new SQL Server cluster with AlwaysOn Availability groups as follows:

    - One node inside the local network

    - Another node in...

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

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

  • RE: SQL Named Instance Corruption During Multi-Site and AG Testing

    Which replica is currently] the AO group primary, is it the FCI?

    Have you configured a listener for the AO group?

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

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

  • RE: TDE Enable???

    if you encrypt the data at the column level you wont need TDE.

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

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

  • RE: TDE Enable???

    It may be that they want to encrypt certain data to stop people viewing it

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

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

  • RE: SQL Named Instance Corruption During Multi-Site and AG Testing

    Ted Zatopek (1/16/2014)


    I did not capture the exact message at the time. It was sometime like "cannot establish mirroring on DB" I do all my mirroring...

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

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

  • RE: Invalid Object Name Mystery - how to find the history of a table

    asheppardwork (1/16/2014)


    I apologize for the lack of clarity. The Stored Proc. that creates the table, drops it at the start. I scanned all the queries run around the time...

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

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

  • RE: TDE Enable???

    that covers a wide range of encryption options, is TDE the option you are seeking to implement?

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

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

  • RE: TDE Enable???

    GilaMonster (1/16/2014)


    Perry Whittle (1/16/2014)


    There is a list of pre requesites that need to be met before you can enable TDE, have you performed these?

    Prerequisites including reading up on how you...

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

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

  • RE: TDE Enable???

    There is a list of pre requesites that need to be met before you can enable TDE, have you performed these?

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

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

  • RE: DB Mirroring vs/ SRDF

    :Whistling: another totally useless option in respect of sql server that storage vendors plug to the nines claiming all sorts of benefits for sql server. Their detail in their plug...

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

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

  • RE: SQL Server Agent showing running,but green arrow is not appeared.

    The green arrow is missing if you do not have permission on the host server to stop and start the service, thats all it signifies

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

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

  • RE: Copy Database Wizard - failing on the final step

    why not just use backup\restore or detach\attach

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

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

  • RE: DB Mirroring vs/ SRDF

    SRDF is a storage level replication technology. SQL server is separate so yes you still have to change instance connection strings

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

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

  • RE: Invalid Object Name Mystery - how to find the history of a table

    asheppardwork (1/14/2014)


    There is a stored procedure that creates the ZZ_ table and the last time it was run was 5:01pm.

    If there's a process creating the table, something must be dropping...

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

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

  • RE: TEMPDB Configuration per vCPU

    Paulo A. Nascimento (1/15/2014)


    Well if tempdb database was, say, 640 MB in size, then that would not seem strange to me :-). 64 MB is exactly exactly 10% of the...

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

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

Viewing 15 posts - 3,736 through 3,750 (of 9,244 total)