I have set up a jobs for backup
1)Job which runs weekly takes the full backup
2)Job runs daily which takes the differential backup
3)job runs every 2 hrs takes transaction log
stmt for that are
1) For full database backup
BACKUP DATABASE [SLR] TO DISK = N'E:\Backup\SLRFullBackUp' WITH NOFORMAT, NOINIT, NAME = N'SLR-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
2)For differential backup
BACKUP DATABASE [SLR] TO DISK = N'F:\SLRBackupFiles\SLRDiffDatabase' WITH NOFORMAT, INIT, NAME = N'SLR-Full Database Backup',
NOSKIP, NOREWIND,RETAINDAYS = 7, NOUNLOAD, STATS = 10
3)For transaction log
BACKUP LOG [SLR] TO DISK = N'F:\SLRBackupFiles\SLRLogBackUp' WITH NOFORMAT, NOINIT, NAME = N'SLR-Transaction Log Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
nw the thing the differential backup which shoul run daily should append the file for 7 days i.e until i take full backup and then it should overwrite it after seven days
bt this is nt happening
What code i shoul change in the diffetentialbackup
|
| Author: ashfaqq 04 Oct 2008 | Member Level: Silver | Rating:  Points: 1 |
sql server backup
visit link:http://www.ashfk.blogspot.com
|