Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?

Answer Posted / swapna

Types of backups you can create in SQL Sever 7.0+ are Full
database backup, differential database backup, transaction
log backup, filegroup backup.

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

write an SQL query to list the employees who joined in the month of January?

1382


What is exporting and importing utility?

778


What are different types of data sources?

648


How to use subqueries in the from clause in ms sql server?

806


Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

751






How to disconnect from a sql server using mssql_close()?

779


Why use cursor in sql server?

735


What are the components of sql server service broker?

683


How is sql server used?

692


After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

736


Explain about Views?

775


Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

733


What are approximate numeric data types in ms sql server?

763


What is an identity column in insert statements?

749


Can we use custom code in ssrs?

781