Differences between Standby Vs No recovery?
Answer Posted / guest
in standby mode the database exists to access for readonly
purpose
we can use the database for read only we can not able to
modify
in no recovery mode the database is not accessible
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is join query?
What are the differences between decimal and float in ms sql server?
What are parameterized reports? What are cascading parameters in ssrs reports?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What are the ways available in sql server to execute sql statements?
What are the components of sql server service broker?
What are “lost updates”?
List out the differences between global and local temp tables in sql server?
What is the default server name for sql server?
How to add a new dsn with the odbc driver for sql server?
tell me the disaster recovery plan
What is query optimization process?
Can another user execute your local temporary stored procedures?
What is meant by Active-Passive and Active-Active clustering setup?
What is report subscription?