Forum Replies Created

Viewing 15 posts - 2,866 through 2,880 (of 9,241 total)

  • RE: LogShipping: last_backup_file, last_backup_date stays NULL

    Can you confirm the sql server patch level please

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

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

  • RE: Configuring Failover clustering in sql 2012

    sej2008 (10/13/2014)


    I am working for failover clustering in sql 2012 enterprise edition(64bit) on a

    single box with 3 vmware(7.0) installed with OS windows server 2008R2 enterprise edition with SP1.

    Now I...

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

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

  • RE: SQL Server 2014 AlwaysOn Availability with SQL server 2012

    you could have a SQL 2012 as a primary and a SQL 2014 as secondary, the moment you failover though, the 2012 database is dead!

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

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

  • RE: Log Shipping Files getting huge and difficult to transfer

    alejandro-jasso (10/12/2014)


    Hi Perry,

    I tried doing your suggestions.

    I allowed maintenance plan to finish, I stopped LS during this time. Once Maintenance was finished, I took differential Backup but still this backup...

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

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

  • RE: Add instance to sql 2012 cluster

    If you're just adding a new instance of sql server thats alreaqdy installed you shouldnt need a rebot, should be fine

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

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

  • RE: Max Length of AD Names for Security

    SQLJocky (10/10/2014)


    Not really buying that

    That's good cos i'm not selling 😉

    As already pointed out the max length for a SQL server security principal is SYSNAME which is NVARCHAR(128). This would...

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

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

  • RE: Create Login for Local Windows group on 2008 R2 Cluster

    whether you refer to the group via a node name or the virtual network name it will not work.

    Windows Server Failover Clusters rely heavily on DNS and Active Directory, you...

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

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

  • RE: Add instance to sql 2012 cluster

    Indianrock (10/8/2014)


    We have an active/active two-node QA cluster with four instances of sql. I need to add a fifth. In the past I always moved existing instances to the...

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

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

  • RE: Max Length of AD Names for Security

    The SAM account name is only a single portion of the AD full object name, it will also inherit container and domain name.

    The reason these objects are small is to...

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

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

  • RE: Log Shipping without truncation

    all log operations are the responsibility of the LS agent job. I'd be highly surprised if comvault cant be told to skip databases. At the least just disable it and...

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

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

  • RE: Log Shipping Files getting huge and difficult to transfer

    alejandro-jasso (10/8/2014)


    Hi,

    Currently I have 2 SQL 2008 Standard Edition servers with one DB that is configured to do log shipping between them. These 2 servers are is same network so...

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

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

  • RE: LogShipping: last_backup_file, last_backup_date stays NULL

    You're misinterpreting the data in the tables. Whether the monitor server is on the primary or secondary instance it makes no difference.

    The table msdb.dbo.log_shipping_monitor_primary on the Primary instance will...

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

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

  • RE: Can we install a 2012 cluster on a LPAR?

    Jake Shelton (10/8/2014)


    Would be good to know if anyone has cluster running now on an LPAR - I know on a VM its possible.

    Thanks,

    Jake

    LPAR has no relevance in Windows, can...

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

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

  • RE: SQL Server Authentication Error

    Before you just start switching lets establish a few facts

    • Who deployed the instance, was it you?
    • Do you have membership of sysadmin role in the instance?
    • Is this instance shared and for...

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

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

  • RE: DR Recovery Back to Primary DC

    Andy Hyslop (10/7/2014)


    Its a good point Perry - depends on the bandwidth of your pipes however - if you have (and the business is willing to pay for) an extremely...

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

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

  • Viewing 15 posts - 2,866 through 2,880 (of 9,241 total)