Forum Replies Created

Viewing 15 posts - 7,981 through 7,995 (of 9,244 total)

  • RE: Quorum not failing over during SQL Server failover

    quorum is a separate resource to the SQL Server instance group and wont necessarily fail over with the SQL Instance unless the active node dies.

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

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

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

    adalberto-339588 (5/8/2010)


    expensive CZ you need special hardware

    not with virtual machines 😉

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

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

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

    hamidi 97216 (5/8/2010)


    now i could succeed to pass the check and u caused it. i'm really grateful.

    now i think i don't need StarWind at all. i may uninstall it as...

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

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

  • RE: SQL Partitioning on existing tables

    Gianluca Sartori (5/5/2010)


    Basically, you just have to move the indexes.

    Clustered!!

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

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

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

    This is a Windows 2003 cluster and so will support ESX shared HDD's \SCSI bus!

    The OP barely has the skills to add a shared virtual HDD let alone deploy a...

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

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

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

    The virtual disk you are sharing needs to be attached to both VM's. Create a single HDD on each VM and use SCSI 0 as the controller, this will be...

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

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

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

    then add the shared HDD to both VM's and share the SCSI bus on each VM accordingly

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

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

  • RE: MSDTC Won't Come Online

    rjoseph (5/4/2010)


    I went ahead and gave the object domain admins access:

    bad idea, consult your domain administrator and see if they are able to help you

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

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

  • RE: auto generate logins

    😉

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

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

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

    Are both VM's on the same host?

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

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

  • RE: auto generate logins

    Bryan

    the script that George mentions is probably the best way to generate create login scripts.

    Your script has NULLs because the script is pulling Windows logins (which have no password)...

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

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

  • RE: Access rights on the databasefiles for a cluster

    under what context does your sql server service run user account or local system?

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

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

  • RE: Renaming the logical name of data and log files in a database

    hey, you're welcome!

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

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

  • RE: Renaming the logical name of data and log files in a database

    to rename a files logical name you need to use the following

    Get the logical names for your chosen database using

    select f.name from sys.databases d

    inner join sys.master_files f on d.database_id...

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

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

  • RE: create user and reset passwd stored procedures

    ColeTrain (5/1/2010)


    Hello, I'm having issues creating two stored procs. I would like to create one that creates and resets the password for a defined type of user on the system....

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

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

Viewing 15 posts - 7,981 through 7,995 (of 9,244 total)