Forum Replies Created

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

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

  • RE: alwayson

    giri10488 (7/8/2015)


    i already tried on google but i want how its work exactly.

    Check my article linked above

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

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

  • RE: robocopy and named instances

    kathy.plamann (7/8/2015)


    I have a powershell script that runs robocopy from sql server agent

    Cut out the middleman and just use PoSh to copy the files instead of Robocopy 😉

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

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

  • RE: Poor read-only AlwaysOn replica performance

    on top of what Kevin has said, try this link and this link

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

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

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