Forum Replies Created

Viewing 15 posts - 7,801 through 7,815 (of 9,241 total)

  • RE: 2 node clustering recommendations for SQL 2008 (with windows server 2008)

    Sam -480699 (8/10/2010)


    Is it possible to create a 2 node (active / passive) cluster where the SQL databases are not using shared storage.

    Thats the whole point of a...

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

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

  • RE: what is Copy-Only Backup?

    TheSQLGuru (8/10/2010)


    I still refer to numerous 2005 features as "new". When you have been using the product since 6.5 first came out . . . 🙂

    In any case, BOL...

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

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

  • RE: Upgrade 2 node Clustered SQL Server 2005 on Windows 2003 to SQL Server 2008 on Windows 2008

    gmamata7 (8/9/2010)


    to see whether we can keep the same Virtual server name and SQL Server instance

    As I said the virtual network name, like a computername must be unique in the...

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

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

  • RE: Upgrade 2 node Clustered SQL Server 2005 on Windows 2003 to SQL Server 2008 on Windows 2008

    gmamata7 (8/9/2010)


    Can we have same Virtual server name with different IP?

    no you cannot, like a computername the virtual network name must be unique in the Windows domain

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

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

  • RE: Poll to see how many people set Max Server Memory

    if using BP locked pages then you should configure both min and max memory for each instance

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

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

  • RE: DR for SQL server 2005 and 2008 Clustering, any suggestion?

    jarupan (8/8/2010)


    1) Anyone has white paper about set up SQLserevr2008/Windows2008 on Virtual server (or VMware), please let me know the link.

    It's your lucky day!! Check the 2 links below for...

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

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

  • RE: 2 node clustering recommendations for SQL 2008 (with windows server 2008)

    Sam -480699 (8/9/2010)


    Hi,

    Apologies if this has been asked before I did try looking around for a similar thread.

    At the present moment my company has propsed that we need to...

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

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

  • RE: Failover cluster on XP SP2

    Hi Ashwin

    what you can do on XP is to set up a virtual SQL Server 2008 cluster. For this you will need the following

    multi core processor

    3 GB RAM

    Windows 2003 Server...

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

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

  • RE: what is Copy-Only Backup?

    let me re phrase that.

    New in SQL Server 2005!

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

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

  • RE: My MSDB Database is over 31 GB in the development server

    i'm assuming you're database mail, have you checked connectivity to the mail server?

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

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

  • RE: what is Copy-Only Backup?

    Hi

    copy_only is a new feature, it is basically a backup that does not interfere with the current backup chain. As Gail said, BOL does document this feature

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

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

  • RE: Upgrade 2 node Clustered SQL Server 2005 on Windows 2003 to SQL Server 2008 on Windows 2008

    tnk (8/8/2010)


    However, one idea might be to drop the passive node out of the 2003 cluster, upgrade to Windows Server 2008, set up the 2008 Cluster with a different cluster...

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

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

  • RE: Hi i am a sql dba.In my organizastion i am only the who will take care sql servers.2 servers are going to production within 2 days.

    in my opinion and experience, management who are lacking the key understandings are the real issue. They dont necessarily need to be a DBA themselves but they should have a...

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

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

  • RE: Restart SQL Server service on a cluster environment

    wow this is really going off topic now, the OP only asked about cluster resources failing over from node to node 😀

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

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

  • RE: Restart SQL Server service on a cluster environment

    Mike Hinds (8/6/2010)


    Perry Whittle (8/6/2010)


    Mike Hinds (8/5/2010)


    but manually bringing either online does nothing for the other.

    then you do not have your dependencies set correctly!

    see my attached screenshot for details

    Thanks for...

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

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

Viewing 15 posts - 7,801 through 7,815 (of 9,241 total)