I'm looking for some best practices in regards to SQL Server 2008 database backup and restores on Server 2008 R2. Traditional we've utilized SQL Server's backup agent for BAK files for backup/recovery purposes and developmental/testing purposes. We've always used the BAK file method because it made restoring or creating a test DB very straightforward in SQL server management studio.
Does anyone know what Veeam suggests/recommends for individual DB restoration?
Here's an example use case,
Let's say a developer wanted to test or troubleshoot a database error that occurred 4 days back. The developer would like to take the data that was contained in the database from 4 days ago and create a test database. Utilizing Veeam what'd be the best approach to extract the data from Veeam backup that was taken 4 days ago then taking that data, create a test database and restore the data to the test database?
Thanks,
Jeromy
-
- Influencer
- Posts: 16
- Liked: never
- Joined: Jan 07, 2011 8:50 pm
- Full Name: Jeromy Hensley
- Contact:
-
- Chief Product Officer
- Posts: 31746
- Liked: 7250 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: SQL Server 2008 Backup Best Practices
You are essentially describing what v5 "On-Demand Sandbox" functionality does for you automatically, with just a few mouse clicks. I suggest that you review sticky FAQ topic, and view the corresponding recorded webinars. Thanks.jeromyhensley wrote:Let's say a developer wanted to test or troubleshoot a database error that occurred 4 days back. The developer would like to take the data that was contained in the database from 4 days ago and create a test database. Utilizing Veeam what'd be the best approach to extract the data from Veeam backup that was taken 4 days ago then taking that data, create a test database and restore the data to the test database?
-
- Influencer
- Posts: 16
- Liked: never
- Joined: Jan 07, 2011 8:50 pm
- Full Name: Jeromy Hensley
- Contact:
Re: SQL Server 2008 Backup Best Practices
Thanks for the advice Gostev.
Who is online
Users browsing this forum: Google [Bot] and 2 guests