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 )

Advertisements

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)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s