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

what happens on checkpoint? : Sql server database administration

1109

Do you know the cursor optimization tips?

990

What is measure group, measure? : sql server analysis services, ssas

1018

Can you get second highest salary from the table?

966

What is SQL Azure Federations?

112

What are the reporting services components?

143

What is the difference between clustered and a non-clustered index?

1031

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

930

Explain candidate key, alternate key, and composite key?

1003

What happens if null values are involved in bitwise operations?

1031

Explain hostprotectionattribute in sql server 2005?

1040

What is create command?

974

What is a functions and types in sql server?

1089

What are the advantages of partitioning?

1133

What are truncate options available in sql server? : sql server database administration

1035