Can we perform a tail log backup if .mdf file is corrupted? Ans: Yes we can perform a tail log as long as the ldf if not corrupted and no bulk logged changes. A typical tail log backup is having two options, 1. WITH NORECOVERY 2.Continue After Error....
Can we perform a tail log backup if .mdf file is corrupted? Ans: Yes we can perform a tail log as long as the ldf if not corrupted and no bulk logged changes. A typical tail log backup is having two options, 1. WITH NORECOVERY 2.Continue After Error....
Replication Commands: Publisher.SP_ReplTran: Checks the pending transactions at p Distributor.MSReplCommands and MSReplTransactions: Gives the transactions and commands details. Actual T_SQL data is in binary format. From the entry time we can estimate...
Replication Monitor: In replication monitor from the list of all subscriptions just double click on the desired subscription. There we find three tabs. Publisher to Distributor History Distributor to Subscriber History Undistributed commands
What are the agents in replication? Ans: Snapshot Agent: Copy Schema+Data to snapshot folder on distributer. Used in all types of replication. Log reader Agent: Sends transactions from Publisher to Distributor. Used in transactional replication Distribution...
What are the main events and columns helpful in troubleshooting performance issues using profiler? Ans: Events: Event Group: Performance Event: ShowPlan_ALL (BinaryData column must be selected) Event: ShowPlan_XML Event Group: T-SQL Event: SQL:BatchStarted...
What are the main events and columns helpful in troubleshooting performance issues using profiler? Ans: Events: Event Group: Performance Event: ShowPlan_ALL (BinaryData column must be selected) Event: ShowPlan_XML Event Group: T-SQL Event: SQL:BatchStarted...
How to change the sql server service account in a cluster environment? Ans: Method 1: (No failover required) 1. Freeze the service group on active node from cluster administrator and then restart the service. Method2: 1. Offline the SQL resources 2. Update...
How to change the sql server service account in a cluster environment? Ans: Method 1: (No failover required) 1. Freeze the service group on active node from cluster administrator and then restart the service. Method2: 1. Offline the SQL resources 2. Update...
Q. How to change the sql server service account in a cluster environment? Ans: Method 1: (No failover required) 1. Freeze the service group on active node from cluster administrator and then restart the service. Method2: 1. Offline the SQL resources 2....
