Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
Answer Posted / raghuram
different types of BACKUPS available in sql server are full
database backup, differential database backup,
transactional log backup, files and filegroup backup.
for new database we will go for full database backup, and
if the the database is in full database backup type,then we
do differential database backup or transactional log backup.
if the database size is too heavy means the database is
VLDB then we go for files and filegroup database backup.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Write a SQL query to delete a table?
How to drop an existing stored procedure in ms sql server?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
List down some advantages of sql stored procedure?
How to delete an existing database user?
What are date and time data types in ms sql server?
What is the log shipping?
What is raiseerror? What is raiseerror?
Determine when an index is appropriate?
What is query processing?
How to select some specific rows from a table in ms sql server?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What is page-level compression?
What is the web service used for reporting services?