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
-
- Influencer
- Posts: 23
- Liked: 1 time
- Joined: Dec 16, 2009 12:50 am
- Contact:
-
- Veteran
- Posts: 357
- Liked: 17 times
- Joined: Feb 13, 2009 10:13 am
- Full Name: Trevor Bell
- Location: Worcester UK
- Contact:
Re: Restoring SQL Databases Backed Up Via VSS
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
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
-
- Chief Product Officer
- Posts: 31754
- Liked: 7259 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: Restoring SQL Databases Backed Up Via VSS
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).
-
- Expert
- Posts: 116
- Liked: never
- Joined: Jan 01, 2006 1:01 am
- Contact:
Re: Restoring SQL Databases Backed Up Via VSS
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.
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.
-
- Chief Product Officer
- Posts: 31754
- Liked: 7259 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: Restoring SQL Databases Backed Up Via VSS
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?
Who is online
Users browsing this forum: Semrush [Bot] and 81 guests