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
Difference between group by clause and having clause in SQL?
How to transfer an existing table from one schema to another schema in ms sql server?
How to drop an existing table with "drop table" statements in ms sql server?
Tell me what are the essential components of sql server service broker?
do views contain data ?
What are the different types of replication are there in sql server 2000?
Explain about integration services of Microsoft SQL server?
Does windows server 2016 come with sql server?
What is the sql profiler?
What function does a database engine serve in the sql server?
Name and describe few console utilities for ssrs?
What are the different types of Indexes available in SQL Server?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What is trigger and different types of Triggers?
Define normalisation?