SQL Server DBA Tutorial 72-How to Manually Take Differential backup of a Database in SQL Server

preview_player
Показать описание
In this video you will learn how take Differential backup of a database in sql server 2005, 2008, 2012 and 2014 using SQL server management studio as well as using T-SQL Script. It is a step by step tutorial of taking differential backup of a database as well as walk through of different options and their best practices while taking Differential backup of SQL Server database.

Blog link for this video:

Visit our website to check out SQL Server DBA Tutorial Step by Step
Рекомендации по теме
Комментарии
Автор

I think how you are telling GUI and TSQL command line. That is great!

paracha
Автор

I noticed in your previous vid you did the full backup while in the salesorder db when you completed the backup using TSQL. And in this video you did the differential back up while in the master dB, does it matter what database you’re in?

michaelreynoso
Автор

One of the last videos you told us that you do differential bakcups to complete a full back up made before or to complete even another differential backup, how can I set the full back up, the differential back up will be based on to make the differential back up

alejandrocuervo