What are the different types of backup avaible in SQL SErver

Answer Posted / pavan

full
differential
transaction
taillog
copy_only
mirror
files and file group
partial

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What command would you use to create an index?

586


How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

549


What is meant by dirty read?

556


What is field with example?

513


What is the difference between truncate and delete commands?

563






Explain the truncate command? : SQL Server Architecture

562


What is full outer join in sql server joins?

565


Can we delete data from a view?

542


What are the different acid properties?

622


How to create a testing table with test data in ms sql server?

556


Can two tables share a primary key?

514


What is the significance of master, tempdb and model databases?

523


What is sleeping status in sql server?

516


Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

569


What are dml triggers and types of dml triggers?

547