Differential Backup SQL Server 2008R2 Express

if you are already doing full backups of SQL Server, as a DBA you would know that that does not cut it, and that you need to do Differential and Transactional.

This is an additional article to:

http://blog.zwiegnet.com/windows-server/backup-sql-server-express-2008r2/

Please review the above steps, otherwise it could result in Data Loss.

What would you want to backup Transactional/Differential Backups? That way there is less chance of data loss. If you do a full data Dump at 12PM every day, you will loose all data (possibly 1000’s or Millions of SQL Transactions, you can restore Quicker this way)

Let’s Dig Into SQL Server!

Let’s use our SUSDB (Windows Update Database) as an example

Right Click and then go to tasks and backup

Let’s Change the type from Full to Differential (takes only what’s changed since last full backup)

Since We are Outstanding DBA’s, were going to go to “options” and then select “verify”

(if you know anything about backups/SQL, you know that it can only be to your advantage to verify backups)

From there we are going to script to a backup file

and schedule the task (to schedule, see the original link at the top for more info on that process.

That’s it! If you are interested in a hosted Windows or SQL Server, visit www.zwiegnet.com/go to get started today!