Hi all,
I have a team mate reporting that on our process of restoring DBs to the local server Veeam is installed on, for object level restores there is a blocker due to the SQL version be Express.
They would like me to consider upgrading from SQL2017 Express to SQL2017 Standard. Would like to hear any pros and cons.
Thank you.
-
- Expert
- Posts: 192
- Liked: 9 times
- Joined: Dec 01, 2010 8:40 pm
- Full Name: Tom
- Contact:
-
- Veeam Software
- Posts: 3803
- Liked: 640 times
- Joined: Aug 28, 2013 8:23 am
- Full Name: Petr Makarov
- Location: Prague, Czech Republic
- Contact:
Re: SQL Object Restores Q
Hi Tom,
I guess it's because databases that exceed 10 GB cannot be attached to the Microsoft SQL Server Express Edition.
The Express edition is the entry-level database, mostly for learning and building desktop and small server data-driven applications. The Standard edition provides data management and BI for small organizations to run their applications and supports common development tools for on-premises and cloud.
Thanks!
I guess it's because databases that exceed 10 GB cannot be attached to the Microsoft SQL Server Express Edition.
The Express edition is the entry-level database, mostly for learning and building desktop and small server data-driven applications. The Standard edition provides data management and BI for small organizations to run their applications and supports common development tools for on-premises and cloud.
Thanks!
-
- Expert
- Posts: 192
- Liked: 9 times
- Joined: Dec 01, 2010 8:40 pm
- Full Name: Tom
- Contact:
Re: SQL Object Restores Q
I notice veeam 12 wants to use postgresql how will that impact the choice of sql express vs sql standard?
Thanks
Thanks
-
- Veeam Software
- Posts: 3803
- Liked: 640 times
- Joined: Aug 28, 2013 8:23 am
- Full Name: Petr Makarov
- Location: Prague, Czech Republic
- Contact:
Re: SQL Object Restores Q
Hello,
Basically, it should not impact the choice because you're talking about backend for the configuration database of Veeam B&R itself, it has nothing to do with the staging server that is needed for SQL objects restore or standalone database management. Moreover, you still have an option to choose the preferable database engine.
However, if you select Microsoft SQL and you're going to use Express edition as a staging system, the same 10 GB limitation will still be actual. If you select PostgreSQL, you won't be able to use Veeam B&R database instance as a staging system at all.
Thanks!
Basically, it should not impact the choice because you're talking about backend for the configuration database of Veeam B&R itself, it has nothing to do with the staging server that is needed for SQL objects restore or standalone database management. Moreover, you still have an option to choose the preferable database engine.
However, if you select Microsoft SQL and you're going to use Express edition as a staging system, the same 10 GB limitation will still be actual. If you select PostgreSQL, you won't be able to use Veeam B&R database instance as a staging system at all.
Thanks!
-
- Expert
- Posts: 192
- Liked: 9 times
- Joined: Dec 01, 2010 8:40 pm
- Full Name: Tom
- Contact:
Re: SQL Object Restores Q
Thank you for all the help.
Who is online
Users browsing this forum: No registered users and 63 guests