Forum Replies Created

Viewing 15 posts - 3,571 through 3,585 (of 9,244 total)

  • RE: AlwaysON Availablity groups and listeners

    No, listeners are per availablility group. Don't confuse the AO listener with Oracle listeners

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

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

  • RE: Full backup Checkpoint LSN does not match Differential DatabasebackupLSN

    TerrenceTheCat (2/13/2014)


    Hi Perry,

    Thank you so much for your help. Below is the output from the query you asked me to execute

    (No column name)name ...

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

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

  • RE: windows cluster quorum setting on windows server 2012

    muthyala_51 (2/12/2014)


    Thanks a lot Perry !! I am also having trouble to understand what exactly the alwayson availability group listener is ? What this is used for? Does it acts...

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

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

  • RE: SQL Server Database Object Level Recovery and Idera SQLSafe Products

    I use the Litespeed suite including OLR. The Litespeed OLR is helpful, but as table object sizes grow, performing an OLR restore can take just as long as restoring the...

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

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

  • RE: TempDB datafiles

    peter.cox (2/12/2014)


    I have measured for Allocation, and there are (what I'd class as) a lot of pagelatch_ups.

    There are issues elsewhere; it's a single job, with 65 different steps. As I...

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

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

  • RE: Full backup Checkpoint LSN does not match Differential DatabasebackupLSN

    TerrenceTheCat (2/12/2014)


    Hi Everyone,

    I am testing a DR scenario at work but having problems. Our backup strategy consists of

    1 nightly full backup

    Differential backups every few hours

    Transaction log backups every 10 minutes

    I...

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

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

  • RE: Database mirroring quesions

    Oracle_91 (2/11/2014)


    1) Who is responsible for moving those transaction log records from Principal database to mirror database? I mean, who or which thread is going to read those log records...

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

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

  • RE: SQL Server Clustering and CSV's

    CSVs are not something i use, they do seem more to be tied to HyperV as a way of sharing VHDs. A little like VMWare VMotion. Why do you feel...

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

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

  • RE: moving log files in HA groups

    newbie_DBA (2/11/2014)


    trying to find out if this is the best way to move log files in databases that are in an availability group.

    remove the DB from the AG

    Run...

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

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

  • RE: TempDB datafiles

    peter.cox (2/12/2014)


    Morning all

    Got a puzzler here. Newish firm, with a massive overnight process

    Tempdb is a single datafile at the moment, on it's own 300GB disk. There are 12 cores, doubled...

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

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

  • RE: SQL Server Clustering and CSV's

    Cluster shared volumes are a feature of the Windows OS cluster suite. They are usable by SQL Server see this link.

    What is it you are trying to achieve?

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

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

  • RE: windows cluster quorum setting on windows server 2012

    muthyala_51 (2/10/2014)


    we are testing always on feature on our test servers. I kind of stuck at quorum settings. If the quorum file share location is placed on a server which...

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

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

  • RE: SQL Server 2012 AlwaysOn Groups and FCIs Part 1

    chuck.hamilton (2/10/2014)


    With SQL and AO, give me a scenario where some shared storage goes offline and it renders your data unavailable.

    I never said it did, you want to review...

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

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

  • RE: SQL Server 2012 AlwaysOn Groups and FCIs Part 1

    chuck.hamilton (2/10/2014)


    I am a multi-platform DBA.

    As am I

    chuck.hamilton (2/10/2014)


    With SQL + AO I have never experienced that because unlike RAC it is shared-nothing.

    That's not completely true and exactly what this...

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

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

  • RE: SQL Server 2012 AlwaysOn Groups and FCIs Part 1

    heb1014 (2/10/2014)


    Here is my question...what about the server hosting my business application?

    Without knowing a bit more about the app hard to say. First point of contact should be the...

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

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

Viewing 15 posts - 3,571 through 3,585 (of 9,244 total)