Forum Replies Created

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

  • 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

  • RE: Assigning virtual NIC's to individual sql instances

    Yes you are able to tell a sql server instance which IP address and ultimately which NIC to listen on. Check books online for more info

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

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

    April 1, 2015 at 4:16 am

    #1787939

  • RE: Relocating the Log file of a merge subscription database.

    Duran (3/31/2015)

    I was going to stop/disable the merge jobs on the distributor, detach the database, move the log file to another drive, reattach, and enable the merge jobs on the...

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

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

    April 1, 2015 at 4:14 am

    #1787938

  • RE: ArcGIS server 10.3 and sqlserver 2014

    check with the vendor whether they support SQL Server 2014 at the ArcGIS product level you are intending to use

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

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

    April 1, 2015 at 4:11 am

    #1787936

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