backup of TFS with DPM 2007 - different backup times

Posted by user46516 on Server Fault See other posts from Server Fault or by user46516
Published on 2010-06-22T23:40:15Z Indexed on 2012/06/28 9:17 UTC
Read the original article Hit count: 296

I have DPM set up to back up my TFS server every 30 minutes, the reason being it's a way better interface than the quirky SQL backup interface.

I also do a full backup nightly using an SQL maintenance job.

My thinking is I would use DPM to restore my databases in case of losing my database and the nightly full backup would be a "just in case" the DPM restore doesn't work.

I was thinking a little harder about this set up today and started to think about the fact that the DPM backup of the individual databases happens at different 30 min windows.. i.e. one happens at 13h30, another at 13h34 etc.

Would this difference in time be a problem when it comes to restoring the TFS server? If I restore the databases and they are from different times, will this create corruption with pointers in one database pointing to missing items in the other database.. do the databases even rely on each other or are they completely interdependant.

Lastly, how would SQL (log) backup cope with this?

© Server Fault or respective owner

Related posts about sql-server

Related posts about backup