Forum Replies Created

Viewing 15 posts - 7,846 through 7,860 (of 9,244 total)

  • RE: Installing SQL Server 2008 R2

    where did you get the DVD image from?

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

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

  • RE: upgrading from 2000 enterprise to 2005 standard

    to re use the hardware, i would uninstall one node leaving the cluster effectively a single node cluster. I would then temporarily virtualise this system to keep it running side...

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

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

  • RE: setting up a 2 node cluster

    From memory the installer wont let you select a shared drive, if you do it warns that the drive is a shared drive and forces you to make another selection

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

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

  • RE: SQL Server Failover solutions

    Rudy Panigas (7/20/2010)


    look at LiteSpeed from Quest as it can do object level restores like tables, views and stored procedures to help you recover a drop object.

    Redgate SQLBackup Pro also...

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

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

  • RE: Active/Active 2 Node Cluster Sql2008 Standard Edition

    you're welcome!

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

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

  • RE: SQL Server Failover solutions

    Robert Cary (7/16/2010)


    If you're using an MDB and are thinking about High Availability, perhaps you have outgrown your front-end technology.

    It probably wouldnt take too much work to convert this into...

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

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

  • RE: SQL Server Failover solutions

    _taz_ (7/15/2010)


    Robert Cary (7/15/2010)


    Your connection string would look something like this:

    Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;Initial Catalog=myDataBase;Integrated Security=True;

    The application will connect to whichever one is available, if the primary fails, the application connections...

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

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

  • RE: Active/Active 2 Node Cluster Sql2008 Standard Edition

    james.christou (7/15/2010)


    Thanks for the replies Perry/Howard,

    The edition we are using is 2008 Standard Edition.

    That's fine Std supports a 2 node cluster

    james.christou (7/15/2010)


    What we want is instance A and instance B...

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

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

  • RE: Active/Active 2 Node Cluster Sql2008 Standard Edition

    also 2 node clusters are only available in Std and Ent editions!

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

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

  • RE: Active/Active 2 Node Cluster Sql2008 Standard Edition

    which edition of SQL Server 2008 are you using?

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

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

  • RE: Red Gate SQL Backup vs. Quest Lite Speed backup

    Litespeed and SQLBackup are both comparable products nowadays. I personnally found SQLBackup better on compression than Litespeed on my test databases

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

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

  • RE: VMware combined with MSCS Clustering

    Hi Cindy

    if we're talking a straight VM with standard VHD's then in my experience VMWare HA is generally quicker and less fuss than MSCS!

    During my first encounters with ESX...

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

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

  • RE: 16 Drive Configuration for SQL Server 2008

    there's no mention of backup files where do you intend to put these?

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

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

  • RE: Clustering SQL Server 2008 on VMWare

    for more on creating virtual clustered environments check my article here

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

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

  • RE: VMware combined with MSCS Clustering

    Hi Cindy

    thank you for citing my article, its good to know people do read them! Let's start at the beginning here.

    The first question, disregarding virtualisation at this time, is do...

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

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

Viewing 15 posts - 7,846 through 7,860 (of 9,244 total)