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 is the query and subquery?

1073

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1100

What is sparse columns of sql server 2008?

1045

Explain about remote stored procedure?

1007

How to list all columns in a table using odbc_columns()?

972

What is the difference between drop table and truncate table?

920

Ways to improve the performance of a SQL Azure Database?

125

Give a example to search fr a string in all stored procedure in sql server.

978

What is database mirroring?

1106

What is the importance of concurrency control?

1220

Explain primary key, foreign key and unique key?

987

What is normalization of database?

1097

What are subquery and its properties?

1041

What are the restraints imposed on the table design by a merge replication?

1033

How you can find out if an index is useful to the optimizer?

935