Forum Replies Created

Viewing 15 posts - 7,351 through 7,365 (of 9,241 total)

  • RE: SQL 2008 Cluster Resource Cannot come online - HELP!

    the network binding error is common on Windows 2008. You need to go into the registry and find the key as follows

    HKEY LOCAL MACHINE\SYSTEM\CurrentControlSet\Services\TCPIP\Linkage

    Check the values for the Bind entry....

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

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

  • RE: active/passive -> active/active

    As you are using Windows 2008 you have multiple clustered MSDTC applications, one for each clustered instance of SQL server is possible!

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

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

  • RE: SQL Mirroring + Multiple End Points on SQL Instance

    cheshirefox (12/13/2010)


    Can I configure 2 endpoints on instance A then mirror database 1 to instance B and mirror database 2 to instance C?

    each sql server instance may have only 1...

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

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

  • RE: Linked server using MySQL ODBC 5.1.8

    nikshepmehra (12/13/2010)


    Sorry , guys ... I was trying to connect to the server and had the ODBC on my machine i.e the client instead of the server just did it...

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

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

  • RE: SQL Mirroring + Multiple End Points on SQL Instance

    endpoints are created locally and used as the connection points between mirroring sessions!

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

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

  • RE: SQL Cluster Upgrade

    it would be helpful if you could provide a little more detail as to your current setup.

    Which version VCS are you using?

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

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

  • RE: Linked server using MySQL ODBC 5.1.8

    do you have a suitable driver installed on the server, check ODBC settings for the currently installed driver versions

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

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

  • RE: SQL Upgrade 2000 to 2008

    If any packages are using dts only components they will need re writing immediately and won't run in legacy mode.

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

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

  • RE: SQL Upgrade 2000 to 2008

    INNOCENT GUMBO (12/7/2010)


    I am more concerned with DTS Packages from SQL 2000, Is it possible to let all of them run on Legacy Mode or it is advisable to upgrade...

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

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

  • RE: 881223 - How to add a Share Disk resource to a cluster?

    Rich Holt (12/3/2010)


    Perry Whittle (5/8/2010)

    I use FreeNAS and present the LUN's over iSCSI to the Windows 2008 cluster nodes. Check my tutorial at this link

    http://www.stokecs.co.uk/TechDocs/Creating%20a%202%20node%20SQL%20Server%202008%20Cluster%20Configuration%20using%20Windows%202008%20MSCS.pdf

    for details of how to...

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

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

  • RE: installing SQL 2008 SP2

    it's easier to slipstream the service pack at install time!

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

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

  • RE: BACKUP

    weaseludo (11/30/2010)


    Hola a todos , me ayudarian mucho si alguien me pudiera contestar si hay forma de crear un backup de un base de datos por medio de la instruccion...

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

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

  • RE: Database Mirroring Setup Failure.

    Sourav-657741 (11/28/2010)


    The login 'NT AUTHORITY\NETWORK SERVICE' does not have CONNECT permission on the endpoint. State 84.'.

    The message above seems fairly descriptive, can you provide more details as to the...

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

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

  • RE: Does the size of the model database increase automatically?

    has someone created objects inside Model by any chance?

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

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

  • RE: Single command to rebuild all the indexes of all the tables

    Joy Smith San (11/27/2010)


    It's a 185 GB database and defragmentation is not done since long time it seems. Heavily fragmented it is.

    With this size database, as Gail says, I...

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

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

Viewing 15 posts - 7,351 through 7,365 (of 9,241 total)