Forum Replies Created

Viewing 15 posts - 1,471 through 1,485 (of 9,244 total)

  • RE: AlwaysOn - Read Only Replica's

    Perry Whittle (1/19/2016)


    you also need to specify the database name in the connection string otherwise it doesn't know where to route the query to

    :Whistling:

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

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

  • RE: Virtual Server Name

    ramana3327 (1/18/2016)


    while trying to connect from SSMS I am able to connect when I use SQL14\SQLCluster14 only.

    That is correct, the instance connection is made to

    networkname\instancename

    so

    SQL14\SQLCluster14

    ramana3327 (1/18/2016)


    I can't able to...

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

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

  • RE: sql server 2014 ag on vmware vs vmotion

    krypto69 (1/19/2016)


    why would you need both AG and vmotion?

    VMotion is the mechanism VMware uses to migrate a running VM from one host to another.

    An Availability group provides redundant copies...

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

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

  • RE: sql server 2014 sp1 brings down cluster

    tcronin 95651 (1/19/2016)


    yes was going to add 2nd instance this week but this SP1 issue has me worried. I have seem some links to solution with registry changes, not...

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

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

  • RE: AlwaysOn - Read Only Replica's

    you also need to specify the database name in the connection string otherwise it doesn't know where to route the query to

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

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

  • RE: Recommended SQL Backup Software?

    bsmith 63193 (1/19/2016)


    Our organization is currently looking at a more robust SQL backup software than what we are currently using and was wondering what other organizations would recommend. I have...

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

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

  • RE: Time and Space: How to Monitor Drive Space in SQL Server

    For more info on mounted volumes see my article at this link[/url]

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

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

  • RE: Time and Space: How to Monitor Drive Space in SQL Server

    Ed Wagner (1/19/2016)


    If, by mounted volumes, you mean drive letters that point to LUNs on a SAN, then yes, it works fine.

    No the user is referring to volumes that mount...

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

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

  • RE: sql server 2014 sp1 brings down cluster

    tcronin 95651 (1/14/2016)


    I have a one node(waiting on delivery of 2nd node) active/passive cluster win 2012 and sql 2014. WHen i apply sql 2014 sp1 it fails and takes...

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

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

  • RE: FULL control or just modify on MSSQL folder for tempdb logs?

    modify does not allow the user to take control of any folders or files within the parent folder where the permissions are granted (assuming inheritance has not been disabled).

    You probably...

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

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

  • RE: SAS or iSCSI?

    SAS is the actual disk type, iSCSI or FC are the actual protocols. What are your concerns

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

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

  • RE: Permissions on Log Shipping Secondary

    dropping or disabling the logins on the primary would get you round this

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

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

  • RE: Mounted Volume Displays GUID and not Mounted Volume Path in Windows Server 2012 R2 Cluster

    These are shared disks correct?

    How are they presented to the server?

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

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

  • RE: Mounted Volume Displays GUID and not Mounted Volume Path in Windows Server 2012 R2 Cluster

    are you using the new Windows 2012 disk management tool or the old disk management snapin

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

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

  • RE: TDE - Managing Certificates.

    you're welcome

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

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

Viewing 15 posts - 1,471 through 1,485 (of 9,244 total)