Forum Replies Created

Viewing 15 posts - 2,881 through 2,895 (of 9,253 total)

  • 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...

    October 8, 2014 at 6:39 am

    #1750925

  • 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...

    October 8, 2014 at 5:24 am

    #1750894

  • 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...

    October 8, 2014 at 12:05 am

    #1750824

  • 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...

    October 7, 2014 at 9:44 am

    #1750635

  • RE: The Microsoft JET Database Engine cannot open the file

    myoda (10/7/2014)

    I understand what $ means in the UNC path

    What does it mean?

    myoda (10/7/2014)

    If its a permission issue, why does it work from the server where SQL server 2012 is...

    October 7, 2014 at 9:40 am

    #1750633

  • RE: The Microsoft JET Database Engine cannot open the file

    sounds very much like a permissions issue. Do you understand what the $ means in the UNC path?

    October 7, 2014 at 8:29 am

    #1750606

  • RE: SQL Server Authentication Error

    HanShi (10/7/2014)

    If you (or the application) are not able to use Windows accounts (i.e. Windows integrated security), you need to change the authentication setting of the SQL instance to "mixed...

    October 7, 2014 at 8:21 am

    #1750603

  • RE: DR Recovery Back to Primary DC

    Talib123 (10/3/2014)

    Scenario

    AG failover to DR Node.

    Setup

    Server A – Primary Datacentre

    Sever B – Primary Datacentre

    Server Z – DR Datacentre

    Primary DC down. Manual Failover to DR Datacentre.

    Question.

    At the point of...

    October 7, 2014 at 8:16 am

    #1750598

  • RE: SQL Server Authentication Error

    the message details the problem exactly. The instance is configured for Windows auth only, can you login with a windows account?

    October 7, 2014 at 8:09 am

    #1750593

  • RE: Multi-Site Always On Failover Cluster Question for Experts

    Libby1981 (10/6/2014)

    Good Morning All:

    I have a question for SQL experts.

    We are implementing a multi-site (Windows Server Failover Cluster) WSFC to enable Always On between our primary and DR...

    October 7, 2014 at 5:05 am

    #1750519

  • RE: Database Mirroring-What Do I Backup?

    plamannkathy (10/4/2014)

    Anyway I just need an answer to what type of maintenance do I provide for these databases?

    The system databases on each instance would be advisable. The principal database needs...

    October 6, 2014 at 6:31 am

    #1750287

  • RE: How to apply patches in SQL server 2005 Active/passive cluster

    For SP4??

    October 3, 2014 at 1:34 am

    #1749885

  • RE: How to apply patches in SQL server 2005 Active/passive cluster

    solomon.jernas (10/2/2014)

    SQL SERVER patches, not windows.

    Yes but which sql patches?

    October 3, 2014 at 12:40 am

    #1749876

  • RE: default schema of windows group user

    He may be a member of another group

    October 2, 2014 at 12:28 pm

    #1749771

  • RE: default schema of windows group user

    Ok seems its changed in 2012 on, if there's a database user and a default schema is set then that is used. If not set then it's from the group,...

    October 2, 2014 at 10:42 am

    #1749745

    • Viewing 15 posts - 2,881 through 2,895 (of 9,253 total)