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.
No comments:
Post a Comment