Forum Replies Created

Viewing 15 posts - 8,581 through 8,595 (of 9,241 total)

  • RE: SQL Server Failover Clustering Test Methods

    Nicholas Cain (12/24/2008)


    The best way to test....unplug stuff

    at the end of the day this is exactly what clustering is designed to protect against so yes its the best way. Fail...

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

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

  • RE: Database mail using Exchange Server

    just be sure not to tick the "relay messages to all domains" check box otherwise after a couple of hours your public ip address will be blocked 😉

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

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

  • RE: RAID 1 vs. RAID 10

    kendal.vandyke (12/24/2008)


    Maybe the question was misunderstood.

    not at all.

    RAID 10 will generally offer a performance boost over RAID1 due to the striping across mirrored sets. As SQL server writes to...

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

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

  • RE: Backup Compression in sql server 2000

    there are some freebiee sql utils but the best bet is either Redgate SQL Backup or Quest Litespeed?

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

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

  • RE: RAID 1 vs. RAID 10

    i would say the RAID 10 array is best as it offers the best performance and fault tolerance combined into one package. The downside of RAID 10 is the disk...

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

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

  • RE: Missing Indexes

    sorry god but i'm not the one with the ego problem am i. Also i havent made any obscene comments, i just told you to quit crying like a pair...

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

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

  • RE: Server Status Icons

    VEB (12/24/2008)


    I have similar situation.

    The problem is that the host with SQL Server has Windows Firewall configured. Ports 1434/UDP and the static ports associated with instances are opened in the...

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

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

  • RE: Database mail using Exchange Server

    port 2525 is usually used if blocking port 25.

    Verify with the exchange admin the listener and outgoing ports?

    Is the exchange server on the same network as the sql server?

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

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

  • RE: Considerations for RAM

    the following post

    http://www.sqlservercentral.com/Forums/Topic529146-146-1.aspx

    has a detailed answer from Gail for a similar scenario

    and this post

    http://www.sqlservercentral.com/Forums/Topic622415-146-1.aspx

    has my previous answer

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

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

  • RE: Missing Indexes

    why act like a couple of little girls. The solution you provided is correct if the question were different. As far as i can see he wanted to know what...

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

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

  • RE: copy a database from one server to another server

    Perry Whittle (12/22/2008)


    use the generate scripts option to script of the indexes, constraints, triggers,etc

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

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

  • RE: Database mail using Exchange Server

    the sql server simply connects to exchange over port 25 and sends the mail!

    from your sql server, telnet to port 25 on the exchange box, do you get a successful...

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

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

  • RE: Missing Indexes

    what ADI posted is not what the OP required

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

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

  • RE: Database mail using Exchange Server

    do you have database mail configured correctly?

    check BOL for more info

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

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

  • RE: Database Mirroring or Log shipping on different server

    Paresh Prajapati (12/23/2008)


    Can u differentate Active/Passive and Active/Active.

    Bac i don't have deep knowledge and confuse to it.

    I simply know that in Active/Passive alustering one is active at a...

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

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

Viewing 15 posts - 8,581 through 8,595 (of 9,241 total)