May 8, 2009 at 3:45 am
Well, it all depends on business requirement. But I would not suggest to erase the previous backups. keep them to some other disks OR on tape (if possible) you never know when you need to restore few days older backup may be till some time(in case of corruption or uses deleted something etc.)
May 8, 2009 at 4:12 am
sumanta.roy52 (5/8/2009)
Hi,What does differential backup capture? I mean does it take the changes from last full backup/last differential backup.
Last full backup. So if you have a full on Sunday, a diff on Monday, Tuesday and Wednesday, to restore to Thursday morning you need the sunday full, just the Wednesday diff and then the log backups from there aon.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 8, 2009 at 4:18 am
sumanta.roy52 (5/8/2009)
Hi,I am taking full backup everyday 23:00 and overwriting it with the existing one. Transaction log every one hour and appending it every hour to get to get all the logs. So transaction log is getting increased. Is it good to delete the whole tranlog after the full backup and creating new one every day?
What happens if you have only one full backup, you go to restore it and find that it's corrupt?
Are those older backups going to tape, or just been overwritten.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 8, 2009 at 4:22 am
Hi,
It's better to take the System Databases backup regularly ( it can be on daily basis or weekly), as it helps a lot in case of any disaster scenario.:-P
May 8, 2009 at 5:51 am
Hi all,
Thanks to all of you...
While taking differential backup, do we need to append it every time or we can overwrite everytime?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
May 8, 2009 at 8:27 am
sumanta.roy52 (5/8/2009)
While taking differential backup, do we need to append it every time or we can overwrite everytime?
Again, what happens if you have only one backup, you go to restore it and find that it's corrupt?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply