Forum Replies Created

Viewing 15 posts - 6,601 through 6,615 (of 9,244 total)

  • RE: Logshipping backup job deleting the old files

    bindview (9/18/2011)


    The edition is sql server 2005 sp4. I will try your solution of creating the new backup folder and will post the results soon.

    Thanks for the help.

    The network path...

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

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

  • RE: Retrieve User Network Name

    you should be able to get the IP address of the client this may help to narrow the user down

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

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

  • RE: Add node install fails

    even better, slipstream the service pack for a trouble free installation

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

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

  • RE: Error in sp_configure 'xp_cmdshell'

    as already said when shelling out specify the path like so

    exec xp_cmdshell '"C:\Program Files\Microsoft SQL Server\90\COM\tablediff.exe" blah'

    Alternatively go onto the server and add the path for the TABLEDIFF.EXE to the...

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

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

  • RE: Logshipping backup job deleting the old files

    sqlbuddy123 (9/16/2011)


    backup_retention_period - 4320 -- what units are these ?

    The length of time in minutes.

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

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

  • RE: Database mirroring 2008 r2

    kvr1985 (9/16/2011)


    mirror server not synchronizing.please find the snapshot in attachment.

    Has it ever synchronised?

    Can you supply more info on the steps you took to set up the mirror session?

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

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

  • RE: Clustering Errors

    VanishingW (9/16/2011)


    Ok here are the new findings. Last night I shut down one and every thing failed over to two. It was not instant, but it did switch and two...

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

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

  • RE: Clustering Errors

    I'm assuming the filer is setup to use FCP and not iSCSI, double check the initiator groups as that has to be the root of the issue. Does the second...

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

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

  • RE: Cluster failover

    pamalatha (9/15/2011)


    Thanks a lot Crazy.

    😀 my name is Perry

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

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

  • RE: Configure Clustered MSDTC on Windows 2008 R2

    dbychen (9/14/2011)


    The method and requirements of MSDTC configuration has changed in Windows 2008/R2 environments. It seems to require a DTC name with a paired IP address in order to create...

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

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

  • RE: Cluster failover

    pamalatha (9/14/2011)


    It is a net work share that the backup job is trying to create backup. I get an error "cannot find path" after the failover. but when I...

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

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

  • RE: Difference between possible owners and preferred owners

    yes, prevent failback will do it exactly what it says. Set the policy to immediate or scheduled and the cluster group will comply, probably not what you want on a...

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

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

  • RE: Virutal Names for a Cluster

    Virtual network names, like computernames must be unique in the domain.

    One clustered instance to one network name.

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

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

  • RE: Logshipping backup job deleting the old files

    Please execute the following against your primary server and post the results

    exec sp_help_log_shipping_primary_database @database = 'YourLogShippedPrimaryDatabase'

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

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

  • RE: Difference between possible owners and preferred owners

    Possible owners are defined at the resource level and dictate which nodes in the Windows cluster are able to service this resource


    For instance, you have a 3 node cluster with...

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

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

Viewing 15 posts - 6,601 through 6,615 (of 9,244 total)