Forum Replies Created

Viewing 15 posts - 6,106 through 6,120 (of 9,241 total)

  • RE: Issue while configuring Log Shipping on SQL 2005 Enterprise

    chetanr.jain (11/2/2010)


    Shared folder is accessible from both the servers in read - write mode.

    accessible for which accounts?

    are your sql server servcies running under domain or local accounts?

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

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

  • RE: SQL Server 2008 Express SP1

    SKYBVI (1/10/2012)


    I have 1 another sql server 2008 express with advanced services...

    This has SSMS Express download and install this

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

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

  • RE: How to find deleted database?

    solomon.jernas (1/10/2012)


    Pls Could u send the Example

    Execute the following against your SQL server instance to find the default trace path\file name

    select value AS DefTracePath from fn_trace_getinfo(1) where property =...

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

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

  • RE: SQL Server 2008 Standard Edition Failover Clustering

    shijimon.jacob (1/10/2012)


    On node A and node B install Active/Active sql failover cluster

    On node C and node D install Active/Active sql failover cluster

    the scenario above is perfectly valid

    instance 1 is installed...

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

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

  • RE: Consideration for active/active cluatering on windows server 2008

    Minaz Amin (1/9/2012)


    Hi,

    Please do let me know the pre req for configuration of active /active cluster.

    We are planning to have 2-node active/active cluster with two separate instance running on both...

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

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

  • RE: Passive Cluster Service Stopped.

    what quorum type are you using disk or MNS

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

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

  • RE: .mdf

    chrisians2929 (1/10/2012)


    Hi,

    I was told that a .mdf file cannot be uploaded or moved from 1 location meaning in vs.net to an iis, is this true?

    are you referring to the attach...

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

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

  • RE: SQL Server Port

    george sibbald (1/10/2012)


    SQL browser should be running when you have multiple instances

    unless you have static ports set and connect directly to them, this negates the SQL browser service.

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

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

  • RE: Nightly refresh of Prod data to other location across slow connection

    full backup once a week at the weekend and diffs during the week may work for you

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

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

  • RE: upgrade 3-node sql 2005 to sql 2008 cluster

    This is not a suggestion, this how you carry out the upgrade 😀

    Perry Whittle (1/9/2012)


    However, if you really want to perform the upgrade you do so by first upgrading the...

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

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

  • RE: upgrade 3-node sql 2005 to sql 2008 cluster

    Oracle_91 (1/8/2012)


    Hi Everyone,

    Can anyone help me out in know what is the procedure followed to upgrade 3 - node

    sql server 2005 cluster to sql server 2008 on windows server...

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

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

  • RE: Cluster Network Configuration IP Address - how to configure?

    DHCP is actually a good way to manage static IP assignments to servers as well as clients, its just never been supported until now (sql\windows 2008)

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

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

  • RE: Cluster Network Configuration IP Address - how to configure?

    You can either use a static IP address or a DHCP assigned IP address. I'm assuming you mean DHCP when you say IP address on the domain controller.

    If you assign...

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

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

  • RE: Microsoft Gold Certified Partner Companies - Horror Stories

    Jeff Moden (1/8/2012)


    Any "Gold" partner that has Gail Shaw working for them has got to be one of the good ones I was talking about. 🙂

    Aww Jeff you're just too...

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

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

  • RE: SQL coding techniques

    GilaMonster (1/8/2012)


    Yes it did (at least on 7, 8i and 9i), and iirc it was just += or maybe (+)= (its been a while),

    Certainly a (+) on 7 and 8...

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

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

Viewing 15 posts - 6,106 through 6,120 (of 9,241 total)