• jamessdba (9/2/2014)


    Hi experts please answer these doughts. in sqlserver 2005/8R2

    Interview questions? (btw, 'doubts')

    1) If principle server down what willl happen to Mirror DB & Transactions

    Depends on how the mirroring is configured. Read up on mirroring for the details, lots of good books

    2) If mirroring breaks what will happen to mirror server

    Depends on what you mean by 'breaks'. Read up on mirroring for the details, lots of good books

    3) In BulkLogged can we take Point in time recovey?

    Depends on the types of operations which have been run. Read up on recovery models, books online has a lot and there are a number of articles available

    4) Suddely SP is getting slow how to trouble shoot?

    Identify what changed, fix it

    5) TempDb full how to trouble shoot?

    Identify what's using TempDB, fix it.

    6) If log full in logshipping & mirroring how to trouble shoot ?

    Same way you would troubleshoot for cases where you don't have mirroring or log shipping. Again, lots and lots of good articles available.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass