What is difference between restoration and recovery in
SQLServer?

Answer Posted / chandra mouli paidi

Restore is a uploading files back into database

Recovery is missing file finding and reloding in database

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between insensitive and scroll cursor?

581


How optimize sql query with multiple joins in sql server?

417


What is temporal table?

484


How many replicas are maintained for each sql azure db?

106


Can You Use Data Mining Models In Ssrs?

97






What is transaction server isolation?

578


How to delete a login name in ms sql server?

536


Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

534


What is database replication? What are the different types of replication you can set up in sql server?

501


What is the temp table?

545


How to encrypt data between dialogs?

574


What is the status of services on passive node for failover cluster in sql server? : sql server database administration

638


Can we use custom code in ssrs?

588


Explain temporary table vs table variable by using cursor alternative?

523


How to define output parameters in stored procedures?

527