Forum Replies Created

Viewing 15 posts - 3,421 through 3,435 (of 9,241 total)

  • RE: Moving Clustered Instances

    [Url=http://technet.microsoft.com/en-us/library/bb510680.aspx] This[/url] details the compatibility levels.

    There's no real need to panic. Why not set up a test system and verify the platform.

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

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

  • RE: Procedure to upgrade and rollback Sql Server 2012 to Sql Server 2012 SP1

    Backup all your databases and install SP1

    If you don't like it remove it via Add\Remove programs 😉

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

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

  • RE: Database Backup

    Caruncles (3/25/2014)


    Primary server:

    Microsoft SQL Server 2008 (SP3) - 10.0.5512.0 (X64) Aug 22 2012 19:25:47 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT...

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

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

  • RE: Moving Clustered Instances

    As i said previously, once you do this

    jayoub (3/24/2014)


    I would like to take these two servers off the network (disable the NIC)

    You will not be able to do this

    jayoub (3/24/2014)


    Installing...

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

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

  • RE: Register SPN for SQL Service account

    Do you have permission within AD to create SPNs?

    If not you'll need a domain admin to do this for you.

    The instance name in the SPN registration is only for connections...

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

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

  • RE: Database Backup

    Caruncles (3/25/2014)


    Sorry, I wasn't trying to invade the space. I've been scolded before for asking a question which has already been answered and didn't want to muddy up the...

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

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

  • RE: Register SPN

    Grace09 (3/24/2014)


    How should I register SPN for SQL Server 2008?

    1. It is a cluster environment

    2. It is named instance

    3. It is not using default tcp port.

    Would the followings be...

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

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

  • RE: Cluster 2008, want to add a new ip address for the virtual sql resource

    This details how to change the IP address, incidentally why aren't clients connecting via the virtual network name?

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

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

  • RE: Cluster 2008, want to add a new ip address for the virtual sql resource

    are you trying to change the IP address?

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

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

  • RE: Moving Clustered Instances

    jayoub (3/24/2014)


    I am working on migrating an SQL Cluster from Windows Server 2003 SQL 2005 to Windows Server 2008 SQL 2005 and I am considering doing the following:

    Install Windows...

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

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

  • RE: Restoring a TDE enabled database question

    jasona.work (3/22/2014)


    So, I may need to enable TDE on some DBs in the near future, and I want to get everything clear in my head. I understand the basics...

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

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

  • RE: Physical Server vs. VM Pros & Cons

    keyun21 (3/21/2014)


    Hi Raymond,

    Thanks for your reply, our main concern is running ETL as we crunch lot of data. There is already a performance issue where we are fixing it. Plus,...

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

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

  • RE: Physical Server vs. VM Pros & Cons

    Yes really, memory and cpu can be over committed usually without too much problem. If you follow the best practice and avoid over committing then cpu and memory will never...

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

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

  • RE: Physical Server vs. VM Pros & Cons

    the biggest problem with VMs is storage performance which for your DW you'll probably need. Virtual disks are generally good for standard sequential I\O but suck for random I\O. There...

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

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

  • RE: Availability Groups and Failover Cluster Instances

    shahgols (3/21/2014)


    Hi everyone, I'm reading up on Always on and I am confused what is the difference between AlwaysOn Availability Groups and AlwaysOn Failover Cluster Instances. Can you shed...

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

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

Viewing 15 posts - 3,421 through 3,435 (of 9,241 total)