-
- Expert
- Posts: 192
- Liked: 9 times
- Joined: Dec 01, 2010 8:40 pm
- Full Name: Tom
- Contact:
Enterprise vs. Standard: Backup and Replication product
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.
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.
-
- 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
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
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
-
- 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
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.
-
- 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
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?
-
- 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
Sure, you can copy the files anywhere you like.
-
- 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
Thanks everyone for your help.
Who is online
Users browsing this forum: Google [Bot], jsuh and 40 guests