What are different backups available in sql server?



What are different backups available in sql server?..

Answer / Chandan Gupta

Different backups available in SQL Server include Full Backup (creates a complete backup of the database), Differential Backup (backs up only the data that has changed since the last full or differential backup), and Transaction Log Backup (captures all transactions made after the last full, differential, or transaction log backup).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What happens if null values are involved in string operations?

1 Answers  


Questions regarding Raiseerror?

1 Answers  


what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,


why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  


What are the advantages of stored procedure in sql server?

1 Answers  


Why transaction is important?

1 Answers  


What is data source document?

1 Answers  


What is open database communication (odbc)?

1 Answers  


How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,


What do you understand by a stored procedure?

1 Answers  


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1 Answers  


what is difference between NULL and ISNULL in SQL Server 2008?

1 Answers   MCN Solutions,


Categories