Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 9,244 total)

  • RE: Migrating from 2008 R2 to 2014 to new hardware with changing path for files

    SQL Guy 1 (8/5/2015)

    But my concern is there are any implications of this change? Are there any internal SQL Server processes or scripts that rely on pseudo-standard [Drive Letter]:\Program...

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

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

    August 6, 2015 at 4:46 am

    #1817808

  • RE: How to add datafile to mirrored database in primary server

    New persopn (8/5/2015)

    Hi All,

    I need some clarificantion about adding file in to mirrored dataabse in primary server without downtime and breaking the mirror server.

    In our environment we are using monutdisks...

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

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

    August 5, 2015 at 10:16 am

    #1817621

  • RE: file server / SQL cluster

    setup a new clustered fileshare resource that will make the location available regardless of which node it is on

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

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

    August 5, 2015 at 8:12 am

    #1817549

  • RE: Temp Db issue

    after setting the tempdb file sizes you'll need to restart the sql server service

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

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

    August 3, 2015 at 6:43 am

    #1816780

  • RE: Windows and SQL failover cluster setup

    keshab.basnet (7/31/2015)

    During the windows failover cluster set up, we need to be logged in by local administrator log in of Each cluster Node or by domain admin...

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

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

    August 3, 2015 at 6:40 am

    #1816777

  • RE: AG in Resolving state

    SQLHeap (7/30/2015)

    I have a 2 node cluster on server 2012r2/sql2014. Recent patching (thanks MS) took down one of the nodes hard. The second one won't come out of...

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

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

    July 31, 2015 at 5:16 am

    #1816394

  • RE: upgradingSQL 2008 R2 active\active Cluster to SQL 2014 cluster

    FTdenali (7/31/2015)

    That part I understand, but can I upgrade sql without using slipstream option if I have SQL 2014 SP1 image?

    If you have a sql2014 SP1 dvd image then you...

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

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

    July 31, 2015 at 5:15 am

    #1816393

  • RE: Monitor AG Listener Remotely

    Normally I'd give my standard response, "all pirates should find their own treasure". However, seeing as I'm in a good mood here you go

    Get-ClusterResource -Cluster "theWindowsClusterName" |

    ?{$_.resourcetype -EQ "IP...

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

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

    July 30, 2015 at 10:57 am

    #1816235

  • RE: upgradingSQL 2008 R2 active\active Cluster to SQL 2014 cluster

    FTdenali (7/30/2015)

    Thanks, and is it true that upgrading SQL 2008 R2 to SQL 2014 on windows 2008 R2 SP1 can only be done the Slipstream way?

    No, there is a misunderstanding...

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

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

    July 30, 2015 at 10:30 am

    #1816231

  • RE: Restore Database permission failure

    wayne.mcdaniel (7/29/2015)

    * The user is a member of the dbcreator role - and the serveradmin and sysadmin roles

    Once you grant sysadmin to an account all further permission checking is disabled,...

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

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

    July 30, 2015 at 10:27 am

    #1816228

  • RE: Clustered instance uninstall

    shawnjohnson (7/27/2015)

    Do the services need to start on the active node? I am removing this instance from the cluster (uninstall on both nodes) and didn't know if at some...

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

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

    July 30, 2015 at 4:37 am

    #1816061

  • RE: how to configuer alwayson between two differ network section

    first place to start is to check out my stairway to HA on this site starting at this link

    http://www.sqlservercentral.com/articles/Failover+Clustered+Instance+(FCI)/107536/

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

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

    July 30, 2015 at 4:34 am

    #1816058

  • RE: upgradingSQL 2008 R2 active\active Cluster to SQL 2014 cluster

    FTdenali (7/27/2015)

    SQL 2008 R2 enterprise with SP2 and CU.

    the current environment is running Windows 2008 R2 enterprise.

    It would make sense to update the Windows OS platform too as Windows 2008...

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

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

    July 30, 2015 at 4:30 am

    #1816056

  • RE: One Node could not up in SQL Server Failover cluster

    let's see a cluster validation report first please

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

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

    July 30, 2015 at 4:26 am

    #1816051

  • RE: SQL AG - Listener

    sqlrob (7/28/2015)

    Hello

    I have built a SQL 2014 Always on Cluster. I need to create three Availability groups and listeners in the same instance. Do I need 3 separate IP...

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

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

    July 30, 2015 at 4:25 am

    #1816050

Viewing 15 posts - 1,846 through 1,860 (of 9,244 total)