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


Please Help Members By Posting Answers For Below Questions

What is transaction server isolation?

580


Tell me what is difference between clustered and non clustered index?

560


What is the usage of sign function?

598


What do you mean by 'normalization'?

609


Why do we use non clustered index?

555






What is an example of a foreign key?

512


What is CTE in SQL

545


how to invoke a trigger on demand? : Sql server database administration

567


which backup strategy you are following at ur company

1735


Explain difference between control flow and data flow?

535


How to loop through result set objects using odbc_fetch_row()?

473


What is the process of indexing?

522


Please illustrate physical database architecture? : SQL Server Architecture

538


What are the dmvs?

575


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

527