Forum Replies Created

Viewing 15 posts - 6,736 through 6,750 (of 9,244 total)

  • RE: How to change the owner of the mirroring

    didnt we already discuss this at the link below?

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

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

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

  • RE: How to Build a Windows Server 2008 Failover Cluster on Cheap Hardware for a Home Lab

    colin.Leversuch-Roberts (8/26/2011)


    I have plans to build a physical cluster ( no virtualisation ) using windows 2008 R2 storage server - this acts essentially as a shared iscsi storage source. ...

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

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

  • RE: Backup and old file delete GOTCHAs!

    my point is, you want them on disk long enough for them to be persisted to tape, after that delete them!

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

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

  • RE: Backup and old file delete GOTCHAs!

    you really only want to be looking at retaining 8 days on disk, the previous files should be on tape and go into the rotation pool. To keep a months...

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

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

  • RE: What happens if the Domain Controller is down?

    how are you handling name resolution while the DC is down

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

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

  • RE: How to Build a Windows Server 2008 Failover Cluster on Cheap Hardware for a Home Lab

    yeah i dont use IE9 its a nasty piece of software to be honest.

    Firefox works just great too.

    The way you create the volumes\datasets and expose the LUNs has changed significantly...

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

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

  • RE: What happens if the Domain Controller is down?

    Sinh Dinh (8/22/2011)


    If the SQL Service is running on a domain account and the DC goes down, will the service still run?

    Typically you will have more than 1 domain controller,...

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

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

  • RE: db mirroring mode change by?

    if you believe someone is changing mirroring modes without authorisation then run a smal server side trace to capture these events, this will help identify who is making the change

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

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

  • RE: How to Build a Windows Server 2008 Failover Cluster on Cheap Hardware for a Home Lab

    Hi

    i used Freenas .7.2 which is still available for download. I can supply a short tutorial with screenshots for v8 though if you want it

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

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

  • RE: How to change or alter endpoint Mirror user

    MAK1 (8/25/2011)


    Thanks for help but I am getting following syntax error

    GRANT CONNECT ON ENDPOINT: [Mirroring] TO [XXXXX\XXXXXX]

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near 'ENDPOINT:'.

    Sorry my bad...

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

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

  • RE: How to change or alter endpoint Mirror user

    as i said, this is not how you change it

    MAK1 (8/25/2011)


    ALTER ENDPOINT [Mirroring]

    AUTHORIZATION [XXXXXX\XXXXXX]

    Create the login on each instance and grant connect to the mirror endpoint

    CREATE LOGIN [Mydomain\UncleBobCobbly] FROM...

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

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

  • RE: How to change or alter endpoint Mirror user

    MAK1 (8/25/2011)


    I am running 2005 Ent. edition, I want to change the user but getting following error

    ALTER ENDPOINT [Mirroring]

    AUTHORIZATION [XXXXXX\XXXXXX]

    Msg 156, Level 15, State 1, Line 2

    Incorrect syntax near...

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

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

  • RE: A network-related or instance-specific error occurred while establishing a connection to SQL Server

    abdul.irfan2 (8/25/2011)


    hello, how would i go about following point 2(setting UDP inbound port)...that is

    "2. UDP remote port 1434 is not set as an inbound rule on the client...

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

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

  • RE: Is sql server 2008 r2 service pack is available?

    forsqlserver (8/25/2011)


    The link is not opening.

    Atleast tell yes or No if confirm

    the link opens fine for me, what browser are you using?

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

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

  • RE: db mirroring mode change by?

    either a database owner or a sysadmin can change this, how many people hold this role in your organisation?

    The state change is logged in the default trace so try having...

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

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

Viewing 15 posts - 6,736 through 6,750 (of 9,244 total)