AppAssure

• pharmkittie

  SSCertifiable

  Points: 5775

  More actions

  May 15, 2013 at 11:42 am

  #272688

  Hello,

  I am wondering if anyone has experience with AppAssure and disaster recovery of SQL Server databases? I have googled (a lot for many weeks) and I cannot find anyone who hassaid anything about using AppAssure to restore databases.

  The marketing literature says that the database will just be restored perfectly to the point in time of the last snapshot. I am specifically curious if there are any gotchas or caveats that anyone knows of or there literally is nothing for the DBA to do after a disaster when one has AppAssure. Just to clarify, I'm not worried about the data loss between the snapshot and the restore for the sake of this discussion. i want to focus in on whether anything needs to happen after the AppAssure restore of a volume (e.g. reseed identity columns, first aid for SQL Server Replication, etc.) Any thoughts from those who know about AppAssure would be much appreciated.

  P.S. I don't have the ability to do a mock restore, my management has said they don't want to do that. Trying to duplicate our complex prod environment at home isn't an option either.

  Thanks.