Forum Replies Created

Viewing 15 posts - 1,576 through 1,590 (of 9,253 total)

  • RE: Cannot drop distribution database

    have you disabled replication on the server

    November 13, 2015 at 4:30 am

    #1839574

  • RE: Always on

    ramyours2003 (11/12/2015)

    can any one help on the dmv's how to check and trouble shoot the issues in always on group in sql ?

    what's wrong with the...

    November 13, 2015 at 4:25 am

    #1839572

  • RE: MSDTC Cluster, Is this really Neccesary

    David Rich (11/12/2015)

    We are planning for a 4 node multi subnet SQL cluster. My question is do i need to have MSDTC clustered? what i i dont have MSDTC....

    November 13, 2015 at 4:22 am

    #1839570

  • RE: AlwaysOn - moving databases to the "same drive"

    krypto69 (11/12/2015)

    then right click and 'suspend data movement' on all the DB's.

    Just suspend data movement on the primary and that will be enough

    krypto69 (11/12/2015)

    If all you doing is a direct...

    November 13, 2015 at 4:07 am

    #1839567

  • RE: Stopping SQL Services on a sql 2008 Cluster

    alnoor (11/9/2015)

    Hi Guys

    Whats the best way to stop/pause sql services on a cluster for maintenance.

    failover should not happen.

    Thanks

    Stop the clustered SQL Server resource using powershell

    stop-clusterresource "sql resourcename"

    November 10, 2015 at 4:41 pm

    #1839007

  • RE: Unable to open the physical file "D:\databasepc.mdf". Operating system error 5: "5(Access is denied.)".

    Raghavender (11/9/2015)

    Yes Even service accounts are added into admin group and we have given full control on the folder and files.

    adding an account to the local admins does not guarantee...

    November 10, 2015 at 4:38 pm

    #1839004

  • RE: AlwaysOn for HA/DR

    MadAdmin (11/10/2015)

    MS cannot remove mirroring unless they have a version of HA which will replace Mirroring.

    Yep, it's called Basic Availability groups in SQL Server 2016

    November 10, 2015 at 4:29 pm

    #1839003

  • RE: SQL 2014 SP1 Active Passive Cluster

    744 (11/5/2015)

    Hi,

    we needed to change the ports on the 3 named instances because of firewall rules.

    choose a free port for each instance from the upper port range and open the...

    November 9, 2015 at 10:58 am

    #1838629

  • RE: SQL Server resource question

    mark.williams 37494 (11/6/2015)

    Thank you for your reply Perry. I do understand what you are saying but why does'nt Failover Manager behave in the same way in terms of restart if...

    November 6, 2015 at 7:54 am

    #1838236

  • RE: multiple files what determines where an object goes

    tcronin 95651 (11/5/2015)

    I have a 3rd party database 1.7 terabytes. It has multiple file groups, and in 2 cases 9 files per group. When a object (ie lets...

    November 6, 2015 at 7:37 am

    #1838230

  • RE: SQL Services are not coming online

    stop the sql server service and delete the tempdb files and then restart the instance

    November 6, 2015 at 7:35 am

    #1838227

  • RE: SQL Server resource question

    mark.williams 37494 (11/6/2015)

    PretendDBA (11/6/2015)

    Have you done testing?

    Yes i have carried out testing and have encountered the following behaviour, can anyone tell me if this is expected behaviour.

    If i stop the...

    November 6, 2015 at 7:28 am

    #1838223

  • RE: SQL Server Services Accounts - Best Practice

    GilaMonster (11/3/2015)

    Ideally each service should have its own account. That account absolutely should NOT be local admin, they should be limited-permission accounts.

    While that's the ideal, in many cases multiple services...

    November 6, 2015 at 7:08 am

    #1838210

  • RE: Downgrade SQL Server / Install Master Database

    tress (11/4/2015)

    Hi Perry,

    That's what I have decided to do, is it possible to script the passwords in anyway, unfortunately many of the accounts were created before my time and nobody...

    November 6, 2015 at 7:06 am

    #1838208

  • RE: AlwaysOn: Mismatched SIDs

    SQLBill (11/4/2015)

    We have created a SS2014 AlwaysOn environment and are doing the pre-live testing. I'm currently testing logins and have found an issue that I need help resolving.

    Background:

    Primary server

    Two Replicas

    We...

    November 6, 2015 at 7:02 am

    #1838207

Viewing 15 posts - 1,576 through 1,590 (of 9,253 total)