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

What is the dbcc command and why is it used?

573


Can multiple columns be used in sql group by clause in ms sql server?

554


How do you check sql server is up and running?

514


What is ms sql server index?

565


What is onf in normalization form?

574






What is TDS(Tabular Data Stream) Gateway?

99


What are cursors and when they are useful?

577


What is the need for group functions in sql?

567


What is table valued function and scalar valued functions?

497


How do I make a resultset scrollable?

515


What is filtered index?

655


What are the different types of backups that exist?

684


Can we take the full database backup in log shipping?

544


Tell me what is fill factor?

558


How do I view a stored procedure in sql server?

522