Forum Replies Created

Viewing 15 posts - 61 through 75 (of 490 total)

  • RE: SQL Server 2008 Cluster updating

    Agreed

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: Adding files

    you are trying to ask when you will create the file,login or any object in the primary server then these objects will be create automatically on the secondary server or...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: Adding files

    there must be same number of log files on the logshipping Server

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: change password

    which user you are using SQL or Windows to access the SQL Server ?

    If you are using the SQL Login then this will appear everytime when you try to connect...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: Confusing SQL Agent Issue in Clustered Environment

    if you have a domain then create a separate ids as

    sqlservice for database services

    sqlagent for the database agent services

    and add these 2 accounts in the server local administrator group and...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: OS + SQL Server binaries on same drive?

    Do not split more drives on the same RAID group

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: Disk IO Performance Degredation after Server Upgrade

    Disk Delays are not acceptable

    Maximum Disk delays should not be more than 30 ms,if more than 30 ms then you have to check your SAN storage settings RAID Groups and...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: point of time recovery

    yes you can

    1-Restore the Full Backup with no recovery

    2-Restore the 6am log backup with no recovery Point in time most recent possible

    3-Restore the 9am log backup with no recovery Point...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: Failover Cluster Validation 2 Warnings

    whats the subnet mask did you define for the private NIC IP 10.3.10.222 or 10.3.10.223 ?

    can you ping each other ?

    are these NIC connect directly to eachother ?

    whats the subnet...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: While I am creating the Cluster of sql server 2008 R2 I am getting error:

    check the LUN mapping of disk drives

    these are shared disk or Drive comming from SAN storage?

    are you installing this SQL server Installation on physical Server or Virtual Server ?

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: Linked server problem

    I don't see how this could solve the OP's issue.

    If I'm reading it right, (s)he's trying to query SQL2000 from SQL2008R2, not the contrary.

    Did you create SQL Server 2008 R2...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: OS + SQL Server binaries on same drive?

    If you have multiple drives not partition then separate drives gives you performance advantage,when you go for the default drive then there are several other processes are running on this...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: Linked server problem

    install the sql server native client 10 on the side of SQL server 2000 and then create a odbc with this driver and then create a linked server with this...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: Migration from Access to SQL2008--Need Help

    MS Access userid and password required

    But NOTE it in this process your relationship will not move from access database to sql server 2008,you have to define separately

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • RE: Disk IO Performance Degredation after Server Upgrade

    First of all check the SAN Cache and then RAID Groups,If All disk on the same RAID Group that might be a problem

    Page-Life-Expect..

    as asked by the @Old Hand

    For Disk...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

Viewing 15 posts - 61 through 75 (of 490 total)