Thursday, April 16, 2009

SQL server database backup - Important to check the backup policy

Recently , we have a sql server data corruption that needed the backup to be restored. We have two scheduled backup , 1 is to a backup disk and the other one is to the backup tape.

After checking the backups, found out that the only usable restoration is by using the backup tape. This is because the task to backup to tape reinitialized the transaction log , this caused the folder backup cannot be restored to point in time.

The point is, Make sure that if there are two backup policy ensure that both of them didn't clear the other one backup transaction log.

No comments: