Host-based backup of VMware vSphere VMs.
Post Reply
leonelferreyra
Influencer
Posts: 12
Liked: never
Joined: Dec 06, 2020 2:41 pm
Full Name: Leonel Ferreyra
Contact:

Veeams sql database(2008r2) on main sql VM

Post by leonelferreyra »

I m new to veeam, and have read a lot of pdf to start and build the best scenario for our needs. We have a small environment, 45 vm to backup, 2 sql 2008R2 STD (1 production/ 1 testing development), I understand that for using sql/exchange explorer for big databases (larger than 10GB) the sql express version is not enough, so we can set veeams database on one of our 2 sql. My doubt is about when you backup the sql vm (production or Testing) hosting the veeams own database, is this posible or does it has any problem?
Sorry if this question seems fool, but havent find a direct answer from any reading yet. Thanks
Mildur
Product Manager
Posts: 9846
Liked: 2604 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Veeams sql database(2008r2) on main sql VM

Post by Mildur » 1 person likes this post

You donˋt have to move your veeam database todo restores of big sql databases.
You can configure your sql std as a staging server and leave the veeam database on your sql express.

https://helpcenter.veeam.com/docs/backu ... ml?ver=100

And if you decide to move the database, veeam do not have any problems with the backup of your sql servers :)
It‘s possible and supported.
The vm will be automatically moved to the end of the backup job processing after all other vms in the job are backuped.
Product Management Analyst @ Veeam Software
leonelferreyra
Influencer
Posts: 12
Liked: never
Joined: Dec 06, 2020 2:41 pm
Full Name: Leonel Ferreyra
Contact:

Re: Veeams sql database(2008r2) on main sql VM

Post by leonelferreyra »

Hey tanks for your reply, this is really clear and a great function I didnt knew Veeam had the stage sql, Ill try this one. Thanks
leonelferreyra
Influencer
Posts: 12
Liked: never
Joined: Dec 06, 2020 2:41 pm
Full Name: Leonel Ferreyra
Contact:

Re: Veeams sql database(2008r2) on main sql VM

Post by leonelferreyra »

I understood the sql stage process, but now I have the doubt about veeam explorer for microsoft exhange, in my case my database for echange is arround 25 GB, so does this explorer utilize the sql express on my veeam server or is any way to set an stage resource as per the sql. Thanks
Mildur
Product Manager
Posts: 9846
Liked: 2604 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Veeams sql database(2008r2) on main sql VM

Post by Mildur » 1 person likes this post

Exchange has nothing todo with ms sql staging server. They are completly different products

You don‘t have todo anything, just start a application level restore for exchange items.
No SQL Server will be needed for this restore.
Product Management Analyst @ Veeam Software
leonelferreyra
Influencer
Posts: 12
Liked: never
Joined: Dec 06, 2020 2:41 pm
Full Name: Leonel Ferreyra
Contact:

Re: Veeams sql database(2008r2) on main sql VM

Post by leonelferreyra »

Thanks!!!
Post Reply

Who is online

Users browsing this forum: Google [Bot], Semrush [Bot] and 59 guests