Forum Replies Created

Viewing 15 posts - 2,446 through 2,460 (of 9,244 total)

  • RE: Migration of AlwaysON database 2012 to 2014

    Fernando Jacinto Alvarez (1/29/2015)

    My boss want to migrate to sql 2014 currently we have another site and he wants to create a DR using AlwaysOn AG what do you suggest...

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

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

    January 30, 2015 at 5:16 am

    #1774300

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    level 7 is not published yet but you can find detail on combining an FCI into an AlwaysOn group starting at this link[/url]

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

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

    January 29, 2015 at 1:36 pm

    #1774174

  • RE: Advice for cross-site clustering

    check out my stairway series on this site for more info. Level 6 is due to be published soon and covers AlwaysOn Availability groups and readonly routing in detail.

    Part 1...

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

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

    January 29, 2015 at 1:34 pm

    #1774171

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    Perry Whittle (1/25/2015)

    Levels 1 to 4 detail the requirements for a windows server failover cluster, this forms the basis of either an FCI or an AlwaysOn Availability group setup.

    Level 5...

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

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

    January 29, 2015 at 11:59 am

    #1774142

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    sorry there's been so many posts here I'm lost in the myre now.

    Do you want to deploy an FCI only?

    If yes leave part 4 you don't need it

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

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

    January 29, 2015 at 11:59 am

    #1774141

  • RE: Re-establish mirroring after DR test

    Calvin Duffy (1/29/2015)

    No full backup was taken after the mirroring broke.

    If a full backup has occurred on the principal since mirroring broke you're stuck with re initialising mirroring unless...

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

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

    January 29, 2015 at 11:55 am

    #1774136

  • RE: Advice for cross-site clustering

    Ozzmodiar (1/29/2015)

    Sorry Perry, I dropped the ball on terminology there. It will be multiple AG's, not listeners. I had it in my head that the groups were 1...

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

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

    January 29, 2015 at 11:51 am

    #1774133

  • RE: CONVERT BYTES TO MB script?

    select SizeBytes, SizeBytes / 1024 As Megabytes

    from

    TESTTABLE

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

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

    January 29, 2015 at 11:17 am

    #1774118

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    you don't have an FCI to integrate so skip that, the portion that shows how to create an AO group will be relevant though

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

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

    January 29, 2015 at 11:15 am

    #1774115

  • RE: Re-establish mirroring after DR test

    So, has a full backup been taken on the principal since the mirroring broke?

    Use this query against the principal and then the mirror to ascertain if it has or not

    select...

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

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

    January 29, 2015 at 11:13 am

    #1774112

  • RE: Advice for cross-site clustering

    an Availability group can only have one primary read\write database, The remainder are readable secondaries!

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

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

    January 29, 2015 at 11:06 am

    #1774108

  • RE: CONVERT BYTES TO MB script?

    ncodd (1/29/2015)

    I need a simple script that will convert this field to MB & round up.

    Convert it to what?

    just divide it by 1024 will give whole MBs. Are...

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

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

    January 29, 2015 at 9:54 am

    #1774071

  • RE: Largest MS SQL Server Databases

    we have one here over 8TB in size and growing

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

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

    January 29, 2015 at 9:50 am

    #1774069

  • RE: Re-establish mirroring after DR test

    Calvin Duffy (1/27/2015)

    The mirroring type is "High Performance (asynchronous)". There are no witness server(s). Need to write to the database (Mirroring db not the primary db). Can't do role switching....

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

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

    January 29, 2015 at 9:48 am

    #1774067

  • RE: Advice for cross-site clustering

    so for a given AO group and database, all 6 instances will be replicas in that group?

    Which server have you reserved as your primary replica?

    Why sooo many listeners?

    Which site is...

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

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

    January 29, 2015 at 9:28 am

    #1774054

Viewing 15 posts - 2,446 through 2,460 (of 9,244 total)