Forum Replies Created

Viewing 15 posts - 5,956 through 5,970 (of 9,244 total)

  • RE: Certificate files are not visible on shared folder

    What share\NTFS permissions are set for Certstore?

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

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

  • RE: Upgrading SQL Server 2008 From Standard Edition to Enterprise.

    When you launch the sql server installer exactly which option are you selecting?

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

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

  • RE: 3 node clustering in sql server 2008 R2

    Are you trying to use the same group for the new instance on node b that is already in use for the instance on node a

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

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

  • RE: Change Service Account - Impact on Mirroring

    SQLback (2/22/2012)


    It worked. Thanks for the advice.

    You're welcome

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

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

  • RE: 3 node clustering in sql server 2008 R2

    Sapen (2/21/2012)


    I was wondering how the cluster would appear in my scenario (behavior of passive node(Node C)). On one active node(Node A) I want to have instance1 and on the...

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

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

  • RE: an i use same instance on single server for Primary & Secondary database for Log shipping

    kumar.sachu08 (2/21/2012)


    Hi,

    I would like to know....Can i use same instance on single server for Primary & Secondary database for Log shipping.

    I have only one server and one instance.

    Regards,

    Sachin.

    No you cannot,...

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

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

  • RE: Cause of High Mirror Commit Overhead

    have you verified connectivity\latency between the instances

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

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

  • RE: Max Memory - SQL Server 2008 R2 Enterprise Edition (64-bit)

    Completely understand, but in my experience pointing out their flawed maint plan and correcting it should serve to gain you a little kudos and maybe even an extension to your...

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

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

  • RE: Are you using heartbeat in SQL 2008 R2 clusters

    Quite agree, as I said I did not design\deploy the current cluster I work with, if I had I would not have used dedicated heartbeat NICs 😉

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

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

  • RE: Max Memory - SQL Server 2008 R2 Enterprise Edition (64-bit)

    WRACK (2/20/2012)


    Perry Whittle (2/20/2012)Wow, you do like to make your server work for a living don't you 😉

    I am not a DBA for this company, just a temp assignment for...

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

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

  • RE: Upgrading a SQL Server 2005 Clustered Environment to SQL Server 2008 R2

    oradbguru (2/20/2012)


    Has anyone out there upgraded a SS 2005 clustered environment to 2008 R2. Looking for tips and whatever input you may have based on your experiences. I...

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

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

  • RE: Max Memory - SQL Server 2008 R2 Enterprise Edition (64-bit)

    GilaMonster (2/20/2012)


    My point still stands, if SQL is on a non-dedicated server, then setting a sensible max server memory is almost essential

    Agreed, that and removing wacko maintenance plans 😀

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

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

  • RE: Max Memory - SQL Server 2008 R2 Enterprise Edition (64-bit)

    WRACK (2/19/2012)


    Perry Whittle (2/19/2012)


    WRACK (2/19/2012)


    but it does a lot more than just Reindexing.

    Exactly what does it do?

    * Sets some database to Simple Recovery Model

    * Sets AUTO UPDATE STATISTICS on some...

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

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

  • RE: Max Memory - SQL Server 2008 R2 Enterprise Edition (64-bit)

    WRACK (2/19/2012)


    but it does a lot more than just Reindexing.

    Exactly what does it do?

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

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

  • RE: how to fix the orphaned users problem

    gantavasu (2/18/2012)


    Sorry not like that i have moved the database from one server to another server here i am getting this problem. and also i don't have the exact idea...

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

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

Viewing 15 posts - 5,956 through 5,970 (of 9,244 total)