Forum Replies Created

Viewing 15 posts - 1,801 through 1,815 (of 9,244 total)

  • RE: Have to remove DB and join DB back to AG to fix out of sync issue

    are your backups preferred on the primary or a secondary?

    how often do the full backups run?

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

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

  • RE: always on error

    worker thread exhaustion can be an issue, can you provide more detail on the number of databases on the instance configured for HADR?

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

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

  • RE: MSDTC in a multi-node, multi-instanced cluster

    Adam Bean (8/17/2015)


    1) Do you really need DTC per instance or one for all?

    depends how busy the instances using DTC will be, if you expect high volume then 1 per...

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

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

  • RE: Always on administration

    TheSQLGuru (8/18/2015)


    (if AG fails over, how would log shipping work then?)

    It involves a special LS configuration and requires in depth knowledge

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

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

  • RE: Have to remove DB and join DB back to AG to fix out of sync issue

    find out why the data movement is being suspended in the first place, can you provide more detail as to what exact messages you receive, stop the sync issues to...

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

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

  • RE: Problem with making single subnet cluster multi-subnet

    can you provide a resource dependency report please using the following

    get-clusterresourcedependencyreport -group YourAG_Name | copy-item -destination drive:\somefolder

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

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

  • RE: Do the managed local accounts (virtual accounts) remove need for multiple domain accounts

    RonKyle (8/14/2015)


    Thanks for that clarification. So if I don't need the instance to act within an Always On group or cross domains, a virtual service account should be sufficient,...

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

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

  • RE: Ip required to set up 2 node active passive cluster

    atulyan.aries (8/14/2015)


    Hi,

    Kindly let me know apart from the following what else is required

    2 for private network

    2 for public network ......

    1 for virtual server/windows cluster ip which is...

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

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

  • RE: SAN confusion

    have you checked the local settings, for example HBA settings and firmware

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

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

  • RE: Has log-shipping been marked for deprecation?

    it's still CTP at present and I think will change, the CTP is a taster of what's coming 😉

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

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

  • RE: Has log-shipping been marked for deprecation?

    Beatrix Kiddo (8/14/2015)


    Please help me settle an argument. I say it hasn't.

    What do you say?

    with the introduction of basic AO groups in standard edition of sql server 2016 I...

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

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

  • RE: Do the managed local accounts (virtual accounts) remove need for multiple domain accounts

    RonKyle (8/13/2015)


    1. Create a managed service account. This is created at the domain level and assigned to a single computer to run a service. The name has a $...

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

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

  • RE: Login failure - unable to connect to sql server using windows authentication

    JManuelN (8/14/2015)


    Hi,

    Also check the first lines in the error log if there are messages related to SPN registration like this one.

    --The SQL Server Network Interface library could not register...

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

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

  • RE: Get file sizes of database files and free space on disk

    Jonathan AC Roberts (7/24/2015)


    Hi Christopher

    The script only calls xp_fixeddrives if the version of SQL server is below 2008, When the version is 2008 or higher it uses dm_os_volume_stats and reports...

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

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

  • RE: SQL 2008 Cluster upgrade to 2008 R2

    AndeT (1/13/2011)


    All -

    I'm trying to find some documentation or any type of information regarding upgrading a 2008 cluster to 2008 R2 - SQL Upgrage only. I've been looking and...

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

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

Viewing 15 posts - 1,801 through 1,815 (of 9,244 total)