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
What is the difference between a function and a stored procedure?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is the usage of the sign function?
Differentiate between a having clause and a where clause.
What is read uncmmited?
Can group by be used without aggregate functions?
What are views in ms sql server?
What are the advantages of paper records?
How to create a simple table to test triggers in ms sql server?
Why and when do stored procedure recompile?
Explain system views?
Explain the properties of sub-query in sql server?
Does index slows down insert statements?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
How to join two tables in a single query in ms sql server?