Forum Replies Created

Viewing 15 posts - 1,141 through 1,155 (of 9,244 total)

  • RE: migrating sql server 2005, 2008 and 2012 to 2014 on new server new storage

    ysrhashmi (10/16/2016)


    4) Over the SAN, drives would be copied. So, just attach the user databases in target

    Introducing these into the cluster as disk resources can be tricky unless you know...

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

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

  • RE: Mirroring between two servers

    Aatish Patel (10/19/2016)


    SQL 2015 EE

    2015 huh that's a new one

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

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

  • RE: Cluster On Cross Domain

    Raghavender (10/14/2016)


    Hi All,

    Could you please help me in setting up SQL Server cluster in cross domain.

    What are the prerequisites, what are the precaution we need to take.

    Is there any guide...

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

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

  • RE: nodes in cluster

    ramyours2003 (10/17/2016)


    what are possible and preferred owners in cluster ?

    The possible node property applies to each and every cluster resource with a cluster role\group, this dictates on which nodes the...

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

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

  • RE: FCI + AG Alwayson 2014

    Talib123 (10/17/2016)


    AO failover can only occur between A or B to C.

    also note that this failover cannot be automatic, it must be manual failover

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

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

  • RE: How to recover AG when error is SUSPEND_FROM_CAPTURE

    find it hard to believe theres no information in the sql server log or event logs

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

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

  • RE: Help with SQL 2012 to SQL 2016 P2V considerations

    webrunner (10/10/2016)


    Thanks very much for your feedback. We are going to enlist help from Microsoft in addition to my own assessment of our current environment.

    - webrunner

    You really need a consultant...

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

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

  • RE: Question about adding TDE to an existing database

    Manic Star (10/11/2016)


    Have about 3 databases that are each a bit shy of a terabyte in size participating in an Availability Group.

    Been told by an auditor that we...

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

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

  • RE: Server role db_creator not working same in 2016 as 2012/2014

    use my query above to check the mapping, this will confirm the account marked as the database owner

    select s.name, SUSER_SNAME(s.owner_sid)

    from sys.databases s

    where s.database_id = DB_ID('yourdb')

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

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

  • RE: Re-porption SQL Data files

    coreyjbaum (9/28/2016)


    I have a single data file thats over 5tb in size and id like to split it up into multiple files across multiple drives. Whats the best way to...

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

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

  • RE: Moving Domain

    Stuart Davies (10/7/2016)


    I'm looking for some clarity on how, or if a SQL server (various versions 2008R2 through to 2014) can be migrated to a new domain. I have...

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

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

  • RE: SQL 2014 Backup Encryption

    Terrie (9/29/2016)


    I've read several articles and examples about backup encryption. My question is when I have multiple databases (but not all) on the same SQL Server than need to...

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

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

  • RE: WFC Wont online a newly upgraded SQL 2016 engine

    what errors are you seeing in the cluster events and application log

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

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

  • RE: Migrating to SQL Server 2016

    David92595 (9/22/2016)


    I'm currently running SQL Server 2008 R2 and a mirror with the same version. I'm contemplating upgrading to 2016. Eventually I'd like to use the always on availability...

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

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

  • RE: Looking for experience with Xeon E7-8893 v4 on SQL 2016 Enterprise

    higher clock speed with less cores will help with licencing

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

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

Viewing 15 posts - 1,141 through 1,155 (of 9,244 total)