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