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 difference between DATETIME2 and DATETIME?

625


What is data mart? : sql server analysis services, ssas

592


Can you explain about buffer cash and log cache in sql server?

499


Explain how to use linked server?

563


After removing a table from database, what other related objects have to be dropped explicitly?

553






What are the 3 types of schema?

597


What are the advantages of using stored procedures?

538


How to convert a unicode strings to non-unicode strings?

561


Why I have to use stored procedures?

590


How to connect of datebase with sql express.?

618


Explain error and transaction handling in sql server?

497


Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

106


What are types of scd? : sql server analysis services, ssas

538


What does select 1 mean?

531


What are the recovery models in sql server 2000?

556