Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server disaster recovery - advice about AppAssure Expand / Collapse
Author
Message
Posted Wednesday, May 8, 2013 10:50 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, December 5, 2014 3:44 PM
Points: 88, Visits: 504
Hello,
We are on SQL Server 2012 but I don't think that matters a lot for my question (I'm posting to 2005 as it has the backup forum). Does anyone know what steps to take after AppAssure restores an entire SQL Server instance to a server? I have scoured the vendors very sparse documentation and there aren't any details. They have some marketing materials that say it just works but my boss wants a step-by-step document saying what needs to be done after a complete restore. I am not allowed to test a recovery so that i can learn by doing.

It may sound like I'm being lazy but I really have done a lot of google searching and reading of blogs, vendor docs, etc. to try to get the answer. If you have a link to point me to that would be great. I realize that not many who read this will be using AppAssure but I'm hoping...
Thanks.
Post #1450696
Posted Wednesday, May 8, 2013 11:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 12,953, Visits: 32,483
interesting, my knee jerk reaction is That I would still script out for disaster recovery, an d keep performing native backup and disaster recovery for SQL server regardless of the high level sales literature that implies it's the best solution since sliced bread.
I read the Dell corporate fluff at these two links:
http://www.appassure.com/server-backup-replication-and-recovery/
http://www.appassure.com/downloads/Dell_AppAssure_Specsheet.pdf

and it appears to be a server solution that happens to try to take care of SQL

Recovery Assure™
Detects the presence of Microsoft Exchange and SQL and its
respective databases and log files, then carries out a nightly test to
confirm that database application backups are fully recoverable. If any
backup fails this test, a notification is automatically sent so you can
resolve the problem immediately


and version support:

SQL Server support
• MS SQL Server 2012, 2008 R2, 2008,2005
• MS SQL clusters based on Microsoft Cluster Server


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1450698
Posted Wednesday, May 8, 2013 11:03 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, December 5, 2014 3:44 PM
Points: 88, Visits: 504
Thanks. Agreed but my boss and his network admin LURVE AppAssure. They don't react well to any ideas that it's not the bees knees. He wanted me to disable all SQL backups because they are superfluous in his mind but I convinced him to let me keep them (for one day only though).

Oh yes, I have scripted everything out for DR but I need to make the cookbook for the AppAssure recovery. That's the one he wants to see.
Post #1450700
Posted Wednesday, May 8, 2013 11:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 12,953, Visits: 32,483
remind him about partial data recovery and point in time restores.

the little bit i read says NIGHTLY backups, and does not mention SQL Server point in time recoveries throughout the day.
if something goes wrong late in the day, can the business lose the entire days data to last nights restore?

For partial point in time restores, you need the native full + transaction log backups so you can restore to a new database and MERGE data to fix those issues like when someone accidentally inserts/updates one specific table's worth of data, and that's the only thing you have to recover.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1450704
Posted Wednesday, May 8, 2013 12:04 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, December 5, 2014 3:44 PM
Points: 88, Visits: 504
Thanks very much for all the information Lowell. He says we can failover from VMware replica (VMware replica though we have transactional replication too. I'd have to make the subscriber the publisher. I pointed out that the subscriber isn't symmetrical with the publisher and he said, "make it so"). I'm new to this company.

I still need the AppAssure steps after restore if anyone uses the software.
Post #1450730
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse