Comprehensive data protection for all workloads
Post Reply
wocomike
Influencer
Posts: 19
Liked: never
Joined: Dec 16, 2009 12:50 am
Contact:

Restoring SQL Databases Backed Up Via VSS

Post by wocomike » Dec 16, 2009 12:56 am

Hi All,

We're looking at using VEEAM as our only backup solution... If we need to restore individual files, we will use VEEAM, instead of another product we were using for file-level backups.

My question is about SQL and Exchange restores. I read that VEEAM uses VSS to ensure that Windows files are able to be restored without errors. Is this true for SQL and Exchange as well? Could I just restore the .mdf and .ldf files and attach them within SQL?

Thanks!

-Mike

TrevorBell
Expert
Posts: 353
Liked: 7 times
Joined: Feb 13, 2009 10:13 am
Full Name: Trevor Bell
Location: Worcester UK
Contact:

Re: Restoring SQL Databases Backed Up Via VSS

Post by TrevorBell » Dec 16, 2009 8:29 am

Hi mike,

using vss makes the files transactionally correct and I have used this method to restore certain databases and re attach so the answer is yes got SQL , my exchange is still physical but you can use a tool from quest to restore exchange very easily, just so a search on the forum you will see some good feedback and links

thanks trev

Gostev
SVP, Product Management
Posts: 24439
Liked: 3409 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Restoring SQL Databases Backed Up Via VSS

Post by Gostev » Dec 16, 2009 2:26 pm

Hello Mike, if you are using Veeam VSS integration - then yes, it is true for any Windows application which are Microsoft VSS compatible and provide VSS writer that implements application-specific quiescence procedures. Most Microsoft apps have it today (Microsoft has introduced the shadow copy technology almost 7 years ago). So DC, Exchange, SQL, SharePoint, IIS files are all backed up in the transactionally consistent form. This also any 3rd party apps featuring Microsoft VSS integration (so-called VSS writer), for instance Oracle 11g with their VSS integration module installed (also compatible with 10g starting certain patch level).

donikatz
Expert
Posts: 124
Liked: never
Joined: Jan 01, 2006 1:01 am
Contact:

Re: Restoring SQL Databases Backed Up Via VSS

Post by donikatz » Dec 16, 2009 9:54 pm

Mike-- As others have said, that will work fine for SQL, but if you're planning to replace your Exchange file-level backup, you'll have to ask yourself the business need. If you have the need to restore individual objects (brick level), Veeam alone has no one-click solution, but it's very achievable.

Here is a good thread on the topic: Anyone have a tool to recover single email in Exchange?

At our company we currently use both Veeam and Symantec Backup Exec for Exchange, with Veeam for DR/BC and Symantec for more-granular restores. However, we're always reevaluating business needs.

Gostev
SVP, Product Management
Posts: 24439
Liked: 3409 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Restoring SQL Databases Backed Up Via VSS

Post by Gostev » Jan 11, 2010 1:14 pm

SQL is well covered in the responses above, and here is a good thread about full image Exchange backups with Veeam VSS: Exchange "backed up" flag?

Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 24 guests