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

How to copy data from one table to another table?

544


List all types of constraints in sql server?

514


What is report rendering ?

102


What are different types of data sources?

494


How and why use sql server?

544






What is log in sql server?

590


If a stored procedure is taking a table data type, how it looks?

5802


What is the use of @@spid?

574


How to modify existing triggers using "alter trigger"?

529


you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

553


What is the use of set nocount on/off statement?

626


Is a primary key unique?

540


Tell me what do we need queues in sql service broker?

522


What are logical/boolean operations in ms sql server?

541


How exceptions can be handled in sql server programming?

545