Briefly explain the different SQL Server backup types
What will be an ideal response?
SQL Server supports three types of backup: full, differential and transaction log. The full backup backs up the complete database with transaction logs. The differential backup backs up only the changes since the last full backup. The transaction log backup backs up only the current transaction log, which is helpful if there are a lot of transactions occurring on a regular basis.
You might also like to view...
Which of the following is correct for a firm that places orders for an item in amounts greater than the economic order quantity?
A) total cost of ordering and carrying has been maximized B) the marginal carrying cost per item exceeds the marginal reduction in order cost C) the marginal reduction in order cost exceeds the marginal carrying cost per item D) total order costs exceed total carrying costs
Which of the following statements about decision making within the sales organization is true?
A. The significance of the decision has no effect on the level at which the decision will be made B. Firms that have many low-paid salespeople who perform relatively routine sales tasks usually place the decision-making authority in the hands of its top sales executives C. As a general rule of organization, the more important a decision is for the success of the firm, the higher the level of management that should make the decision D. As a rule, field-line sales managers are responsible for seeing that sales tasks are completed, but have no decision-making authority E. Firms that have professional salespeople who perform complex sales tasks typically place all decision-making authority in the hands of its salespeople