by

SQL SERVER – Explain different types of BACKUP’s 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 Sever 7.0+ are Full database backup, differential database backup, transaction log backup, filegroup 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.

Reference : Dilip Kumar Jena ( https://sqlexplore.wordpress.com )

One thought on “SQL SERVER – Explain different types of BACKUP’s available in SQL Server? Given a particular scenario, how would you go about choosing a backup plan”

  1. You can also use a program to make SQL Server backup like Handy Backup (http://www.handybackup.net/sql-server-backup.shtml)

    Reply

Leave a comment