Backing up SQL Server is different than backing up your conventional file or app servers. Databases have a few really big files, and you don’t want to back up the file itself, and the file is constantly changing, 24/7. Rather than file-level backups, you have 3 common choices: server-level snapshot backups, native full SQL Server backups, and transaction log backups. In this session, I’ll explain the pros and cons of each one, and explain where each one makes the most sense.

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu