Forum Replies Created

Viewing 15 posts - 3,286 through 3,300 (of 9,244 total)

  • RE: SQL 2014 AG with 2012 Replica

    No, it should be detailed under backup\restore databases. You cannot move down versions, only upwards

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

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

  • RE: How to create a SQL 2012 Failover cluster using VMs?

    Keep an eye out for part 4 later this month , you'll love it.

    Please don't forget to rate the articles if you found them useful

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

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

  • RE: Cannot connect with read only intent when using listner name

    Sure no problem

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

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

  • RE: Changing Availability Group

    What error or messages were you receiving?

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

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

  • RE: Changing Availability Group

    Ratheesh.K.Nair (5/7/2014)


    they backup is preferred to secondary at present..

    This is the default option and backups will occur on a secondary unless the Primary is the only replica online.

    Ratheesh.K.Nair (5/7/2014)


    Not able...

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

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

  • RE: sql db backup t-sql

    niklasrene (5/7/2014)


    What is wrong?

    The colons in the time portion of the filename are not valid path\file name characters

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

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

  • RE: Cluster resource 'SQL Server' failed

    inevercheckthis2002 (5/6/2014)


    spaghettidba (5/5/2014)


    Ok, so no resource exhaustion event.

    You should monitor the memory counters in Windows and see if they get too low.

    If this is a SQL Server only box, you...

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

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

  • RE: Identifying what caused Corruption

    Do you understand the ramifications of the below??

    winston Smith (5/7/2014)


    Repair: Deleted off-row data column with ID 562825134080, for object ID 1076927654, index ID 1, partition ID 72057594039566336, alloc unit ID...

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

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

  • RE: SQL 2014 AG with 2012 Replica

    slim.richard (5/7/2014)


    Hi all,

    Is it possible to have a 2014 Availability Group with a read-only secondary Replica in SQL 2012. The replica will never be failed over to or written to,...

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

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

  • RE: AlwaysOn - use an Availability group listner or just point to the Cluster name

    winston Smith (5/7/2014)


    Yep, thats the crux of the post, i want to resolve this 🙂

    ok, so create a listener for your AlwaysOn group

    winston Smith (5/7/2014)


    so there is nodeA & nodeB...

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

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

  • RE: AlwaysOn: Client (Re)Connecting to wrong server after fail-over?

    What does the AlwaysOn groups read only routing url config look like, specifically the url order for each replica when in the primary role

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

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

  • RE: Cannot connect with read only intent when using listner name

    Have you checked the readonly routing url configuration?

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

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

  • RE: How to create a SQL 2012 Failover cluster using VMs?

    APA0876 (5/6/2014)


    Yes I'm reviewing them

    Thanks

    OK, well if you're putting this into production ensure the hosts are well specced.

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

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

  • RE: How to create a SQL 2012 Failover cluster using VMs?

    APA0876 (5/6/2014)


    what is the difference on the creation of a SQL cluster on sql server 2008 R2 and SQL Server 2012?

    Thanks

    The installer is pretty much the same with some slight...

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

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

  • RE: AlwaysOn - use an Availability group listner or just point to the Cluster name

    winston Smith (5/6/2014)


    I have MasterDataServices installed on a server and the database is in an AlwaysOn Availability Group.

    The MDM front end currently is set up incorrectly and is referencing NodeA...

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

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

Viewing 15 posts - 3,286 through 3,300 (of 9,244 total)