Explain different types of BACKUPs available in SQL Server? Given a particular
scenario, how would you go about choosing a backup plan?
Types of backups you can create in SQL Server 7.0+ are Full database backup, differential
database backup, transaction log backup, file group backup. Check out the BACKUP and
RESTORE commands in SQL Server books online. Be prepared to write the commands in
your interview. Books online also has information on detailed backup/restore architecture
and when one should go for a particular kind of backup.
85.What is database replication? What are the different types of replication you can
set up in SQL Server?
Replication is the process of copying/moving data between databases on the same or
different servers. SQL Server supports the following types of replication scenarios:
o Snapshot replication
o Transactional replication (with immediate updating subscribers, with queued updating
o Merge replication