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 hot add cpu in sql server 2008?
Explain can you implement data mining in ssrs?
What is a trace frag?
What is etl - extraction, transformation, and loading?
How to change the system date and time from SQL Plus Terminal ?
Tell me what is the order in which the sql query is executed?
How do I find information about the install locations for the various instances running on a computer?
Mention the differences between local and global temporary tables.
System variable and temporary variables
What are the differences between char and nchar in ms sql server?
List some case manipulation functions in sql?
Can primary key be a foreign key?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What are the purpose of Normalisation?
Explain about system database?