full differential transaction taillog copy

What are the different types of backup avaible in SQL SErver

Question Posted / pavan

Answer Posted / pavan

full
differential
transaction
taillog
copy_only
mirror
files and file group
partial

Is This Answer Correct ?

1 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How to drop existing indexes in ms sql server?

685

Explain what are the different index configurations a table can have?

773

Can primary key be null?

602

What do you mean by the term 'normalization'?

763

What is difference between view and materialized view?

612

What protocol does sql server use?

602

How to return the second 5 rows in ms sql server?

713

How to update multiple rows with one update statement in ms sql server?

739

How to create a simple user defined function in ms sql server?

638

How to return the top 5 rows from a select query in ms sql server?

687

Can we check locks in database? If so, how can we do this lock check?

610

what exactly sql injuction.how to overcome.....

2141

what are the new features in SSRS?

111

How dts is used to extract, transform and consolidate data?

671

What are subqueries in sql server? Explain its properties.

626