Forum Replies Created

Viewing 15 posts - 2,206 through 2,220 (of 9,244 total)

  • RE: Failed to Form a cluster. Witness was not accessible

    hdctest (4/2/2015)

    Hello,

    I have a SQL cluster and the Witness disk status shows as online but the passive node shows a "cluster event" that the passive node failed to form a...

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

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

    April 7, 2015 at 7:48 am

    #1789191

  • RE: Why do I leave my DB in Restoring State after attaching to the instance?

    Thinky Night (4/7/2015)

    Hi All,

    Why do I leave my DB in Restoring State after attaching to the instance? Could not this fire a redo activity on Transaction Log?

    Or, How does sql...

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

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

    April 7, 2015 at 7:28 am

    #1789186

  • RE: Always On with Cluster + Standalone Question/Discussion

    yb751 (4/6/2015)

    Do you mean that JUST the AO replica will need to be manually failed over?

    Yes exactly that. The FCI will behave as usual.

    If the FCI is unavailable then failover...

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

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

    April 6, 2015 at 10:11 am

    #1788961

  • RE: Extra Availability Group or Extra Instance

    if you have one node down for maintenance you dont need to do anything

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

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

    April 3, 2015 at 12:38 pm

    #1788652

  • RE: Always On with Cluster + Standalone Question/Discussion

    yb751 (4/2/2015)

    I would assume that in a failover the new active node would become the new host of the replica and not break the Availability Group.

    Correct. There would of course...

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

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

    April 3, 2015 at 12:36 pm

    #1788651

  • RE: Always On with Cluster + Standalone Question/Discussion

    Really looks more like this to be honest

    Microsoft do detail FCIs within AlwaysOn groups, check the following link

    https://msdn.microsoft.com/en-us/library/ff878487.aspx#FciArLimitations

    Also check my article at this link

    http://www.sqlservercentral.com/articles/FCI/92196/[/url]

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

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

    April 3, 2015 at 12:31 pm

    #1788650

  • RE: Recommended methods for login and job sync with AlwaysOn

    Scripting the logins is an easy task there are unlimited scripts around. You can also script any jobs from msdb too, you'll likely find many scripts for this too.

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

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

    April 3, 2015 at 11:45 am

    #1788638

  • RE: Port blocked, causes SQL Server to not start

    what port number have you selected?

    To see a list of processes listening on the server use the following

    netstat -abno -p TCP

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

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

    April 2, 2015 at 8:59 am

    #1788340

  • RE: Transaction log is full

    Ratheesh.K.Nair (4/1/2015)

    Remove the primary database from Availability Group. Shrink the DB and then add it back.

    This is the last thing you should do and you'd be well advised to avoid...

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

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

    April 1, 2015 at 8:17 am

    #1788025

  • RE: dbcc with physical only

    I use my own script which works out the day of the week and performs a lightweight physical_only check at peak times and a full check at least once a...

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

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

    April 1, 2015 at 5:49 am

    #1787975

  • RE: Transaction log is full

    Arjun SreeVastsva (4/1/2015)

    hi,

    my database transactionlog is full I am getting below error while shrinking and also my secondary database went to not synchronising mode/suspect mode .

    Msg 9002, Level 17, State...

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

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

    April 1, 2015 at 5:46 am

    #1787971

  • RE: script to find when index was created

    if the index is a PK constraint the Create date is on sys.objects

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

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

    April 1, 2015 at 5:12 am

    #1787953

  • RE: TDE enabled DB stuck in limbo during Decryption

    Have you stopped all connections to the database to allow the decryption to complete?

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

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

    April 1, 2015 at 5:00 am

    #1787951

  • RE: Stop Clustering Services

    Arjun SreeVastsva (3/31/2015)

    Hi,

    I have taken down time for patching in the my cluster servers.

    how to stop cluster services in my cluster servers and what is way

    Thanks,

    Sree

    Do you mean the cluster...

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

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

    April 1, 2015 at 4:57 am

    #1787950

  • RE: Can AlwaysOn primary replica a sql 2008 R2 and Secondary replica in SQL 2012?

    Pablo Campanini-336244 (3/31/2015)

    SInce they do not want to upgrade the current DWS servers. questions is:

    Can I have the primary replica in SQL 2008 R2 EE, and the other secondary replicas...

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

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

    April 1, 2015 at 4:17 am

    #1787940

Viewing 15 posts - 2,206 through 2,220 (of 9,244 total)