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

Enterprise vs. Standard: Backup and Replication product

Post by tom11011 »

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
VP, Product Management
Posts: 7073
Liked: 1506 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 »

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: 6034
Liked: 2859 times
Joined: Jun 05, 2009 12:57 pm
Full Name: Tom Sightler
Contact:

Re: Enterprise vs. Standard: Backup and Replication product

Post by tsightler »

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: 192
Liked: 9 times
Joined: Dec 01, 2010 8:40 pm
Full Name: Tom
Contact:

Re: Enterprise vs. Standard: Backup and Replication product

Post by tom11011 »

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: 6034
Liked: 2859 times
Joined: Jun 05, 2009 12:57 pm
Full Name: Tom Sightler
Contact:

Re: Enterprise vs. Standard: Backup and Replication product

Post by tsightler »

Sure, you can copy the files anywhere you like.
tom11011
Expert
Posts: 192
Liked: 9 times
Joined: Dec 01, 2010 8:40 pm
Full Name: Tom
Contact:

Re: Enterprise vs. Standard: Backup and Replication product

Post by tom11011 »

Thanks everyone for your help.
Post Reply

Who is online

Users browsing this forum: Google [Bot], jsuh and 40 guests