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
Explain the concept of view and Types of views in SQL server?
What does it mean to invest in the index?
What is the difference between char and varchar2 datatype in sql?
Write down the syntax and an example for create, rename and delete index?
Explain contrast amongst grouped and non-bunched records?
How do I find the default sql server instance?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Define left outer join in sql server joins?
What is replication and database mirroring?
Explain what is the difference between a local and a global temporary table?
Does index speed up select statements?
How to restore performance issues and how to check?
What is b tree index?
What are magic tables in sql server?
What is rs.exe utility?