What are the different types of backup avaible in SQL SErver

Answer Posted / devender reddy

The different types of backups in SQL Server are following:

Full Backup
Differential backup
Transcational log backup

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we perform backup restore operation on tempdb? : sql server database administration

582


Do you know spatial data types - geometry and geography in sql server 2008?

576


How do I trace a query in sql server?

541


Explain primary key in sql server?

565


List all the types of user-defined functions?

520






What are different types of subquery?

718


How to receive returning result from a query?

584


What are trace flags?

596


How many columns can exist together per table?

703


How to read data in a table with "select" statements?

555


Why de-normalization required?

569


How do I find sql server instance name?

505


What is the difference between system objects and user objects?

703


what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

497


What are .mdf files?

518