FALCONSEYE
Programmer
My differential and transactional backup files are very big. (54 gig and 22 gig respectively). My current backup strategy is to do a full back up once a week, do a diff backup once a day and do 15mins tx backups. Is there a way to set the diff and tx backups so that it will start all over again from the time the full backup is executed? This is what I have:
backup database xxx to
disk = 'D:\sqlBackUp\xxxDiff_BackUp.bak'
with differential
backup log xxx to xxxTxLog
Please let me know if there is a better way of doing this. thanks
backup database xxx to
disk = 'D:\sqlBackUp\xxxDiff_BackUp.bak'
with differential
backup log xxx to xxxTxLog
Please let me know if there is a better way of doing this. thanks