Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?

Answers were Sorted based on User's Feedback



Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would..

Answer / 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

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would..

Answer / 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

More SQL Server Interview Questions

What are the different normalization forms?

0 Answers  


What is save transaction and save point?

0 Answers  


Explain about extended stored procedure?

0 Answers  


What are the types of normalization?

0 Answers  


How to verify the port number of the sql server?

0 Answers  






Where are sql server usernames and passwords stored in the sql server?

0 Answers  


What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,


Which data type columns are the best candidates for full-text indexing?

0 Answers  


What is indexing a document?

0 Answers  


how many type of subquery?

2 Answers  


select empid empname from employee What is the result for the about query?

4 Answers  


What the different components in replication and what is their use?

0 Answers  


Categories