Answer Posted / Gaurav Garg
A standby server in SQL Server is a secondary server that automatically takes over database operations when the primary server fails or becomes unavailable. It maintains a copy of the transaction logs from the primary server and applies changes to its own database, ensuring minimal downtime during failover.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does view occupy space?
What is the difference between for xml raw and for xml auto?
How to rebuild the master database?
How to remove duplicate rows from table except one?
What is sql server query analyzer?
What is temporary table in sql server? Why we use temp table?
List out the different types of locks available in sql server?
what is the difference between openrowset and openquery?
When should you use an instead of trigger?
How to convert character strings into numeric values?
What is normalization and what are the advantages of it?
Why and when do stored procedure recompile?
How do I find query history in sql server?
How to provide default values to function parameters?
How do I find the sql server version?