Comprehensive data protection for all workloads
Post Reply
tom11011
Expert
Posts: 138
Liked: 1 time
Joined: Dec 01, 2010 8:40 pm
Full Name: Tom
Contact:

Enterprise vs. Standard: Backup and Replication product

Post by tom11011 » Jan 05, 2012 6:47 pm

I have a question regarding the enterprise vs. standard product.

I understand the enterprise product will allow you to restore individual database items, tables, databases, etc.. because it is application aware, much more easier than the standard product.

However with Standard, is my understanding correct that a sql 2008 database will be backed up ok and be able to be restored ok as part of restoring the entire vm? You would just have to restore the entire VM to get to the database?

Basically, I'm trying to confirm that my sql server 2008 backups are ok with the standard product.

Andreas Neufert
Veeam Software
Posts: 3609
Liked: 636 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: Enterprise vs. Standard: Backup and Replication product

Post by Andreas Neufert » Jan 05, 2012 10:15 pm

Hi tom

Yes you are right.
The backup process is the same.

With enterprise license you can Start the Server in the Lab and restore Single objects.(vmware)
Standard can restore the enitre VM, or guest files.


andy

tsightler
VP, Product Management
Posts: 5344
Liked: 2189 times
Joined: Jun 05, 2009 12:57 pm
Full Name: Tom Sightler
Contact:

Re: Enterprise vs. Standard: Backup and Replication product

Post by tsightler » Jan 06, 2012 12:58 am

Right, with the standard product you can restore a SQL database without restoring the entire VM by using a file level restore. You simply unmount the SQL database, restore the MDF and LDF files, and then mount the database. The enterprise product provides the ability to restore rows in a table or tables within a database, but restoring entire databases is actually the same between the standard and enterprise product.

tom11011
Expert
Posts: 138
Liked: 1 time
Joined: Dec 01, 2010 8:40 pm
Full Name: Tom
Contact:

Re: Enterprise vs. Standard: Backup and Replication product

Post by tom11011 » Jan 06, 2012 2:17 pm

Is there a provision (with the standard product) that would allow a restoral of the database mdf and ldf files from the backup as copies of the files to my desktop and not to the vm from where they came?

tsightler
VP, Product Management
Posts: 5344
Liked: 2189 times
Joined: Jun 05, 2009 12:57 pm
Full Name: Tom Sightler
Contact:

Re: Enterprise vs. Standard: Backup and Replication product

Post by tsightler » Jan 06, 2012 3:31 pm

Sure, you can copy the files anywhere you like.

tom11011
Expert
Posts: 138
Liked: 1 time
Joined: Dec 01, 2010 8:40 pm
Full Name: Tom
Contact:

Re: Enterprise vs. Standard: Backup and Replication product

Post by tom11011 » Jan 06, 2012 3:51 pm

Thanks everyone for your help.

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 26 guests