Comprehensive data protection for all workloads
Post Reply
hkanthony
Novice
Posts: 6
Liked: never
Joined: Dec 02, 2011 4:10 am
Full Name: Anthony
Contact:

V6 Veeam backup server - SQL database edition question

Post by hkanthony »

Veeam backup server/enterprise manager bundles a SQL 2005 Express database server.
However In which situation/environment, I need to use a dedicated SQL database (e.g. SQL 2008 Standard edition) instead of the bundles SQL express server on Veeam backup server and Enterprise Manager server.
for example, if the No. of backup VMs is lager than xx, a dedicated SQL database is recommended...etc.
ZachW
Enthusiast
Posts: 68
Liked: 10 times
Joined: Aug 02, 2011 6:09 pm
Full Name: Zach Weed
Contact:

Re: V6 Veeam backup server - SQL database edition question

Post by ZachW »

I'm not sure what exactly you are asking here in that I don't see a question :-) .. But from what I understand you are just trying to point Veeam at an existing SQL DB, which is understandable as well as do-able. All you will need to do is specify the instance within the installation ( as opposed to installing a new SQL instance ) and you should be good to go from there.
hkanthony
Novice
Posts: 6
Liked: never
Joined: Dec 02, 2011 4:10 am
Full Name: Anthony
Contact:

Re: V6 Veeam backup server - SQL database edition question

Post by hkanthony »

Thanks for your reply.
The bundled SQL 2005 Express has 4GB database size limitation.
So I want to know if I need to buy SQL 2008 standard edition instead and how large of the database size of Veeam server will consume.
Any formula to calculate the database size?
for example, if I need to backup 100 VMs with 6 ESXi hosts and keep 1 month retention, how large of the database size?
Vitaliy S.
VP, Product Management
Posts: 27347
Liked: 2785 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: V6 Veeam backup server - SQL database edition question

Post by Vitaliy S. »

Anthony, backups are not stored within the database. Please see existing topic (which is still applicable to v6) for additional information. Thanks!
tsightler
VP, Product Management
Posts: 6031
Liked: 2856 times
Joined: Jun 05, 2009 12:57 pm
Full Name: Tom Sightler
Contact:

Re: V6 Veeam backup server - SQL database edition question

Post by tsightler »

Honestly, I've never seen a B&R database even approach this size limit and you can always upgrade to 2008R2 Express which increases the limit to 10GB.
hkanthony
Novice
Posts: 6
Liked: never
Joined: Dec 02, 2011 4:10 am
Full Name: Anthony
Contact:

Re: V6 Veeam backup server - SQL database edition question

Post by hkanthony »

thanks
seems the database size of veeam is very small and no need to use full MSSQL database.
Post Reply

Who is online

Users browsing this forum: Dima P., pmichelli, restore-helper and 106 guests