I am working with DB backup, first I would like to get a roughly plan on weekly/daily backup. I have countered some problems when I am trying to get such a plan, What I tried is:
FULL DATABASE BACKUP, using:
BACKUP DATABASE name To Disk... WITH INIT,SKIP;
Can I set it to
SKIPand overwrite the old full backup file every week? If I did not add
RETAINDAYS, does that mean the current backup will not overwrite the existing one because the old one never expires?
Differential DATABASE BACKUP, using
BACKUP DATABASE name To Disk... WITH DIFFERENTIAL,INIT,SKIP;
How does the SQL Server know which full backup is daily differential based on? By using
WITH FORMAT, MediaName='...'? If so, does that mean for the first time I do the full database backup I need to format a new media set such as
DatabaseAset for that database, and for the later back up, I could use
WITH NOFORMAT, medianame = DatabaseA'to let sql server knows that differential backup should be attached to that full backup database?
For transaction log backup, using
BACKUP LOG A TO DISK...
I know it is not good to add
WITH INITto log backup, but how to handle the increasing size of log backup?
Shrinkfile(log)each time I did the full database backup? Does that mean I could ignore the increasing size of transaction log before the next full backup comes?