LiteSpeed and NetApp SnapManager

• Milovan Banicevic-413693

  Grasshopper

  Points: 18

  More actions

  July 21, 2011 at 8:22 pm

  #254694

  Hi :-),

  I need an opinion from somebody who has experience in SQL Server database backup management using Snap Manager.

  My company utilise several enterprise applications that use SQL Server backend. There are number of dependencies between databases enforced by BizTalk adapters. Some of databases are backed up using LiteSpeed while some through usage of NetApp Snap Manager.

  LiteSpeed can restore database in "point of failure" (by applying log tail). On other side, I was able to perform "point of time" recovery with Snap manager but not in "point of failure". Such a scenario leaves the hole in my disaster recovery approach.

  For example:

  Application "A" perform transaction on database that belongs to application "B" (using BizTalk adapter) and in same time it records information in its own database. A database used by application "A" is backed up with LiteSpeed while application "B" database is backed up with Snap Manager.

  If disaster strike database "A" (backed by LiteSpeed), I will not have orphan rows in database "B" tables because I can restore database "A" in point of failure, but if we experience corruption on database "B" (backed by Snap Manager), I will have orphan rows in database "A" tables. It makes it more complicated because one of databases is utilised by document management system.

  Currently, taking in consideration that data loss within database "A" is "less evil" than orphan records, I am considering solution where I can restore database "B" in point of time where last snapshot taken and restoration of database "A" in same point of time as database "B" (accepting data loss in database "A"). It make it worse because it is not just two application integrated through BizTalk.

  My questions are:

  - Did anybody have similar scenarios and what kind of solution has been applied?

  - Is there any way that database can be restored in point of failure using Snap Manager?

  - Is it possible to backup a tail log using SQL Server native backup and add as a last log in a restore process managed by Snap Manager?

  I appreciate all opinions and disclosed cases from you experience.

  Regards,

  Milovan