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 is the dbcc command and why is it used?
Can multiple columns be used in sql group by clause in ms sql server?
How do you check sql server is up and running?
What is ms sql server index?
What is onf in normalization form?
What is TDS(Tabular Data Stream) Gateway?
What are cursors and when they are useful?
What is the need for group functions in sql?
What is table valued function and scalar valued functions?
How do I make a resultset scrollable?
What is filtered index?
What are the different types of backups that exist?
Can we take the full database backup in log shipping?
Tell me what is fill factor?
How do I view a stored procedure in sql server?