Forum Replies Created

Viewing 15 posts - 5,656 through 5,670 (of 9,253 total)

  • RE: How to configure SQL Server 2008 R2 Active/Passive Cluster

    APA0876 (4/20/2012)


    So I will need Two different Ips for the two instances

    Exactly, you will meed separate IP, network name and disk storage for each instance.

    APA0876 (4/20/2012)


    plus two more ips for...

  • RE: Recover sa Password

    You need to detail exactly the steps you took and any errors that you received.

  • RE: How to configure SQL Server 2008 R2 Active/Passive Cluster

    APA0876 (4/19/2012)


    How to proceed with an Active/Active installation. Is there a good guide that I can use?

    Yes, the guide you already have 😉

    Install a second instance and run the add...

  • RE: SAN question involving HBA limits and drive volumes for log files.

    Kwisatz78 (4/19/2012)


    by having more volumes you can parallel write different log files.

    Can you get the admin to clarify exactly what they mean by this?

    SpringTownDBA (4/19/2012)


    3. Present results to the SAN...

  • RE: Want to create a Log Shipping

    dsohal (4/19/2012)


    If we replication do we need to extra servers and licensing,

    No more than is required for your Log Shipping scenario

    dsohal (4/19/2012)


    Do these servers will have differnt name

    Unless they're in...

  • RE: How to configure SQL Server 2008 R2 Active/Passive Cluster

    APA0876 (4/19/2012)


    Configure Cluster Quorum settings

    That's exactly it 😉

  • RE: iscsi target for data/log files?

    in that case SQL Server will not have any dependency on the disks as it does in a clustered environment.

    If SQL Server tries to start and the disks are...

  • RE: how to transfer specific db users and passwords to another db??

    s1123 (4/19/2012)


    hi guys,

    i have this one db(principal db) in first server and i want to transfer the users/logins and passwords to another db(miroor db) in second server,

    can anyone tel me...

  • RE: iscsi target for data/log files?

    Indianrock (4/17/2012)


    The Microsoft iSCSI Initiator Service shows no dependencies at all

    The sql service shows the sql server agent as dependent on the sql service, nothing more.

    is this a sql server...

  • RE: Recover sa Password

    anthony.green (4/19/2012)


    Think its the -m or -c switch you want

    It's both 😉

    -m starts the instance single user and -c shortens the command prompt startup time as it bypasses the calls...

  • RE: SQL 2008R2 just keeled over

    opc.three (4/18/2012)


    With VAS being such a limiting factor on 32-bit instances large contiguous blocks can become hard to come by after being up for a while and the only way...

  • RE: Want to create a Log Shipping

    i would always prefer the same versions but when it comes to editions, if all my witness was going to was act as a witness i'd use express edition 😉

  • RE: DBCC Question

    had something similar to this on an exchange server some years ago, repeated corruption turned out to be a whacko RAID backplane\bios. check and double check all areas of the...

  • RE: English question for a word

    if an application is not working as expected its known as "faulting". An object that is faulty is not working as designed\expected 😉

  • RE: Want to create a Log Shipping

    GilaMonster (4/18/2012)


    Database mirroring is a DR technology that can also be used for reporting

    Assuming your installed SQL version on the secondary instance allows snapshots of the mirror. Even then these...

Viewing 15 posts - 5,656 through 5,670 (of 9,253 total)