Forum Replies Created

Viewing 15 posts - 2,176 through 2,190 (of 9,241 total)

  • RE: Delete or truncate

    try reading the log to see if there's any detail in there

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

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

  • RE: transfer a login with password from SQL 2012 to SQL 2008

    is it not an option to just reset the password

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

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

  • RE: Availability Groups Setup Question

    pre staging the AD computer account and DNS record for the listener is a common task and so wont be an issue. As you've found out already just unbind the...

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

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

  • RE: How to compress the data transfer during synchronisation between availability group nodes?

    ideally you'd separate the mirror traffic down a separate connection to guarantee performance and security

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

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

  • RE: Need of clustering

    Sree Divya (4/13/2015)


    thanks

    can any one tell differences between clustering and always on

    Check out my HA stairway on this site starting at this link[/url]

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

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

  • RE: Sql server 2014 with Windows server 2012 R2 - Datacenter

    MotivateMan1394 (4/12/2015)


    Hi

    we want to change version of our servers to these versions :

    - windows server 2012 R2 Datacenter

    - sql server 2014 (without any packs)

    Are they compatible with each other?

    thank...

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

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

  • RE: Runnin Multiple Instances on 2 nodes, one AoHA, one Mirroring

    Leo.Miller (4/12/2015)


    I'm looking at installing 2008R2 and 2014 side by side, then using Mirroring to provide HA for the 2008R2 instance and AoHA for the 2014 instance. I'd be using...

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

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

  • RE: Question on Alwayson and sql agent job

    the only other option I can think of immediately is a parent job which runs and checks whether the AO replica is primary or not. If primary it calls the...

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

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

  • RE: Question on Alwayson and sql agent job

    youre welcome

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

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

  • RE: Question on Alwayson and sql agent job

    if its not the primary just use sp_stop_job on the job name\id

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

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

  • RE: Add instance to 2012 cluster "instancename" parameter missing

    Indianrock (4/12/2015)


    add a new failover cluster

    Means create a new clustered instance of sql server, has nothing to do with any existing instances

    You will require

    • new shared disks
    • new IP address
    • new networkname

    Indianrock (4/12/2015)


    add...

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

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

  • RE: Using DPM to restore COPY_ONLY FULL + TLOGs for an Availability Group

    Adam Bean (4/10/2015)


    Hey all,

    This really isn't a DPM specific matter, but more so my lack of understanding of how copy_only truly works.

    I've verified that DPM inherits an availability group's backup...

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

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

  • RE: Whats the exact link where I can download SQL Server 2012 EVALUATION edition ?

    the first link lists as SQL Server 2012 RTM

    the second is 2012 with SP1

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

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

  • RE: enabling RCSI.....correctly

    SQLJay (4/9/2015)


    Reading one the replies above states the latter statement is not necessary if set READ_COMMITTED_SNAPSHOT has been executed

    That's not entirely correct. This link details the following

    Microsoft TechNet


    When to Use...

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

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

  • RE: Relocating the Log file of a merge subscription database.

    you're welcome

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

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

Viewing 15 posts - 2,176 through 2,190 (of 9,241 total)