Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?

Answer Posted / swapna

Types of backups you can create in SQL Sever 7.0+ are Full
database backup, differential database backup, transaction
log backup, filegroup backup.

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you fetch alternate records from a table?

625


What happens when converting big values to numeric data types?

652


What is shared lock?

574


What is the meaning of sql server?

617


What is the maximum row of a size?

655






What is difference between rownum and rowid?

592


Describe and explain about SQL native client?

691


How to find the second highest salary of an employee?

683


how will add additional conditions in sql?

663


How many instances per computer are there in sql server 2000?

659


Can you please differentiate between a primary key and a unique key?

628


What is the difference between rank and dense_rank?

591


Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

721


What is a system database and what is a user database?

670


Is resultset an interface?

632