Full/Differential backup - what's used to determine the differential backup content?
Posted
by gernblandston
on Server Fault
See other posts from Server Fault
or by gernblandston
Published on 2010-04-06T19:37:27Z
Indexed on
2010/04/06
19:43 UTC
Read the original article
Hit count: 232
sql-server-2005
|backup
Let's say I have a 'MyDB' SQL Server 2005 database (simple recovery) in which I do a Full backup on Sunday, and Differentials every other night
BACKUP DATABASE [MyDB] TO DISK = N'c:\Database Backups\MyDB\MyDB_Full.bak'
WITH NOFORMAT, INIT, NAME = N'MyDB.BAK', SKIP, NOREWIND, NOUNLOAD, STATS =
10
and
BACKUP DATABASE [MyDB] TO DISK = N'c:\Database Backups\MyDB\MyDB_Diff.bak'
WITH NOINIT, DIFFERENTIAL, NAME= 'MyDB.BAK', STATS= 10
What does the differential backup process use to decide what data gets backed up on the differential nights? Does it need the mydb_full.bak file to do its business?
If I wanted to save disk space, could I zip up the mydb_full.bak file to a .zip file after it's created without adversely affecting the differential backups, and if I needed to restore, just unzip the full backup before starting?
© Server Fault or respective owner