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.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass