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
What are the diifferences between the ms sql server vs mysql?
What are the different types of lock modes in sql server 2000?
What will happen if a column containing char type data is changed to the nchar data type?
What is bit data type?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
what is nonclustered index
Can sql server be linked with other servers like oracle?
What is sql azure database?
How many replicas are maintained for each sql azure db?
Tell me what is difference between clustered and non clustered index?
What are user defined functions in ms sql server?
What are the steps to follow to configure SQL*Net?
How to edit table in sql server 2017?
What do you mean by an execution plan? Why is it used?
What is a not null constraint?