Forum Replies Created

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

  • RE: SQL Server 2012 AlwaysOn

    chewychewy (3/27/2014)


    Hi Guys,

    Need your advise here.

    Anyone did such setup with AlwaysOn Avail Group?

    We are looking into using AlwaysOn Avail Group for the purpose of HA.

    Server A: Instance A with (DB1,DB2,DB3,DB4,DB5)...

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

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

  • RE: Problem with Mirroring (SQL 2012)

    cesarscorp2 (3/26/2014)


    Thanks for the recomendation but I checked these options but the problem persist.

    I think the problem is about the service account but I don't know What is the account?

    first...

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

    "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

    You remove just the SP via add/remove programs it rollback for you. The backups are for if anything goes bang! !

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

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

  • 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" 😉

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