Forum Replies Created

Viewing 15 posts - 1,906 through 1,920 (of 9,244 total)

  • RE: Poor read-only AlwaysOn replica performance

    in fact without details of the schema it's going to be fairly difficult, there are some hints to possible missing indexes, whilst these should be taken with a pinch of...

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

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

  • RE: Removing an additional unwanted log file.

    you're welcome

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

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

  • RE: Recover DB without Log file.

    got a backup of the database?

    if not, why not?

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

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

  • RE: robocopy and named instances

    patrickmcginnis59 10839 (7/9/2015)


    Perry Whittle (7/9/2015)


    plamannkathy (7/9/2015)


    $SourceLocation = "e:\backup\xxx`$xxx\master\Full"

    $DestinationLocation = "\\sharebackup\xxx`$xxx\master\Full"

    Thanks 500!!

    This worked. This problem now solved.

    Thanks everyone

    did you even bother to read my last post

    I think you had the right...

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

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

  • RE: robocopy and named instances

    Perry Whittle (7/9/2015)


    kathy.plamann (7/9/2015)


    This is the error I am receiving:

    A job step received an error at line 17 in a PowerShell script.

    The corresponding line is 'throw("Failure in copying...

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

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

  • RE: robocopy and named instances

    plamannkathy (7/9/2015)


    $SourceLocation = "e:\backup\xxx`$xxx\master\Full"

    $DestinationLocation = "\\sharebackup\xxx`$xxx\master\Full"

    Thanks 500!!

    This worked. This problem now solved.

    Thanks everyone

    did you even bother to read my last post

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

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

  • RE: I messed up Quorum and MSDTC drive switch on failover cluster

    webrunner (7/9/2015)


    Hello experts,

    I am hoping to get some help with a failed recommendation I made. Our staging SQL Server was set up with the Quorum drive as M and the...

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

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

  • RE: Kerberos Ticket Encryption Type & AlwaysOn Availability Group Listener

    great, thanks for posting back

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

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

  • RE: robocopy and named instances

    kathy.plamann (7/9/2015)


    This is the error I am receiving:

    A job step received an error at line 17 in a PowerShell script.

    The corresponding line is 'throw("Failure in copying $SourceLocation files...

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

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

  • RE: AlwaysOn Multiple AGs and Listeners in the same instance

    rodbloke (7/9/2015)


    can this new listener also be configured to use port 1433?

    Cheers

    Rod

    Yes it can. The combination of IP address and port number will be unique

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

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

  • RE: robocopy and named instances

    patrickmcginnis59 10839 (7/9/2015)


    That's true, I don't have to have that functionality in a copy operation, as long as there was some other way to manage the bandwidth that the copy...

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

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

  • RE: How to check if the database itself is encrypted or only the backups ?

    Joy Smith San (7/9/2015)


    Hi All,

    I queried sys.databases in one of the sql server and found "is_encrypted" is "1" for four of the databases.

    Does that mean that all those 4 DBs...

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

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

  • RE: New problem "Name resolution not yet available" on SQL Server 2014

    Please post the output from the following PoSh command

    Get-ClusterResource | ?{$_.ResourceType -EQ "Network Name"} |

    Get-clusterparameter dnsname,creatingdc,RegisterAllProvidersIP |

    ft ClusterObject,Name,Value

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

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

  • RE: robocopy and named instances

    patrickmcginnis59 10839 (7/8/2015)whats the syntax in PoSh to set interpacket gaps?

    Would it really be that much of an issue?

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

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

  • RE: cluster

    what core cluster resources are created during an install of a failover cluster instance?

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

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

Viewing 15 posts - 1,906 through 1,920 (of 9,244 total)