Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 9,244 total)

  • RE: Alwayson on WSFC - is shared disk really not needed ?

    szejiekoh (8/22/2016)


    But Alwayson sit on WSFC (assume it is a 2 node WSFC) - surely WSFC would need a shared disk (voting/witness) for maintaining quorum ?

    If your WSFC only...

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

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

  • RE: How to recover SQL Jobs?

    it's a good idea to script out your jobs and keep them with your source, although backups are still preferrable

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

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

  • RE: sql server 2016 database install

    have you tried a restore via TSQL?

    Can you post any error messages you see in the restore dialog?

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

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

  • RE: RAID DISK SETUP ON NEW SERVER WITH MSSQL 2016

    bugg (8/23/2016)


    Any thoughts on this setup for disks

    Total disks: 6 Std HD + 6 SSD

    OS - HD - RAID 1

    SQL SERVER - HD - RAID 1

    BACKUPS -...

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

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

  • RE: SQL Server Upgrade from 2008 Standard to 2014 or 2016

    upgrade to 2016, you'll only have to re run an upgrade at some point to 2016 anyway

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

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

  • RE: SQL Server 2012 upgrade to 2014

    Raghavender (8/15/2016)


    Hi All,

    I am trying to upgrade SQL Server 2012 evaluation edition to SQL Server 2014 Evaluation edition.

    On Installation wizard when I click on upgrade option, it is not displaying...

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

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

  • RE: OS Error 5: Access is denied on attach

    logon as a windows admin and take ownership of the files. Once done, remove all ACLs and add back the sql server service account with full control

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

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

  • RE: Always On and version store

    can you reproduce this under normal circumstances?

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

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

  • RE: AlwaysOn failback after DR

    JarJar (8/17/2016)


    i'm not clear on something about the AlwaysOn failback.... say we failover to our DR site after an outage on our primary site. the outage lasts for...

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

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

  • RE: upgradtion 2014

    ramyours2003 (8/16/2016)


    I need to upgrade sql 2008 to sql 2014 and the databases are configured in logshipping , can any one send me the steps to upgrade the sql...

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

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

  • RE: Clustering SQL Agent

    shahgols (8/13/2016)


    Hi all,

    I'm a clustering newbie, have a task to set up clustering and part of the requirement is to cluster the jobs as well. So, if server...

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

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

  • RE: OS Error 5: Access is denied on attach

    right click each of the database files and go to the security tab, what accounts are listed and what permissions?

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

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

  • RE: What Bit AES used in ALWAYSON Endpoints?

    the default encryption in sql server 2016 is AES, I'm fairly certain that in 2014 it's RC4. The block length for AES is not listed as configurable for the create...

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

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

  • RE: SQL 2014 Cluster Install Error

    qew420 (8/17/2016)


    Reports are clean, no errors reported except one warning

    Network Binding

    "Domain network is not the first Bound network" this will cause Domain network to cause Domain operation to...

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

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

  • RE: Question about clustering a shared storage for database file on SQL Server 2016

    luisalfonso70 (8/12/2016)


    Hello, I've read about the options for failover cluster on SQL Server 2016, so if I want to have high availability with my SQL Server I've to:

    ...

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

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

Viewing 15 posts - 1,171 through 1,185 (of 9,244 total)